Display Hierarchy Nodes

[Former Member]

Hi Experts:

I am facing a challenging requirement when create reports in WEBI.

In BW system, we have a hierarchy like below structure (suppose this structure is no timedependent 😞

B

   |----B1

         |-----B11

                 |-----B111

         |-----B12

                 |-----B121

   |----B2

         |-----B21

         |-----B22

But, in reports, I only want to display 2th level of this hierarchy (B1,B2), and I hope the hierarchy function is not work (only display it).

For example:

Suppose we have below detailed data records in DSO:

Material	Profit Center	Quantity
M01	B11	100
M01	B21	50
M01	B121	100
M01	B22	30

when reporting, my result should be like this

Profit Center	Quantity
B1	200
B2	70

I have 2 solutions as below:

1. Add a extra field in DSO, this fields will be filled value B1 or B2 when ETL process was executed.

2. Create a transparent table stores  the relationship bewteen 2th level and his subordinate nodes, then create a user-exit variable in BEx Query.

These 2 above solution can solve my problem, but,I want to know whether BW can solve this problem in  a standard way.

Waiting for your reply.

Best Regards.

Yin YuNan.

[Former Member]

Hi YuNaN,

Select the hierarchy characteristic in your Query Designer -> Go to right side properties screen -> Hierarchy tab -> select the setting Activate Hierarchy Display.

Hierarchy Parameter area -> Set up to which hierarchy level the hierarchy is to be drilled down in the initial view under Expand to Level.

Hope Answers - Kumar