MDX for unbalanced hierarchy
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?
Rohit Gupta 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.