Dimension Table

Dimension	Dimension Hierarchy	Default properties
Account	Type / Account	-
Time	Year / Quarter / Month / Week / Day	-
Currency	Currency	-
Item	Group / Item	-
Location	Group / Location	-
Supplier	Category / Supplier	-
Record Status	Record Status	-
Goods Receipt	Purchase Order Class / Goods Receipt / Goods Receipt Item	Avg Cost price Avg Cost base pric Comment Objects Item Variety All Properties

Measures Table

Cube	Level	Measures
Goods Receipts	Record	Total Goods Receipts count OK Goods Receipt count Not OK Goods Receipt count
Goods Receipts	Item	Quantity Total cost Total base cost
Accounts	Record	Account Balance Account Debit amount Account Credit amount