Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MDX for unbalanced hierarchy

Hi all,

from SAP-BW we have some unbalanced hierarchy: for some branches the hierarchy stop at level 3, for other stop at level 4 and for another stop at level 5.

On Web Intelligence when enabled drill-down, selecting level 4 or 5 where there isn't hierarchy value I would like have a custom sting and not blank value

How could I have this?

Can I write MDX code hierarchy for obtain normally hierarchy level when there are and a string (for example: "NO LEVEL") when chosen drill-down to level that not exist?


Former Member
Former Member replied


I think you are trying to display a default text "No Level" whenever you are at one level below the level at which the Hierarchy

Ends. To cater the above requirement you can write the logic to display the default text at the web-I report level using Alerters in case of Null values for Level 4 and Level 5.

I am not sure if you can write any such logic in the BEx query but certainly it can't be done at the universe level. However to get the same is possible in Web-I using Alerters.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question