Best Of

Hello Annika Fava,

as Felix Csanady said, the easiest way is to use the "dynamic selection"; you can use also the option "based on cube" and help the end-users of your application creating a "service cube" to be used in a first screen where choose through a "flag" what they want to be selected.

for example: in screen 1 the user select the "budget year"

then, in others screen you can save the "dynamic selection based on cube"

Hope this helps.

regards,

federico

Hi Dirk,

Interesting to hear your feedback regarding Board VBA Excel add-in, I have done only one Board VBA integration so far but this is what I would like to share.

All commands were sufficient to build what we needed. For example, when BCUBE function didn't provide the functionality we were looking for, then Board ADD-IN filled the gaps. It lets user to use BOARD dataview layouts in Excel just like in Board application. There you can use all slicing, dicing, filtering, sorting, apply algorithms, use flattened views and have multiple selections using "=SetSelection" function referencing the cells in Excel etc.

I can agree that documentation is short, hasn't been updated for a while and BCUBE function has its limitations. It would be interesting to hear if somebody has more information about its functions.

Hi Bas, 

In addition to what Björn explained you can find several applications of the time functions here Sample: Time Functions, this sample shows the Yearly Cumulated Value combined with cycle and the offset options. I think could be a good inspiration.

Hope this helps

Federica