Best Of

Hello William Le,

from Board Manual, about the Report Rows Upper Limit (middle of the page) :

When a user requests a report, before executing it, the Board Server estimates the number of rows the report has by multiplying the number of selected occurrences of the entities set by row. If the number of estimated rows exceeds the limit, then the report is not executed.

You'are using a lot of entities by row: try to "select" only some (populated, maybe? consider using the "select based on" option) occurrences.

You should get your report.

Remember that if you want you can also increase the Row Upper Limit from the Board Server Configuration; the maximum number is 2000000000.

An advice: Board gives to the user many objects to create a "dynamic, lighter and more usable screen" (consider that the screen could be opened also by a tablet/smartphone): increasing the Row Upper Limit is not always the best option.

Hope this helps.

best regards,

federico

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