You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!