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.