EPMDimensionOverride do not filter by Property(Text)

[Former Member]

Hello,

I have an issue when I want to doing Override the dimension based from Property.

if the property is number like: 1001 it works well the system do the job.

if the property is text like "SAP BPC" or "SAP ABC" it does not filter.

=EPMAxisOverride("000",TRUE,"PRODUCT",H22,"SUPPLIER","ID= V")

H22: ="P1001T= SAP BPC"

with number it works well

Any reason?

Cheers

[former_member186338 · Accepted solution]

Filter on property with space inside the value? Bad idea in general!

You may try to use:

H22: ="P1001T= 'SAP BPC'"

But I recommend to use something like SAP_BPC as a property value!

Vadim