Hide specific rows

gmaiolico
gmaiolico Active Partner
Board Developer Name Dropper First Comment Photogenic

Hi BOARD Community,

I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below

I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot.
With that being said, how can i hide the undesired rows?

Tagged:

Answers

  • Hi,

    Adding an algorithm with IFs taking as inputs your dimensions and that will return value = 0 for the undesired combinations and 1 for the ones that you need + then adding a filter on that data block to exclude 0 values could be an option if there aren't too many possible combinations to exclude/include.

    Best regards,

    Adrien

  • If the conditions are too complex, you could consider to flag the combinations in an additional cube and use it in your dataview as filter or in an algorithm multiplicating the data of your real cube by the value on this flag cube (0 or 1) according to the validity of the combination.