Account dimensions 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 the 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 an Account Calculation to set the value of one based on the other. First ensure that the Member Formula option is enabled.
Then you can click the gear button on Hierarchy2_AC_10 line and define the formula in the opened window.