SAP Analytics Cloud for planning - Copy Data to specific Dimension Elements

[guenay]

Hi everyone,

I have a Dimension with the following elements: A, A1, B, B1, C, C1. It's a public dimension with properties.

For the master data of Dimension Elements A, B, and C, we have entries in the properties:

A = A1, B = B1, C = C1

We also have transactional data for A, B, and C, and we want to copy these values to their corresponding counterparts, which are specified in the properties.

Does anyone have an idea on how to set up an advanced formula for this without hard-coding, such as:

DATA(A1)=RESULTLOOKUP(A)

I'm looking for a more dynamic solution. Any suggestions?

Kind regards,

Ismail

[Susanne_Helbig · Accepted solution]

Hi @guenay,

you need to write your script like follows:

DATA([d/DIMENSION] = [d/DIMENSION].[p/PROPERTY]) 
= RESULTLOOKUP()

I hope this helps
Best regards
Susanne 

[guenay · Accepted solution]

Thanks a lot susanne. With your code and if condition i could set exactly what i wanted.