Feeder for C level calculation

Post Reply
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Feeder for C level calculation

Post by macsir »

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: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Feeder for C level calculation

Post by lotsaram »

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
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Feeder for C level calculation

Post by macsir »

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