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

[Former Member]

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

[former_member186338]

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