What defines a HansaWorld data |
...
Each Data cube is defined by
...
Shared Measures - mix data from different data cubes.
In HansaWorld ERP typically you can create reports based on current modules data, in Flex.bi - data can be mixed together from different data cubes as long as they makes sense and have valid connection. Those are called Shared Measures.
For each data cube there is a sample Data cube with templates and Solutions available to make your setup easier.
Table of Contents |
---|
HansaWorld Invoices
...
title | HansaWorld Invoice cube registers |
---|
...
Base currency setting - BaseCurBlock
Note |
---|
Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes. |
...
Item variety groups - VARGVc
HansaWorld Financials
Expand | ||
---|---|---|
| ||
|
HansaWorld CRM
Expand | ||
---|---|---|
| ||
|
HansaWorld Quotations
Expand | ||
---|---|---|
| ||
|
HansaWorld Sales Orders
Expand | ||
---|---|---|
| ||
|
HansaWorld Job Costing
Expand | ||
---|---|---|
| ||
|
HansaWorld Stock Deprecioa
Expand | ||
---|---|---|
| ||
|
Note |
---|
Goods Receipt, Stock Depreciation, Stock Movement cubes require that the Stock cube is also imported with locations and the optional location classes and location types. |
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
...
cube ?ESSENTIALEssential data that you have to connect to create data cube and start analysing is only couple of HansaWorld standard data files mentioned below. For Rest api all necesarry to build a cube will be connected automatically during connection set up.
OPTIONALOptional registers and measures that you can connect will add other extra Measure values conecteed to main data cube register, give names to members and create properties that you can use in data filtering and sorting.
|
|
Read more about Basic Concepts of Flex.bi. |
Cubes and main registers overview
Type | HansaWorld Financials | HansaWorld Invoices | HansaWorld Quotations | HansaWorld Sales Orders | HansaWorld CRM | HansaWorld Job Costing | HansaWorld Stock | HansaWorld Stock Depreciations | HansaWorld Goods Receipts | HansaWorld Stock Movements |
---|---|---|---|---|---|---|---|---|---|---|
Main Register | Transactions TrVc | Invoices | Quotations | Sales Orders | Activities | Project budget TBBUVc | Item History ItemHistVc | Stock Depreciation - SDVc | Goods Receipts - PUVc | Stock Movements StockMovVc |
Extra register (adds extra values to Measure dimension) | Invoice balance Arvc |
| Item Status ItemStatusVc |
Essential to create any data cube | |
---|---|
Base currency setting code : BaseCurBlock | Defines what currency your system is using and gives directions how to calculate measures (Currency, Base currency, Base currency 1) |
Main data source register (Depends on data cube, see list below ) | 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 . |
Optional registers and measures that you can connect : will add other measure values, give names to members and create properties that you can use in data filtering. | |
---|---|
Extra Measure registers | 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) |
Data Filters | Optional registers are all the rest that you decide to import and would like to use in your reports as measures or filters. |
Dynamic dimension registers | Data registers that can be only partially imported are Dynamic |
Shared Measures | In HansaWorld ERP typically you can create reports based on current modules data, in Flex.bi - data can be mixed together from different data cubes as long as they makes sense and have valid connection. Those are called Shared Measures. |