Feeder - Left and right sides

Post Reply
jyoung66
Posts: 24
Joined: Fri Aug 13, 2010 2:14 am
OLAP Product: TM1
Version: PAW 2 PAX
Excel Version: 2016

Feeder - Left and right sides

Post by jyoung66 » Wed Sep 25, 2013 11:58 pm

I have been told that with feeders you have to take care to "balance" the left and right sides

Take the following example: ['Account1','Version1']=>['Account2'];

Here 'Account1','Version1 will feed Account2 for ALL VERSIONS, not just version1, as I haven't specified to only feed Version1 on the right hand side

The correct and proper way to feed it is

['Account1','Version1']=>['Account2', 'Version1'];

IS THIS CORRECT? or have I been misinformed?

Others have told me that the right hand side inherits the left, as rules do

EvgenyT
Community Contributor
Posts: 275
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: Cognos TM 1
Version: 10.2.2
Excel Version: 2013
Location: Sydney, Australia

Re: Feeder - Left and right sides

Post by EvgenyT » Thu Sep 26, 2013 12:12 am

Nope, I think you have been misinformed...
['Account1','Version1']=>['Account2'] - Account / Version 1 would only feed Version 1 in Account 2

target would naturally balance, Unless you feed consolidation on the RIGHT side then all of the children would be fed.

You can see it for yourself by Tracing Feeders ...

thanks

ET

lotsaram
MVP
Posts: 3303
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Feeder - Left and right sides

Post by lotsaram » Thu Sep 26, 2013 7:30 am

jyoung66 wrote:Take the following example: ['Account1','Version1']=>['Account2'];

Here 'Account1','Version1 will feed Account2 for ALL VERSIONS, not just version1, as I haven't specified to only feed Version1 on the right hand side

The correct and proper way to feed it is

['Account1','Version1']=>['Account2', 'Version1'];

IS THIS CORRECT? or have I been misinformed?
Misinformed. Think of the left hand side as a filter. Everything fed on the right will be a match to the filter on the left except for he elements specifically named on the right which "redirect" the feeder.

Note the major point of difference between rule and feeder references is that the "filter" for the LHS of a rule is like a point reference, if C elements are named then the rule applies only to the C elements and not their descendants. But feeders operate only at the leaf level and therefore naming a C element on the LHS of a feeder is simply shorthand for feeding from all underlying leaf elements, similarly naming a C element on the right of a feeder feeds ALL the ultimate N level descendants.

Post Reply