cancel
Showing results for 
Search instead for 
Did you mean: 

Compact Hierarchy Display in Webi

former_member261309
Participant
0 Kudos

Hello,

We saw the option of using compact hierarchy display in SAP Design Studio, just wondering if we have any way of displaying the same in Webi using compact hierarchy display.

For ex : If we have Region Hierarchy and then two dimensions product type and product size, in Design Studio when we use compact hierarchy display we see it this way,

where as in Webi region hierarchy and product type are different columns

Like this

Region Hierarcy | Product Type |

Though in Design Studio after using compact hierarchy its this way

+Region Hierarchy

+Product Type

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member220897
Participant
0 Kudos

If you didn't mention the Region Hierarchy, I would also recommend the technique Amit has mentioned, but your task seems a bit harder - you need to mix hierarchy with other dimensions, and I doubt the mentioned technique will work in this case.

Still, in WebI you have the option of setting these columns to sections and then carefully formatting the sections as if it was a single table. Not so easy to configure as in Design Studio, and usability is not so good, but at least it will look compact.

former_member198519
Active Contributor
0 Kudos

Best way would be to use the blog that Amit suggested. One other way I would opt is to use Drill feature in Webi, dont know how beneficial it would be in your scenario.

amitrathi239
Active Contributor
0 Kudos

Check attached link to Display Table Data In Hierarchy Format


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

former_member261309
Participant
0 Kudos

Thanks Amit

This solution would definitely have worked if we didn't had the requirement of having + sign for hierarchy. Compact display in design studio allows to compact the dimensions and then user can expand them with + sign as per their need.

So that's why I am looking for the compact display option in Webi if feasible.

Piyush

former_member220897
Participant

Actually there is fold/unfold feature in WebI (although it's a triangle sign instead of + sign)