What defines a HansaWorld data cube ?
Essential
Essential data that will be connected to create data cube and start analysing.
Base currencies block - Defines what currency your system is using and gives directions how to calculate measures in Currency, Base currency and Base currency 1.
Main data source of data that belongs to this Data cube. For example: HansaWorld Invoices main register is Invoices, For HansaWorld Financials - Transactions. See full list below. Main register values will be stored in Measure Dimension. Values are stored in currencies that is defined in your base currency setting and have Item and record level measures. You can read more about it here - HansaWorld record and item level measures
Support registers
While main data source registers will add all the numbers to the data cubes supports registers can ensure that all the
Optional
Optional registers and measures that you can connect will add other extra Measure values connected to main data cube register, give names to members and create properties that you can use in data filtering and sorting.
Optional registers contain extra values that can be added to Measures dimension based on some specific register in HansaWorld. For example, Invoice Balance (Invoices), Item Status (Stock).
Shared measures
Extra dimensions
Please see HansaWorld Extra dimension (importing objects, classifications, varieties) page for more information.
Cubes and main registers overview
| Cube name | Main Register and code (Measures dimension) | Optional registers and codes (adds extra values to Measure dimension) |
|---|---|---|
| HansaWorld Invoices | Invoices - IVVc | Invoice balance - ARVc Bank holidays - BHollVc Transferred working days - EPWorkDayChVc |
| HansaWorld Financials | Transactions - TrVc | |
| HansaWorld Sales Orders | Sales Orders - ORVc | |
| HansaWorld Purchase Orders | Purchase Orders - POVc | |
| HansaWorld Purchase Invoices | Purchase Invoices - VIVc | Purchase Invoice balance - APVc |
| HansaWorld Quotations | Quotations - Qtvc | |
HansaWorld Stock | Item History - ItemHistVc | Item Status - ItemStatusVc |
| HansaWorld Goods Receipts | Goods Receipts - PUVc | |
| HansaWorld Stock Depreciations | Stock Depreciation - SDVc | |
| HansaWorld Stock Movements | Stock Movements - StockMovVc | |
| HansaWorld Job Costing | Project budget - TBBUVc | |
HansaWorld CRM | Activities - ActVc | |
| HansaWorld POS | POS Invoices - IVCashVc | |
HansaWorld Deliveries | Deliveries - SHVc |