Showing results for 
Search instead for 
Did you mean: 

Function to derive Property values

Former Member
0 Kudos


I want to derive the Property values of certain Members of a dimension.

Is it possible?

I know that we can use EVPRO to derive. but the EVPRO need a value as a parameter ( which points to value of some cell or have hardcoded value in " ") and it pulls value for one member only.

Is it possible to expand these values, based on the value hardcoded?


Using EVEXP we can expand Id values or ParentH1 members for any dimension.

Similarly is it possible to derive or expand all the values of a Dimension property like "GROUP" etc?

Pls help

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos


You can have all he harcoded value. To expand you can write the function in first cell of the column. during expansion it will be copied to all the cells in the column.



Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Madhuri,

After the column of the members, add another column for your property. In the first cell, write the EVPRO function based on the corresponding member ID. Once you expand the template, the same function will be copied to other cells also.

Hope this helps.