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
Writing C-element in LHS of feeder statements
-
- Regular Participant
- Posts: 226
- Joined: Thu Apr 02, 2009 2:51 pm
- OLAP Product: IBM Planning Analytics
- Version: Latest version
- Excel Version: 2003 to 2019
Writing C-element in LHS of feeder statements
Planning Analytics latest version, including Cloud
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Writing C-element in LHS of feeder statements
Using !Version results in Case 1
Using 'Ver Grp1' results in Case 2
Cheers
Using 'Ver Grp1' results in Case 2
Cheers