Hiding Hierarchy Node in WeBI Report

[Former Member]

Hello

I have a hierarchy displayed in my Webi report and I want to hide some specific values of a node. For example, if i have the below hierarchy

• Continent
• ----Europe
• --------England
• --------Holland
• ----America
• --------North America
• --------South America

I want to hide a specific node, on level 2 where Continent = America, without hiding the country associated to it.

Expected Result:

• Continent
• ----Europe
• --------England
• --------Holland
• ----America
• --------North America
• --------South America

[amitrathi239]

You can try with this formula.

Var=if([Continent]=" America") then "Hide" else "Show"

Makesure space in the " America" value should match with your hierarchy value.

After that add filter on Var where not equal to Hide value.

[kohesco]

Hi,

I assume you retrieve BW hierarchies? the best solution will be to create a new one with the required layout. In the webi report you can use that one.

Grtz

Koen