Using multiple referenced Properties within EPMDimensionOverride

[sebastian_hagl]

Hi experts,

there's my question: I'd like to override dimension members of a specific dimension based on two properties, which come from excel cells.

The following IS working:

One property with one Cell-Reference:

=EPMDimensionOverride("000","MyDimension","Property1 =" &CellReference1)

Two  Properties with static property names:

=EPMDimensionOverride("000","MyDimension","Property1 = Value; Property2 = Value")

What IS NOT working (but needed);

=EPMDimensionOverride("000","MyDimension","Property1 =" &CellReference1;","Property2 =" &CellReference2)

I hope it's a syntax thing.

Any suggestions?

Thx

Sebastian

[Shrikant_Jadhav · Accepted solution]

Hi Sebastian,

Kindly refer blow document for -

Shrikant

[sebastian_hagl · Accepted solution]

Works great thx a lot!