Skip to Content
avatar image
Former Member

display WEBI in complete hierarchy

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 04, 2016 at 01:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 01:53 PM

    Have you tried with dragging hierarchy object in the webi?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2016 at 10:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded