BW Hierarchy - Display total above

[former_member234632]

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

[amitrathi239]

It seems order is changed in the webi.

can you check what is the default order selected in the webi query->object member selector window.

If it's No sort (database order) then change to sort ascending and try.

[former_member234632]

Hi Amit,

Thanks for your answer.

This option (sort order) does not have any influence on result.

In the query preview part (Webi query editor), the order of rows is correct. So, my problem should be linked to webi layout...

Sebastien