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.

tr_diagram_Spend Rollup dimension hierarchy

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
tr_diagram_AOC Rollup

Tax category summarizes these four base measures:

tr_diagram_Tax Category

PO Spend

PO Spend is comprised of on contract Spend, off contract Spend, and no contract Spend.

tr_diagram_PO Spend

PO Spend/on contract Spend

tr_diagram_PO Spend_On Contract Spend

PO Spend/off contract Spend

tr_diagram_PO Spend_Off Contract Spend

PO Spend/no contact Spend

tr_diagram_PO Spend_No Contract Spend

Expense and uncategorized spend

tr_diagram_Expense and uncategorized spend