Multiple Parent Child Hierarchies

By - 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.