Dimension Table
| Dimension | Dimension Hierarchy | Default properties |
|---|---|---|
| Account | Type / Account | - |
| Time | Year / Quarter / Month / Week / Day | - |
| Item | Group / Item | - |
| Project (Job) | Class / Project / Project item | - |
| Location | Group / Location | - |
| Record Status | Record Status | - |
| Standard Problem | Standard Problem | - |
| Stock Depreciation | Stock Depreciation / Stock Depreciation Item | Comment Objects Item Varieties All Properties |
Measures Table
| Cube | Level | Measures |
|---|---|---|
| Stock Depreciation | Record | Stock Depreciation count OK Stock Depreciation count Not OK Stock Depreciation count |
| Item | FIFO Quantity | |
| Accounts ??? | Record | Account Balance Account Debit amount Account Credit amount |