Skip to Content
0

display WEBI in complete hierarchy

Nov 02, 2016 at 06:25 PM

66

avatar image

Hi there,

I have multiple dimension field from SAP bex query, I want to make them level hierarchy, I don't want to make just display some hierarchy only for one field. I just want those fields displayed as hierarchy. as this requirement is for existing report, I don't have chance to create universe for level hierarchy. also I checked community, there are only display hierarchy for some field.

capture.jpg (19.6 kB)
capture.jpg (42.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

BO ZHANG Nov 04, 2016 at 01:38 PM
0

Hi, attached images above is the fields of rows displayed as hierarchy in sap BEX query, I just want to implement the same in WEBI report.

above image includes row fields "organizational unit" and "position", you can only see position detail when expend organizational unit field. when collapse organizational unit, all subordinate positions are hidden automatically.

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Nov 04, 2016 at 01:53 PM
0

Have you tried with dragging hierarchy object in the webi?


untitled.png (1.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Sushil Padhye Nov 09, 2016 at 10:20 AM
0

Hello,

If I understood correctly you have multiple Dimensions which are linked as "Parent-Child" and you want to display them in One column of WebI Report. Those should be displayed as shown in above screen shot.

If this is correct, please try to check below Link:

https://blogs.sap.com/2013/06/05/bobj-trick-to-display-table-data-in-hierarchy-format/

Regards,

Sushil Padhye

Share
10 |10000 characters needed characters left characters exceeded