on 11-23-2016 9:47 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Actually there is fold/unfold feature in WebI (although it's a triangle sign instead of + sign)
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.