Zero Supression and C-level Rules

Post Reply
Willi
Regular Participant
Posts: 151
Joined: Mon Oct 07, 2013 11:51 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Zero Supression and C-level Rules

Post by Willi »

Hi,

working on TM1 10.2.2 I have a simpe consolidation and want per C-Level Rule to set aome of them explicitly to 0 for Zero-Suppression even if Leafs are Nonzero. Cube-Viewer Shows me that the Elements are set correctly but Zero-Supreession does not work. Even with Zero-Supression the cells are shown!?

Best regards
Attachments
ZeroSupression.JPG
ZeroSupression.JPG (33.32 KiB) Viewed 2613 times
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Zero Supression and C-level Rules

Post by tomok »

What you are attempting will not work. Overriding a consolidation, via a rule, to make it zero will not mean that node will disappear when zero-suppressed. Your only option is for all the leafs to be empty or for all of them to be weighted as 0.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Willi
Regular Participant
Posts: 151
Joined: Mon Oct 07, 2013 11:51 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Zero Supression and C-level Rules

Post by Willi »

Waht a petty. But thanks. I'll look for another solution.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Zero Supression and C-level Rules

Post by qml »

What tomok is saying is right. You can therefore use 0 weightings to achieve the result you want. If the weight is 0 on all elements that have numbers in them then the consolidation will be hidden a zero-suppressed view. This applies whether you have a C-level rule on the consolidation or not.
Kamil Arendt
Post Reply