a for loop?

a for loop?

Essbase guy
Essbase guy

January 9th, 2017, 8:45 pm #1

Hello,

Any help would be much appreciated.

Here is the scenario...

This is in the organization dimension (sparse) ,

I have members named PPC_XXXX ,this member is a parent. I want to take the values at the PPC_XXXX level and copy them to a stored member in another hierarchy in the org dimension with the name XXXX, i.e. would cut off the "PPC_" .

In pseudocode,

For all children of this member copy the data to the member
that has the source name, except for the first four characters.

Thanks!!
Quote
Share

Pete
Pete

January 10th, 2017, 12:49 am #2

@XWrite with @LOOPBACK? You should be able to do it with a @NAME(@MEMBER(@SUBSTRING function in it I'm fairly sure.
Quote
Share

Joined: March 4th, 2014, 5:57 am

January 10th, 2017, 6:35 am #3

@MEMBER(@CONCATENATE(@SUBSTRING()))) ->FY2017 = FY2017
Quote
Like
Share


Confirmation of reply: