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]

Vishu,

I don't think you could use the hierarchy the way your thinking in a single step.  You would need to make it a two step process: first determine the base members from the input owner hierarchy, and then apply that result to the epmdimensionoverride formula with proper and/or logic.

Thanks,

Ryan

[Former Member]

Hi Ryan,

Thanks for the replay.

Could you please explain me in more details, how i can do with two steps ?

Thanks,

Vishu

[former_member186338]

Hi Ryan,

Unfortunately with 2 reports (first to get base members of owner and perfom concatenation of the override string in the local member, second - actual report with override based on first report) you will have to refresh twice Like here: