Dimension Override is not working

[Former Member]

Hi Experts,

I have a report and have Dimension override on Category (based on Active Category property) dimension , so based on Dimension override function i should see Actual data but it is not happening as I have set"Y" values on ACTIVE CATEGORY property for Actual only.

But input template is taking Category member from Context always when i refresh.

Please see BPC Category dimension master data.

Input template

Thanks,

Vishu

[Former Member]

Hello Vishu,

It works definitely !! please find screen shot for simple scenario

Replace Level='Your Property Name'

             Plan='Your Member'

[Former Member]

If it is not working in your system, please try it once in other system.

else,..........Hope please check system configuration(SP Levels etc..) once.

[Shrikant_Jadhav]

Hi Vishu,

First thing, use property ID in formula, then modify your formula as below

=EPMDimensionOverride("000","CATEGORY","ACTIVE_CATEGORY="&B8)

Assuming that technical name of property is ACTIVE_CATEGORY.

Shri

[Former Member]

No there was no underscore.

Actually i was tried two scenarios like but i shared you screen shot of second scenario.

=EPMDimensionOverride("000","CATEGORY","ACTIVE CATEGORY=Y") as well as cell referring =EPMDimensionOverride("000","CATEGORY","ACTIVE CATEGORY=B6")

Even i tried to create new property and set Y value on it for actual category but still Dimension override is not working.

Do you think this problem causing due to any security setup?any idea why report is taking from Context instead of Dimension overrride?

Thanks,

Vishu

[former_member186338]

Property name has to be without space inside!

Vadim

[Former Member]

Hi Vadim,

Even i tried with new property without Space Like ACTIVE_CATEGORY.

-vishu

[Shrikant_Jadhav]

Security is second part, but property ID has to be without space, share structure of dimension.

Shrikant

[former_member186338]

With property id like ACTIVE_CATEGORY it will definitely work! Please show screenshot!

P.S. Sample look on property ID: