How to feed consolidated element...

Post Reply
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

How to feed consolidated element...

Post by late.vaibhav »

Hi,

Recently I come to the situation where my leaf level cell are set to zero/ blank but at the consolidation I have applied one rule. I have written feeder for the same but as per my knowledge feeders will be applicable only for leaf level. So because of this my consolidated cell becomes NOT FED and disappears after zero suppress.
Kindly provide the solution where I don’t need to do any changes in METADATA.

Thanks in advance...

Regards,
Vaibhav Late.
User avatar
Elessar
Community Contributor
Posts: 413
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: How to feed consolidated element...

Post by Elessar »

Hi,
The only way is to create a (hidden) child element and feed it. The consolidated element is "fed" only when it has at least one it's child is fed.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
User avatar
PavoGa
MVP
Posts: 622
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: How to feed consolidated element...

Post by PavoGa »

Here is a good discussion about handling rule-driven consolidations and techniques to use for the issue you describe.

http://www.tm1forum.com/viewtopic.php?f=3&p=1512#p1512
Ty
Cleveland, TN
Post Reply