Feeder for C level calculation

Post Reply
User avatar
macsir
Community Contributor
Posts: 520
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Feeder for C level calculation

Post by macsir » Fri May 18, 2018 1:26 am

Hi, guys

If I am calculating C level average

Code: Select all

['Average XYZ'] =C: ['ABC'] \ ['EFG'];
and user don't need this average at N level and don't care about the Zero Suppression,
I won't use any feeder for this to gain the max cube performance. ( ['ABC'] , ['EFG'] are all real numbers.)
Is that true?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

lotsaram
MVP
Posts: 3091
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: Feeder for C level calculation

Post by lotsaram » Fri May 18, 2018 5:35 am

And if you were to write a feeder then what exactly do you think you would feed or need to feed?

Feeders are an exclusively LEAF LEVEL concept. They exist for one purpose only: to enable consolidation of rule calculated leaf cells. Where no consolidation is required ergo no feeding is required. C level rules therefore by definition never require feeding since if any feeding is to be done it is at leaf level.

In your case the best solution is simply to make "Average XYZ" the parent of "ABC and "EFG".
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
macsir
Community Contributor
Posts: 520
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Feeder for C level calculation

Post by macsir » Sat May 19, 2018 12:34 am

Sorry, maybe title is confusing, what I mean is feeder for Average XYZ at N level to enable right consolidation. Since it is just doing average at C level and no zero suppression required, I really don't think feeder for Average XYZ at N level is not needed.
I am aware of making "Average XYZ" the parent of "ABC and "EFG" but that will change the measure dimension structure, which I don't want.
Thanks for advice anyway.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/

Post Reply