Skip to Content

BW Hierarchy - Display total above

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 22, 2016 at 02:14 PM

    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.


    Untitled.png (25.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.