Page 1 of 1

Writing C-element in LHS of feeder statements

Posted: Fri Feb 17, 2012 2:10 am
by harrytm1
Hi all,

I understand that writing a C-element on the left hand side of the feeder statement is a shortcut; the end result is the underlying n-elements will do the feeding. Here is a scenario:

In the Version dim, there are 3 n-elements: A, B and C. They all roll up to a parent "Ver Grp1".

A feeder statement is written to feed from Cube X to Cube Y:

['Ver Grp1', 'Mea1'] => DB('Cube Y', dim1, dim2...., !Version,....);

Question:
Do the feeder behave like the following?

Case 1
A => A in Cube Y
B => B in Cube Y
C => C in Cube Y

OR Case 2
A => A, B and C in Cube Y
B => A, B and Cin Cube Y
C => A, B and Cin Cube Y (i.e. permutation across all elements in the rollup)

Question:
Instead of using !Version in the RHS, does it achieve the same result above (whether it is Case 1 or 2).
['Ver Grp1', 'Mea1'] => DB('Cube Y', dim1, dim2...., 'Ver Grp1',....);

Look forward to your reply. Have a good weekend ahead!

Harry

Re: Writing C-element in LHS of feeder statements

Posted: Fri Feb 17, 2012 2:47 am
by Gregor Koch
Using !Version results in Case 1
Using 'Ver Grp1' results in Case 2
Cheers