Writing C-element in LHS of feeder statements

Post Reply
harrytm1
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

Post 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
Planning Analytics latest version, including Cloud
Gregor Koch
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

Post by Gregor Koch »

Using !Version results in Case 1
Using 'Ver Grp1' results in Case 2
Cheers
Post Reply