In BPC DIMENSION, property value has to be changed to a different indicator.

[Former Member]

In Category dimension, I have a property indicator as Y. I pull these category members which have property set as Y and perform some tasks. After that I need to set the indicator to e.g C. Is there a way to change the property value , preferably by package run as it has to be automatised to run quarterly.

Suggest if any other options are available for changing the value of dimension property.

Regards

Srinivas Koneti

[former_member186338]

Do you have so many CATEGORY members to have issues to change the property in the WEB administration???

Another option is to write custom logic badi based on: https://archive.sap.com/documents/docs/DOC-4276

[Former Member]

Hi Srinivas,

One way can be...first export the category dimension in a flat file using Export DMP and then again Import the master data in system. But while importing data again just change the property value using transformation file & upload. You can run all these packages in a package link for automation.

For example...Transformation file for Import would be

ID= *COL(1)

INDICATOR= IF(*COL(2)=*STR(Y) THEN *STR(C); *COL(2))

Hope this helps...

JP

[Former Member]

Thanks JP , for the inputs.