Spend rollup dimension hierarchy
The top level of the Spend cube is Total Spend. It is the sum of four categories of spend: AOC and Tax, PO Spend, Expense and Uncategorized Spend.
AOC and Tax
AOC is comprised of PO AOC and Non PO AOC, which summarize eight base measures:
- PO AOC Charges
- PO AOC Credits
- PO Allowances
- PO AOC Amount
- Non PO AOC Charges
- Non PO AOC Credits
- Non PO Allowances
- Non PO AOC Amount
Tax category summarizes these four base measures:
PO Spend
PO Spend is comprised of on contract Spend, off contract Spend, and no contract Spend.
PO Spend/on contract Spend
PO Spend/off contract Spend
PO Spend/no contact Spend
Expense and uncategorized spend