Zero Supression and C-level Rule 0 value

[rameez]

Hi,
I have a rule that applies to both N and C levels. There are instances where the value of Consolidation might be zero, but the N level might have values. The issue is when zero suppression is on while only looking at C level zero values are not suppressed.

Code: Select all

SKIPCHECK;
['Exception']= ['Value'] * ['Factor'];
FEEDERS;
['Value'] => ['Exception'];

I will have more dimensions in the cube with various consolidations, so setting up the element weight to 0 is not going to work.
Any thoughts?

Thank you in advance

[tomok]

I'm not sure what you are expecting here. The highlighted cell is not going to suppress from a column perspective because there are values for other rows in the same column and it's not going to suppress from a row perspective because there are values for other columns in the same row. That's how zero suppression works in TM1. Were you expecting something else?

[rameez]

Hello Tomok,
I was showing it expanded for clarity.
When the Period dimension is collapsed to only show Consolidation. It is not suppressing the exception column.

See collapsed screenshot.

[Emixam]

What is the format of that 'Exception' cell ? If you right click on the cell and select 'Trace Calculation...' what do you see ?

[rameez]

Trace Calculation shows 0.
I tested it out by slicing it to excel and divided a value by the exception to prove it to myself that it is indeed a zero as I got #DIV/0!

[Emixam]

You still see the 0 on the consolidation element because you try to override a consolidation with rules. The zero-suppression will not make that intersection disappear because if there was no rules on C: level, the value would not be 0. I guess that's how TM1 works !

[Elessar]

I guess that's how TM1 works !

Yes, exactly:

1. Calculate consolidations
2. Suppress zeroes
3. Override consolidation value with C: formula

If you have at least one fed/input cell in consolidation's children, it will not be suppressed with zero suppression.