Skip to Content
Apr 27, 2016 at 08:03 PM

Dimension Override based on Property


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.




Capture.JPG (52.2 kB)
Capture.JPG (29.8 kB)
Capture.JPG (49.0 kB)