EPMDimension Override using multiple property

[Former Member]

HI People,

I have WBS Dimension in row axis and Cost centre & Company code are in Coloum axis.

And had Cost centre and Company Code as a property in WBS Dimension.

I am trying to override my WBS dimension using two properties (Cost centre and Company Code) and it is not working but it is working if i try to override using any one of single property?

Used formula : =EPMDimensionOverride("000","GII_WBSELE","COST_CENTER=C3 AND COMPANY_CODE=C4")

PS let me know if any was wrong?

Thanks,

Vishu

[former_member186338 · Accepted solution]

What do you mean "it is not working"?

Vadim

[Former Member · Accepted solution]

Mean that it is not overriding WBS dimension based on properties on C3 And C4 cell values.

-Vishu

[former_member186338 · Accepted solution]

If you are talking about the formula:

=EPMDimensionOverride("000","GII_WBSELE","COST_CENTER=C3 AND COMPANY_CODE=C4")

And properties are in C3 and C4 then the formula has to be like:

=EPMDimensionOverride("000","GII_WBSELE","COST_CENTER="&C3&" AND COMPANY_CODE="&C4)

[Former Member · Accepted solution]

Thanks vadim for correcting my formula.

And noticed this formula is not working on SP 17?

-Vishu

[former_member186338 · Accepted solution]

No idea about SP17 - too old!