Skip to Content
Former Member
May 27, 2010 at 11:04 AM

Function to derive Property values



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