Unbalanced Hierarchy in formatted report
Navan Mehra
Employee
Hi experts,
I would like to know how have you all used unbalanced hierarchy in the reports?
I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report
------------------------------
Navan Mehra
Senior Consultant
Board Community
Australia
------------------------------
I would like to know how have you all used unbalanced hierarchy in the reports?
I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report
- In the report, the parents should be at the bottom whereas an unbalanced hierarchy keeps the parents at the top
- To overcome #1 above, I defined the sort order as custom and reordered all members. The issue arises as soon as I go to the relationship and update any parent-child relation. Everything gets reset
------------------------------
Navan Mehra
Senior Consultant
Board Community
Australia
------------------------------
Tagged:
0
Accepted Answer
-
Hi Navan,
You can create a sorting cube for your unbalanced hierarchy where you define the exact position of each element in your report
To be able to enter data on nodes you need to deactivate the roll-up for this block in your layout
you can then use that block to sort your data view.
Of course this is only feasible if you don't have too many elements to manually sort in your UBH
Kind regards
Philipp
1
Answers
-
Thanks, Philipp. This happens to be an old question that I had asked. I followed the same logic as you described and was able to sort the hierarchy as per the desired order. Thanks
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP