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
Zero Supression and C-level Rules
-
- 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
- Attachments
-
- ZeroSupression.JPG (33.32 KiB) Viewed 2613 times
-
- 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
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.
-
- 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
Waht a petty. But thanks. I'll look for another solution.
- 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
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