Page 1 of 1
Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 3:20 pm
by 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
Re: Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 5:08 pm
by 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?
Re: Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 5:32 pm
by 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.
Re: Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 6:04 pm
by Emixam
What is the format of that 'Exception' cell ? If you right click on the cell and select 'Trace Calculation...' what do you see ?
Re: Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 6:08 pm
by 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!
Re: Zero Supression and C-level Rule 0 value
Posted: Thu Feb 25, 2021 8:53 pm
by 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 !
Re: Zero Supression and C-level Rule 0 value
Posted: Fri Feb 26, 2021 6:31 am
by Elessar
Emixam wrote: ↑Thu Feb 25, 2021 8:53 pm
I guess that's how TM1 works !
Yes, exactly:
- Calculate consolidations
- Suppress zeroes
- 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.