-
Unbalanced Hierarchies - Allowing "selection mode" configuration in dataflow and export
Hello everyone, Yes, this is my first post on the community. Following internal advices and multiple external feedbacks I'm sharing this Idea that seems to never been raised. My idea is to allow a developer to configure the default behavior expected on an unbalanced entity selection, only by configurating option mode to…
-
mirrored Leaf in unbalanced Hierarchie
The unbalanced hierarchy is a strong function. Unfortunately, it is only possible to aggregate using a single tree. Hierarchy nodes Description Root Node A node that is not assigned under any node and has no parent node (predecessor). Node A node that has successors, which means all nodes except for leaves. Leaf A node…
-
Unable to load unbalanced hierarchy throught datareader
Hi, I have followed the steps mentioned in attached article on how to create unbalanced hierarchy. I have successfully loaded the entity members. Now as I try to define their relationship I am unable to do so. I want to assign AC2 as parent of AC3. Kindly help!
-
Unbalanced hierarchies - Lock cells and Data Entry
Hello Team, We noticed a limitation about "Unbalanced hierarchies" and "Cell lock" data entry. Let's say we have : An unbalanced entity (Account) An “A” cube structured by (Month x Account) In fact, when we display a layout containing our A cube (with data entry enabled), and axis by row: Account (which is unbalanced) and…
-
Improve formatting capabilities for Unbalanced Hierarchies in Row Templates
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Level 200 Module 209: Build Account Tree Hierarchy, Data Reader Issue? No records were loaded
Hi Team, Create the Account Tree Entities and built the relationships between them. Also Built data readers to load Entities, Members, and to establish Relationships. But when I Run the Data reader(H - Account Data Reader) no members are coming in Account Entity. Please help me to figure it out. Thanks in Advance.
-
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: -…