Forum Discussion

fc's avatar
fc
New Contributor III
12 months ago

Cube view rows suppression

Hi all,

I'm struggling to understand how the setting "Use suppression settings on parent rows" in cube views works. 

I have this simple CV showing a list of accounts in the rows (1C205000 and descendants) and time in the columns:

in the rows "Advanced" section, I set the following:

my expectation here is to have all invalid, nodata or zero rows suppressed, except for the parent row (which I expect to be the row corresponding to the account 1C205000). 
However, when I launch it, also the parent row gets suppressed and I end up not seeing anything. 


What am I doing wrong?

Thanks in advance for any help!

  • Suppression will depend on columns settings as well, if the "Use To Determine Row Suppression" option is set to True on any of them.

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    Suppression will depend on columns settings as well, if the "Use To Determine Row Suppression" option is set to True on any of them.

  • Hi FC,

    I haven't tried it out but add a ",A#1C205000" after the call with "... .TreeDescendatntsInclusive". I think that should work.

    Best regards,

    Carlos

  • fc's avatar
    fc
    New Contributor III

    Thank you JackLacava the problem was indeed these 2 column settings that were previously set to True: