Not sure if this is possible - alternative rollups with dependencies on other dimensions
Summary:
We have our main Account hierarchy for our P&L accounts, and drilling from NPAT through each roll up and down to the lowest level is no problem.
However, we have new reporting requirements which contains a cost of revenue (COR) rollup (which is determined based on the value of two other dimensions), which needs to be set up in an alternate hierarchy. In this example, the total COR is based on the total expense for the members of two other dimensions. Generating a report with the COR section is fine and able to wind up at the same NPAT number no problem.
0