Skip to Content
avatar image
Former Member

Hiding Hierarchy Node in WeBI Report

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 22, 2017 at 08:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22, 2017 at 09:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded