Skip to Content
0

Hiding Hierarchy Node in WeBI Report

Mar 22, 2017 at 06:33 AM

241

avatar image
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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Mar 22, 2017 at 08:00 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Mar 22, 2017 at 09:15 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded