Reverse Hierarchy Display in Webi from BEx Query

[Former Member]

Hi Experts,

How can I reverse the display of hierarchy in the WEBI? Our source is a BEx query. This is for displyaing P&L, Balance Sheet Report where the totals are shown at the bottom.

And, if ever we cannot reverse the hierarchy in WEBI, can we just arrange the hierarchy order in WEBI?

Hierarchy in bex:

Net Income

     Product Margin

          Sales Revenue

                   GLAcct1

                    GL Acct2

          Cost of Sales 1

          Cost of Sales 2

     Expense

          Direct expense

          Other expense

Webi should be:

Sales Revenue

     GLAcct1

     GLAcct2

Cost of Sales 1

Cost of Sales 2

Product Margin

Expense

Direct expense

Other expense

Net Income

Thanks.

[Former Member]

Hi ,

I think you have to create the recursive hierarchy in back end i,e In BEX. & then same can be applied to WEBI.

or else you can do the same manually at WEBI level.

refer following link:

Thanks,

SB