Advice on feeder statement

[harrytm1]

Hi all,

I have a question on feeder statement. In the sample below, I wish to apply the feeder statement only to all n-elements under the parent "ASSET". The cube is Balance Sheet.

If I write ['Asset', 'BSMEA002'] => ['Asset', 'CALC_BSMEA002'] or ['Asset', 'BSMEA002'] => ['CALC_BSMEA002'] (which has the same effect), I suppose it will cause a permutation amongst the children within Asset parent. If there are 10 elements under Asset, then it will be 10x10 permutation, which is not what I want. Correct?

So I'm thinking of writing it this way:

['ASSET', 'BSMEA002'] =>
DB('Balance Sheet', !Entity, !BS Account, !Product, !Period, !Year, !Version, 'CALC_BSMEA002');

I'm assuming that by using !BS Account, even if 'Asset' is stated on the LHS, the DB statement will cause the feeder to apply 1-to-1 for each element. Is my understanding correct?

Many thanks in advance!

[kpk]

Supposing that Asset is a consolidated element with children (A1, A2,...,An):

['Asset', 'BSMEA002'] => ['Asset', 'CALC_BSMEA002'] or ['Asset', 'BSMEA002'] => ['CALC_BSMEA002']
means
['A1', 'BSMEA002'] => ['A1', 'CALC_BSMEA002']
['A2', 'BSMEA002'] => ['A2', 'CALC_BSMEA002']
...
['An', 'BSMEA002'] => ['An', 'CALC_BSMEA002']

So there will be no 10x10 permutation.

[harrytm1]

Thanks for your reply.

So in this case, both the shorthand and longhand way of writing the feeder achieves the same effect i.e. one to one feeding.

[tomok]

Any time you are writing a rules statement using the shorthand notation (with the [] brackets), elements not specifically spelled out means use only those that match. For example, if I have a cube with three dimensions; Version, Account and Month, then the statement [Budget] = [Actual]; means Budget will equal Actual in the Version dimension for all corresponding Account and Month elements. It doesn't mean that Budget for Account 120000 for January will equal Actual for all accounts for all months. That doesn't make any logical sense.

[harrytm1]

Noted. So the shorthand way is ok. As long as the consolidation is stated in the LHS, and if it is not stated in the RHS, TM1 will apply the feeders for the underlying n-elements one-to-one instead of permutations.

Thanks!