Hi,
I started having a strange problem in a TM1 cube, for one item in a dimension.
For this item, it does not display anything when you suppress zeros, however when you disable zero suppression it displays values in leaf items.
Moreover, for this item, it does not display any number in consolidation elements of other dimensions although there are values in leaf elements and although there is no C level rule to overwrite the consolidation.
This looks quite strange to me. Have you seen this happening before? and what might be the cause? and how can I fix this problem?
Thanks in advance for replies.
Regards,
Strange Behaviour in TM1 Zero Suppression & Consolidation
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Strange Behaviour in TM1 Zero Suppression & Consolidatio
What you are describing sounds like a classic case of an unfed rule calculation. When zero suppression is off and you right click one of the cells that disappears what do you see when you selectmce wrote:Hi,
I started having a strange problem in a TM1 cube, for one item in a dimension.
For this item, it does not display anything when you suppress zeros, however when you disable zero suppression it displays values in leaf items.
Moreover, for this item, it does not display any number in consolidation elements of other dimensions although there are values in leaf elements and although there is no C level rule to overwrite the consolidation.
This looks quite strange to me. Have you seen this happening before? and what might be the cause? and how can I fix this problem?
Thanks in advance for replies.
Regards,
- trace calculation?
- check feeders?
- mce
- Community Contributor
- Posts: 352
- Joined: Tue Jul 20, 2010 5:01 pm
- OLAP Product: Cognos TM1
- Version: Planning Analytics Local 2.0.x
- Excel Version: 2013 2016
- Location: Istanbul, Turkey
Re: Strange Behaviour in TM1 Zero Suppression & Consolidatio
Yes, this seems to be the case. I changed the code for feeders and it seems to be ok now.
Thanks.
Thanks.
-
- Posts: 15
- Joined: Fri Jul 23, 2010 9:49 am
- OLAP Product: TM1 10.2.2 Cognos Planning10
- Version: TM1 10.2.2 Cognos Planning10
- Excel Version: 2010
Re: Strange Behaviour in TM1 Zero Suppression & Consolidatio
I have the same issue can you please suggest wht you exactly did in feeders
- qml
- MVP
- Posts: 1097
- 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: Strange Behaviour in TM1 Zero Suppression & Consolidatio
Mate, surely you don't expect his feeders to be the same as yours and his feeder problem to be the same as yours?
Post your rules with feeder statements and a description of your problem and you are guaranteed to get help. The more detail, the better.
Post your rules with feeder statements and a description of your problem and you are guaranteed to get help. The more detail, the better.
Kamil Arendt