-
UBH Extract Dataset - Behavior of Parent Level Selection
Hi Team, Having spoken to people in product already, I wanted to put this idea out there. Business Ask : Being able to pull data for a parent level on a UBH out on an export dataset Issue : Currently, Board has no way of being able to select a parent level member on a UBH and extract the aggregated sum of all its…
-
UBH - Using dependancies in Procedures
Dear all, Since the integration of UnBalanced Hierarchies, a world opened to us! Including the dependancies selections (Leaf, Descendants, children, etc…) of the UBH in a DataView. However, these dependancies can NOT be used in Procedures. It could be usefull to easily calculate the weight of a member Vs its direct parent.…
-
How to use Unbalanced Hierarchy
1. Abstract A common requirement when structuring hierarchies in Board is to create an unbalanced hierarchy, Board facilitates this with a dedicated feature “Unbalanced Hierarchies”. 2. Context Unbalanced hierarchies can be a very useful addition to a Board solution; however, how to define and maintain them requires some…
-
Unbalanced Hierarchy Selectors consistency
Currently the Unbalanced hierarchy selector is not consistent across the different ways to make selections. On the normal filter you are able to select descendants, however if you are using an interactive selection step in a procedure it is not possible to select descendants. It is also not possible to select descendants…
-
Unbalanced Hierarchy - selecting descendants not available when "show only active members is ticked"
Hi, Has anyone come across on unbalanced hierarchies where if you have "Show only active members" selected in design mode, you then can't use the descendants option to select multiple members when you use the selector in play mode? I don't understand why you wouldn't be able to still select descendants on the list that's…
-
Option "Disable Unbalanced Hierarchy" should work "per block" and not on all the dataview blocks
We have switch our main entity "P&L" to unbalanced. This entity is used in hundreds of dataview. Some dataview are pretty basic and unbalanced is working as expected. However we also have a lot of medium / high complexicity dataview with hidden factors cubes, or tech cubes. In that case, some business cubes need to have…
-
Using Unbalanced Hierarchy and standard entity together
I have an unbalanced hierarchy ( P&L Reporting) which has multi-levels Level 1 — Level2 — — Level 3 Another entity is Account which has all the base-level accounts in it. Level 3 of the unbalanced hierarchy is linked to the Account entity where multiple accounts have a relationship with a single Level 3 member. I have a…
-
Is using a UBH useful in being able to see data with higher granularity in a report format?
We would like to see if utilizing an unbalanced hierarchy entity will assist in being able to drill through subtotal levels within the report format. For example, we would like to be able to drill through Transaction fees to see the amount coming from individual GL accounts that combine to give the subtotal which goes into…
-
Identify level of unbalanced hierarchy members in a dataview
Hi all, is there a option/variable etc. to identify the level of unbalanced hierarchy members (set by row) in a dataview? Example: Entity Sales Level A 100 1 B 50 2 C 50 2 C1 50 3 Thanks for you help. Kind regards, Atilla
-
Entity with many levels - suggestions
Hello, We have a new customer that has an Account dimension with nine levels (!). It's an Unbalanced Hierarchy. Before we start to build too many objects depended on the Account entity/entities, we would like to ask this creative Community for input and knowledge sharing. This object(s) should fulfill our need of: -…