Best Of

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 

Hi Neha,

To be honest, I just can't envisage how a data-view with 400,000 x 40,000 entity members on row is even practical.  Do you actually have users who want to see a data-view with this total number of rows?  For me, as a consultant, if I was faced with this I would be asking the customer:
- do users have only a specific sub-set of the entity members that they are concerned with?

- could database security, or some kind of configuration matrix be used to determine which combinations display for any particular user?

- alternatively, are there logical groups that could be added to display the data at a more aggregated level, with users having the ability to drill-down to lower-level detail when needed (which would only be a small sub-set of the total entity members)?

You're not going to be able to get around any physical limitation on the number of rows that Board can display ... and, as I say, even if you could, would you really want to?  Just because you CAN do something, doesn't necessarily mean you SHOULD do something

Hi Neha,

Think of "Detail By" as over-riding (for the particular block) whatever you have set in the "Row" axis of the layout.  You could have "Month" in the axis, but if you set "Detail By" to "Year" (for example) for a particular block, then you would see the value of that block by "Year", with any other blocks (that don't have "Detail By" set) shown by "Month".

In your particular case, though, you want a certain block (the "Product Category" Entity) to appear only once, but the other blocks to appear by "Month".  The simplest way to do this is to not put any Entity on the "Row" axis, and then use "Detail By" / "Month" on the other blocks in the layout.  (Note that Board requires the first block in a layout to be a cube, not an entity, so you'd need to just put a cube as block "a" (make sure it's hidden), then your entity as block "b", then followed by the cube that has your values as block "c" (with "Detail By" / "Month").

Try this first, and see how you go.  Sometimes you might want to do a similar thing, but you actually want multiple entities on the "Row" axis (eg. "Year" and "Month") - there's a different trick when this is the case, but I don't want to confuse you too much just yet.  Let me know how you go with the above suggestion first, and if it achieves your desired result.

Cheers,

Craig Parris