Skip to Content
0
May 19, 2016 at 05:24 PM

Issue with dimesions proeprty value

42 Views

Hi experts,

Got one issue, in which we are loading the dimension property value of some dimension members from BW object and property value of some of dimension members are being updated manually. Issue is, when I load the master data. the BW property values that are overwriting the manually enter property values of dimension members. How could I avoid this.

Example: I have GL_CODE dimension. in which I have two types of dimension members (1) GL_CODE that are being downloaded from BW objects (2) GL_CODES that are being manually created in the dimension. We have created a Property value "SOURCE_SYSTEM". Now

(1) for GL code, which are coming from BW info object have property value of "SOURCE_SYSTEM" is "BW".

(2) for GL codes, which are being created manually have property value of "SOURCE_SYSTEM" is "MANUAL"

Now when I run Data Manager Package to load GL code Master data, it brings the property value "BW", but it overwrites the manually created property value, which are "MANUAL".

I have written transformation file as below

*MAPPING

ID=ID

SOURCE_SYSTEM=*STR(BW)

The above overwrites the manually enter property value with blank.

If I write transformation file like below

*MAPPING

ID=ID

SOURCE_SYSTEM=*IF(SOURCE_SYSTEM=*STR() then *STR(BW))

But in this case, I get the error that SOURCE_SYSTEM is not available in source object, which is correct.

If I write transformation file like below

*MAPPING

ID=ID

SOURCE_SYSTEM=*IF(ZSRCSYSTEM=*STR() then *STR(BW))

in this case, if user forgets to manually enter property value of "SOURCE_SYSTEM" of manually created GL code, it will also take property value "BW", which I want to avoid.

Nothing worked for me. Please suggest

Regards,