Dynamic EPMDimensionOverRide

[Former Member]

Hi All,

I have Dimension_A with properties_1, properties_2

=EPMDimensionOverride("000","TIME","properties_1=Y")

How do I make the properties name in the above formula become dynamic based on user selection?

I tried following but it doesn't work :

=EPMDimensionOverride("000","TIME","&variable=Y")

Thanks in advance.

[dinesh_veluru · Accepted solution]

Hi U-one u-one,

please have properties in once cell and refer the cell in epmdimension override formulae.

cell A1 will have Propertie_1=y,properties_2=y

then =EPMDimensionOverride("000","TIME",A1)

please refer below thread for different senarios.

Thanks,

Dinesh.V