Writing C-element in LHS of feeder statements
Posted: Fri Feb 17, 2012 2:10 am
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
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