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 |
| Item | Quantity Total cost Total base cost | |
| Accounts | Record | Account Balance Account Debit amount Account Credit amount |