Multiple Parent Child Hierarchies
By Kevin Hsu - Jun 25, 2014
In Kepion, Account dimension can only have parent-child hierarchies. Each member has its fixed position in a parent-child hierarchy. In some cases, we may need to create reports with different reporting hierarchies. These hierarchies may share same accounts, like the example shown below. How should we define these hierarchies in the same parent-child hierarchy?
We can create different members with the same MemberName for display, as shown below.
Then we can use Account Calculation to set the value of one based on the other. In this example, click the gear button on Hierarchy2_AC_10 line and define the formula in the opened window.
Training & Tutorials
Check out the Training & Tutorials section for walk-through videos.