Dimension Override based on Property

[Former Member]

Hi People,

I'm having one issue with Dimension Override based on Property.

I have Time dimension in Column Axis, and

ZKM_PRODUCT - Product and ZKM_OWNER - Owner dimensions in row axis , ZKM_OWNER is the property in ZKM_PRODUCT Dimension.

and I have Hierarchy for ZKM_OWNER Dimension like below

So if i use =EPMDimensionOverride("000","ZKM_PRODUCT","ZKM_OWNER="&B9) then my report works fine,Currently B9 has "P1" it is a base level of P Hierarchy in ZKM_OWNER Dimension.

But If i choose B9 cell as "P" then it should display three Products (See above first picture - Master data of Product) but it is not happening.It is working very wired.

Could you please let me know, how i can do Dimension override based on Property, if property has hierarchy.

Thanks,

Vishu

[Former Member]

Dear Vishu,

You can achive it by using BAS(). But you should difine the BAS() using "Concatination" of the cells.And you have to refer the concatinated cell in the Dimension override.......as shown below.....

Kindly refer the below screenshot for detailed explination...

Aravind

[former_member186338]

Hi Aravind,

Your proposal is not related to the question It's Override by property, not by member!

Vadim

[Former Member]

Hi vadim,

Yes, I agree with you vadim,It was my understanding mistake. By seeing the requirement at first glance i thought that the property is calling in the cell & based on that member owner dimension need to be override. But now i got it, It was totally reverse.

As vadim said, by adding another hirerchy in the product based on owner will fulfil the requirment.

Aravind