Skip to Content
0
Jul 22, 2016 at 12:51 PM

BW Hierarchy - Display total above

149 Views

Hello,

I'm using a Bex query in my Webi document. A BW hierarchy is displayed and I expect Totals are appeared below. (I use option "Root/Totals Item Appears Below" in RSH1)

By testing my query wih RSRT, result is correct:

Node A Level 3

Node B Level 3

Node C Level 2

Node D Level 3

Node E Level 2

Leaf F Level 4

Leaf G Level 4

Leaf H Level 4

Node I Level 3

Node J Level 2

Node K Level1

by using my Webi document, the option "Root/Totals Item Appears Below" defined in RSH1 is not enforced. (Same query is using)

The result is:

Node K Level1

Node J Level 2

Node I Level 3

Leaf F Level 4

Leaf G Level 4

Leaf H Level 4

Node E Level 2

Node D Level 3

Node C Level 2

Node B Level 3

Node A Level 3

My question is: How can I display Root node and total is below in my Webi document ? I would like to get the same result as RSRT.

Thanks a lot for your help.

Sebastien