DESTINATION_APP *RENAME_DIM using a property from the target dimension

[maleodillet]

Hi Gurus,

I have a question with regards to a mapping between dimensions that I am trying to accomplish thru the DESTINATION_APP.

I have my source model X and my target model Y. I am Renaming DIM1 from model x to the members with PROPERTYdim1ID = DIM1 in DIM2 from model Y, is this possible?

*RENAME_DIM DIM1 = DIM2.PROPERTYdim1ID

where property "PROPERTYdim1ID" is a property of DIM2 in the target model which is mapped to DIM1 in source model

[former_member186338 · Accepted solution]

Sorry, but the dimension with property has to be in the source model, not in the target.

Source:

DIM1 Property: DIM2TARGET - containing member of DIM2 in target model.

Target DIM2

For this scenario you can use RENAME_DIM with:

*RENAME_DIM DIM1=DIM2

...

*REC(EXPRESSION=%VALUE%,DIM1=DIM1.DIM2TARGET)

Or you can use ADD_DIM with property:

*ADD_DIM DIM2=DIM1:DIM2TARGET

Please read help:

https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/f433f0bbc46c4a53860f1410f20f...

[maleodillet · Accepted solution]

Hi Vadim,

Sorry for the late response and thanks for the reply. I totally agree with you but the issue that I am facing is that DIM1 from the source model has a "1 to Many" relationship with DIM2 in the target model. That is why I was inquiring about possibly reversing the mapping process with *RENAME_DIM.

Is there a work around this with DESTINATION_APP?

"Source dimension members ID (DIM1) mapped to a property of the Target dimension members (DIM2)"

[former_member186338 · Accepted solution]

No way! No mapping using property in target dimension!

But you have to explain the required calculation logic in details, with examples and screenshots!

[Astha_M]

Hi,

Please try using below method:

In the Destination App, while writing *RENAME_DIM, write as *RENAME_DIM DIM1=DIM2

and further mention the destination members in record expression line as below.

*REC(EXPRESSION=%VALUE%,DIM2=DIM1.PROPERTY)

Hope it resolves your issue.

Thanks

Astha

[former_member186338]

Sorry, but syntax is incorrect here:

"*REC(EXPRESSION=%VALUE%,DIM2=DIM1.PROPERTY)" - has to be DIM1

Also, the question was about property in the dimension of the target model - not possible!