Invert a hierarchy

[Former Member]

I am trying to build a P&L reports in WEBI using a BICS connection. BW provides the hierarchy which is around the wrong way. I need a way to invert the hierarchy for my reporting.

Current Hierarchy (example)

Net Profit after Tax

     --> Gross margin

          --> Sales

          --> COGS

Output Required  (example)

Sales

COGS

     --> Gross Margin

          --> Net Profit after Tax

Is there a way to invert the hierarchy in BEx or WEBI? Or to add an index in BW?

One, not ideal, solution

I have thought of using an excel datasource that can provide an index and then merge dimensions in Webi. This is messy.

[Former Member]

Hi Matt,

Agree with Simone that this is not possible in WEBI, where as the same may be possible in Bex layer or BW side.

As I see, you are referring to BW query showing the hierarchy wrong way, then I would advise on correcting it at the BW layer and then carrying it over the right way to WEBI.

See if this note is related to your behavior of hierarchy.

http://www.stechno.net/sap-notes.html?view=sapnote&id=1620014

Thanks

Malllik

[former_member188911]

Hi Matt,

at present this is not possible, maybe in a future release...

There is an open suggestion here https://ideas.sap.com/ct/ct_a_view_idea.bix?idea_id=%7b0530F064-E00D-409F-BCDC-B9470CBE6630%7d

you may wish to vote...

Thanks

Simone