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

[david_ings]

Hi Vishu,

If you try something like this..

=EPMDimensionOverride("000","ZKM_PRODUCT","ZKM_OWNER="BAS("&B9&")")

..then it will always return the base value. So if you pick a base member such as P1, it will still return P1, but if you pick the parent "P" then it will return the three base members of P.

David

[former_member186338]

Hi David,

Why do you think that BAS will work in this case at all???

Vadim

[david_ings]

Hmm yes, I've misread the dimensionality.

Still, I think there could be ways around this. A couple of examples below, by all means not perfect at all but might get you what you need.

For example:

- Create another property e.g. ZKM_OWNER_PARENT or something

- Populate with P for those that relate to P1-3 (Cosmos etc)

- Then some logic in the worksheet that says, if owner selection Calc=y (or something similar to identify when user selects the parent), then override based on the ZKM_OWNER_PARENT property, otherwise if calc=n then look at the ZKM_OWNER property which will just return the one base member

Only trouble with this is if someone picks "All_Owner" whereby the calc=y logic might fall down.

An alternative would be to identify if the CHAR length of the user selection is 1, then pick the ZKM_OWNER_PARENT property, otherwise look at the ZKM_OWNER property.

Just some ideas to play around with. Please ignore my earlier post.

David

[former_member186338]

It will not work for multilevel hierarchy (or you will have to create additional properties for each level)...

May it's better to create additional hierarchy in product dimension - by owner and then simply select parent in product dimension. The owner dimension member can be linked by property of product dimension.

Vadim