Consolidation and feeders

Post Reply
User avatar
rodrigo
Posts: 49
Joined: Tue Jun 03, 2008 10:34 pm
OLAP Product: TM1, Executive Viewer
Version: 9.4 MR1 with FP3
Excel Version: 2003

Consolidation and feeders

Post by rodrigo » Mon Jun 23, 2008 3:03 pm

Hi, guys I want to be sure of something,

If I have a C: element named Income (formed by local, inter and other) this feeder is correct?

SKIPCHECK;

['income'] = N: ['discount'] * .15;

FEEDERS;

['discount'] => ['income']; is ok?

probably i will not have a "not fed", but a C: can feed a N:?

Regards,

User avatar
Steve Vincent
Site Admin
Posts: 1052
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Consolidation and feeders

Post by Steve Vincent » Mon Jun 23, 2008 3:32 pm

Looks fine to me, you can feed from N to C but you'll have trouble if you try to feed C to N.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet

User avatar
rodrigo
Posts: 49
Joined: Tue Jun 03, 2008 10:34 pm
OLAP Product: TM1, Executive Viewer
Version: 9.4 MR1 with FP3
Excel Version: 2003

Re: Consolidation and feeders

Post by rodrigo » Mon Jun 23, 2008 9:44 pm

Thanks Steve, i just wanted to be sure.

Regards,

User avatar
Michel Zijlema
Site Admin
Posts: 706
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Consolidation and feeders

Post by Michel Zijlema » Tue Jun 24, 2008 5:36 am

rodrigo wrote:Hi, guys I want to be sure of something,

If I have a C: element named Income (formed by local, inter and other) this feeder is correct?

SKIPCHECK;

['income'] = N: ['discount'] * .15;

FEEDERS;

['discount'] => ['income']; is ok?

probably i will not have a "not fed", but a C: can feed a N:?
Hi Rodrigo,

If ['income'] is a C: element than the rule ['income'] = N: ['discount'] * .15 will not return a result, because of the N: prefix in the rule - this will make the rule calculate for N-level elements only. When you change your rule to ['income'] = ['discount'] * .15 the rule will calculate on a C-level (but then regarding all dimensions).

Please note that when you feed a C-level element you're in fact feeding the child-elements of this C-level element, not the C-level element itself. The C-level element will only "be fed" if at least one of it's children has a non-zero value (as you can't really feed the C-level element itself, with "be fed" I mean the consolidated element will f.i. show up correctly in a zero surpressed view).

Michel

User avatar
rodrigo
Posts: 49
Joined: Tue Jun 03, 2008 10:34 pm
OLAP Product: TM1, Executive Viewer
Version: 9.4 MR1 with FP3
Excel Version: 2003

Re: Consolidation and feeders

Post by rodrigo » Thu Jun 26, 2008 5:03 am

mmmh big mistake michael i wrote, sure a discount formula was

['discount']=N:['income'] *.15; (30+30+40)*.15= 15 usd discount!

trying to feed with

['income'']=>{'discount'};

i was on a hurry and suddenly i hit some button that moved the screen to another and when I refreshed it was blanked... i wrote it again quickly crossing a nonsense formula. sorry!

does it make a difference from steve[s answer? income is a C: that feeds a N: like discount

User avatar
Michel Zijlema
Site Admin
Posts: 706
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Consolidation and feeders

Post by Michel Zijlema » Thu Jun 26, 2008 8:08 am

Hi Rodrigo,

This rule/feeder looks OK to me.

Michel

adma76
Posts: 9
Joined: Mon Jun 30, 2008 8:07 pm

Re: Consolidation and feeders

Post by adma76 » Mon Jun 30, 2008 8:23 pm

Hi Guys,
My rule of thumb for writing feeders, seek for the feeder "trigger" (lowest level) , try to avoid feeding C: levels (a big temptation) it's can overfeed the model and damage the system performance.


Nice Day,
Aviad Malka
biconix-intl.com

ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: Consolidation and feeders

Post by ScottW » Mon Jun 30, 2008 11:16 pm

Hi Rodrigo,

In this case if the discount % is constant and doesn't vary by product/channel then you can do away with this rule alltogether and make discount a consolidation, the child income will have a weighting of 0.15.
Cheers,
Scott W
Cubewise
www.cubewise.com

Post Reply