EPMDimensionOverride

[former_member695137]

Hi Gurus,

How to pass more than one value of the same property from a dimension in EPMDimensionOverride function.

This works fine with single value of property with EPM function =EPMDimensionOverride(“000”,”WBS_ELEMENT”,”WBS_PCTR=”&B9) but I need to pass multiple values

Ex:-

   ID                                   WBS_PCTR

E.XXXXXX	1001
E.XXXXXX.XX	1001
E.XXXXXX.XX	1001
E.XXXXXX.XX	1001

E.XXXXXX	1003
V.XXXXXX	1003

Any advice is much appreciated. Thanks in advance.

regards

Abhay

[former_member186338 · Accepted solution]

The question is - how the column with member ID's is generated? Is it fixed or variable?

Vadim

Correction:

Ups, you simply want to use multiple values of the same property with "OR"? Then Prashant is absolutely correct - "," means "OR"

[former_member695137 · Accepted solution]

thanks for the reply's gurus. Values are dynamic and they must be picked up from the context of another dimenssion. Base members of profit center.

For now I got this with Epmcontextmember but this is not correct. please advice.

Kind regards

Abhay 

[former_member695137 · Accepted solution]

Hi Vadim,

My requirement is not just to use multiple values of the same property. By using OR or "," I am getting the WBS elements which are not assigned to the profit center. I want only the WBS's assigned to a PC and, when PC parent is selected I want to display all the PC's and the assigned WBS's for each PC.

Please advice .

Regards

Abhay

[former_member186338 · Accepted solution]

Sorry,

But "I want only the WBS's assigned to a PC and, when PC parent is selected I want to display all the PC's and the assigned WBS's for each PC." - absolutely not clear!

Please explain with some example!

Vadim

[Former Member]

Hi Abhay,

You Can use =EPMDimensionOverride("000", "WBS_ELEMENT","WBS_PCTR="&B9&","&"WBS_PCTR="&B13)

Thanks

Prashant