selecting multiple properties in dimension override

[Former Member]

Hi Gurus,

I am trying to override my Project dimension which has two properties which are also dimensions in my case.

Property 1: PI

Property 2 PH

I have put dimensionproperty values in cell c7 and c8 respectively

tried both of these but there is an error

SYNTAX 1: =EPMDimensionOverride("000","project",PI=C7;PH=C8)

SYNTAX 2: = EPMDimensionOverride("000",project","PI="&C7;"PH="&C8)

Please help

Thanks

[Shrikant_Jadhav · Accepted solution]

Hi Krishna,

Write formula in one cell like below

="PI=&C7&";PH="&C8 and refer this cell in dimension override formula.

"; "is AND operator.

Go through below link for more details

Shri

[Former Member · Accepted solution]

Hi Shrikant,

I tried doing this it has some syntax error attached

[Shrikant_Jadhav · Accepted solution]

Sorry my mistake , find correct one

="PI="&C7&";PH="&C8

[Former Member · Accepted solution]

Works perfectly thank you

Krishna