Dimension Table

Dimension	Dimension Hierarchy	Default properties
Time	Year / Quarter / Month / Week / Day
Customer	Category / Customer	Customer created date Customer updated date
Person	Sales Group / Person
Currency	Currency
Item	Group / Item	Alternative code
Project (Job)	Class / Project / Project item
Location	Group / Location
Quotation Status	Quotation Status
Quotation	Quotation Class / Quotation / Quotation item	Quotation date Decision date Quotation currency Quotation project Item Variety

Measures Table

Cube	Level	Measures
Quotations	Record	Quotation amount Open Quotation amount Rejected Quotation amount Accepted Quotation amount Discount amount Tax amount Quotation base amount Open Quotation base amount Rejected Quotation base amount Accepted Quotation base amount Discount base amount Tax base amount Probability Quotation count Open Quotation count Rejected Quotation count Accepted Quotation count
Quotations	Item	Item amount Item quantity Item base amount Discount amount Discount base amount Gross profit Gross profit base amount
Invoices (Shared)	Record	Invoice amount Invoice Discount amount Invoice Tax amount Invoice base amount Invoice Discount base amount Invoice Tax base amount Invoice count Invoice balance Invoice base balance
Invoices (Shared)	Item	Invoice Item amount Invoice FIFO Invoice Gross profit Invoice Item quantity Invoice Item base amount Invoice Gross profit base amount
Sales Orders (Shared)	Record	Sales Order amount Sales Order Discount amount Sales Order Tax amount Sales Order base amount Sales Order Discount base amount Sales Order Tax base amount Sales Order count
Sales Orders (Shared)	Item	Sales Order Item amount Sales Order Item quantity Sales Order Item base amount Sales Order Gross profit Sales Order Gross profit base amount Sales Order Open amount Sales Order Open base amount Sales Order Open quantity
Stock (Shared)	Record	In stock Stock on order