Skip to Content
avatar image
Former Member

Derivation of dimension value based on property of property of another dimesion in script logic

Hi,

Please let me know can we achieve derivation of property of dimension value based on the property of another dimension in script logic

For example

Property of Cost center is Profit Center and

Property of project is Cost center

I wanted to derive profit center from the cost center which is the property of project

Profit center = Property of Costcenter which is again a property of project

Thanks

Sekar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 04:28 PM

    Hi Sekar,

    Unfortunately you can have only one level of derivation!

    To read derived data - use LOOKUP by property: *DIM LABEL:DIMNAME1=DIMNAME2.PROPERTYNAME

    To store result - use DIMNAME1=DIMNAME2.PROPERTYNAME

    But in this case you can create 2 properties in the PROJECT dimension: CC and PC and use both in LOOKUP or target override.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded