Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 23, 2017 at 12:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23, 2017 at 03:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded