Suppose you allocate revenue or costs from your head office out to your branches or divisions.
Measure 1: Actual results before allocation
· and the allocation results post in a different measure. Then you're able to create a statement that provides pre allocation.
· post allocation and the Delta in a simple format that allows for further analysis.
· Another example might be where your business utilizes a thirteenth period. One measure would record the financials for your full 12 months in one year. but a separate measure would provide for your 13 months in total.
· The variance column then provides for the value of your period 13 adjustments.
· and again, those adjustments by category and account.
· A final example that, I think, is often used by our epico customers is to have all gl transactions listed into either a debit or a credit measure
· by listing these measures as separate columns in a statement means you're easily able to spot where a credit based account, such as a revenue account
· has a significant debit value or credit, note. or vice versa.
· You could then explore the reasons for these adjustments by drilling into the other dimensions within your database, which often include things like subletger
· or customer or vendor dimensions. So you could spot exactly where these transactions have been applied.