Zero Suppression and Undef

Post Reply
HighKeys
Posts: 69
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Zero Suppression and Undef

Post by HighKeys » Fri Mar 20, 2020 9:32 am

Hello Community,

i'm woundering how to solve the issue that 0 values calculated in Rules are still get showed in a Zero suppressed View, i found in the docs i could assing the "Undef" Value (which means no data input and not a real 0 (it would be data input), if i understand it right).

But now the Value get shown as #N/A, if i use 0 then "undef" it get shown in the zero suppressed view.


How can i solve this?

The Rule Code:

Code: Select all

['Abwesenheiten rMA', 'HR'] = IF(ELISPAR('Kennzahlen Personaleinsatz-Reporting', 'Brutto Einsatz rMA', 'Abwesenheiten rMA') = 1, UNDEF, Continue);
#Or
['Abwesenheiten rMA', 'HR'] = IF(ELISPAR('Kennzahlen Personaleinsatz-Reporting', 'Brutto Einsatz rMA', 'Abwesenheiten rMA') = 1, 0, Continue);
Thanks

HighKeys
Posts: 69
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Re: Zero Suppression and Undef

Post by HighKeys » Fri Mar 20, 2020 12:03 pm

In the same Cube, i tried to get an AVG in a C Element but it also count the 0 values.

Code: Select all

C:ConsolidatedAVG(2, 'Personaleinsatz-Reporting', !Tag, 'HR', !MA-Pool, !Kennzahlen Personaleinsatz-Reporting);
Flag is Set to 2
consolidatedAVG.PNG
consolidatedAVG.PNG (2.85 KiB) Viewed 75 times

User avatar
Steve Rowe
Site Admin
Posts: 2000
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Zero Suppression and Undef

Post by Steve Rowe » Fri Mar 20, 2020 3:35 pm

If you are using those consolidated functions then make sure you read this tech note https://www.ibm.com/support/pages/node/3117345

As to the issue in the initial post if you set the rule to N level only you should find the suppression works.

Post Reply