HansaWorld data supported by Flex.bi
Currently Flex.bi in standard version supports data import for selected HansaWorld modules and features (listed below) - it means that if you upload standard HansaWorld exported register files (*txt) to Flex.bi or connect with Rest api - Data Cubes with dimensions, hierarchies, measures and properties that will be created automatically based on data received will be created automatically in Analyse tab
If you have a question about data cubes, dimensions, hierarchies - please read more about Basic Concepts of Flex.bi.
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.
HansaWorld Invoices, Quotations, Sales Orders
Essential data to create cubes
- Base currency setting - BaseCurBlock
- Transactional register - ( Invoices - IVVc, Quotations - QTVc, Sales Orders - ORVc )
Expand |
---|
title | HansaWorld Invoice cube |
---|
|
Invoices - IVVc
|
These all cubes are based on similar set of data and will look almost the same - except the name of Main register dimension.
CRM
Job costing
Optional ( if you are planing to analyse by this field )
| | Measures |
---|
Item Groups - ITVc
| Yes | |
Invoice Balances - ArVc | | Invoice Balance |
Customers - CUVc | | |
Items - INVc | | |
Item varieties - VARVc | | |
Item variety groups - VARGVc | | |
Note |
---|
Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes. |
Dynamic Dimensions ( selected during import in Surce appplication tab )
Name of register | Cubes | Measures | Properties |
---|
Customer Class CCLassVc | All | | |
Item Class DIVc | All | | |
Object Class - OTVc | All | | |
Objects - ObjVc | All | | |
| | | |
Expand |
---|
title | HansaWorld Invoice cube registers |
---|
|
Note |
Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes.
HansaWorld CRM
Expand |
---|
|
- Activity Types - ActTypeVc
- Projects - PRVc
- Activities - ActVc
|
HansaWorld Quotations
Expand |
---|
title | HansaWorld Quotations cube |
---|
|
- Quotations - QtVc
|
HansaWorld Sales Orders
Expand |
---|
title | HansaWorld Sales Orders cube |
---|
|
- Sales Orders - ORVc
|
HansaWorld Job Costing
Expand |
---|
title | HansaWorld Job Costing cube |
---|
|
- Projects - PRVc
- Project budget - TBBUVc
|
HansaWorld Financials
Expand |
---|
title | HansaWorld Financials cube |
---|
|
- Accounts - AccVc
- Objects - ObjVc
- Transactions - TRVc
|
HansaWorld Stock
Expand |
---|
title | HansaWorld Stock cube |
---|
|
- Location - LocationVc
- Item status - ItemStatusVc
- Item History - ItemHistVc
- Location classes - LocClTypeVc
- Location types - LocCLVc
|
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 |
---|
title | HansaWorld Goods Receipts cube |
---|
|
- Goods Receipts - PUVc
- Suppliers - VGVc
|
Expand |
---|
title | HansaWorld Stock Depreciation cube |
---|
|
- Stock Depreciation - SDVc
- Standard Problems - StandProblemVc
|
Expand |
---|
title | HansaWorld Stock Movements cube |
---|
|
- Stock Movements - StockMovVc
|