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

Function to derive Property values

28 Views

Hello

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?

example:

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