What HansaWorld data is supported by Flex.bi ?
Currently Flex.bi Cloud version supports data import for selected HansaWorld modules and features (listed below) - it means that if you upload standard HansaWorld exported register files (*txt) 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.
For Flex.bi Private - you can create and combine together also other data cubes as this version is open for customizations. This allow to create data cubes not only for other specific Hansaworld modules but also other from SQL and Rest api conected data.
If you have a question about data cubes, dimensions, hierarchies - please read more about Basic Concepts of Flex.bi or contact us support@flex.bi
What defines a Hansaworld data cube ?
Essential | | |
---|
Base currency setting - BaseCurBlock | Defines what currency your system is using and gives directions how to calculate measures (Currency, Base currency, Base currency 1) | |
Main register measures
| 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 - FAQ : What is the difference between record and item level measures | |
Optional - will add other measures, give names to members and create properties.
- Other Measures - Stored in separate register files and can be exported from Hansaworld. Value of them will also appear in Measures dimension as measures - for example Invoice Balance
- Other Dimension (Filter) names and details
Optional things are all the rest that you decide to import and would like to use in your reports as measures or filters.
- Shared Measures - option to 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.
Read below about each data cube and see samples with Templates and Solutions available to make your setup easier.
Features and extra measures | Hansaworld Invoices | Hansaworld Financials | Hansaworld Financials | Hansaworld Financials | Hansaworld Financials | Hansaworld Financials | Hansaworld Financials |
---|
| | | | | | | |
On top of this you can add other measures that we support
Flex.bi Cloud suported data cubes
HansaWorld Invoices
This is the main data cube of first set of cubes that are very similar - Invoices, These 3 data cubes are based on similar set of data and will look almost the same in Flex.bi - except the name of Main register dimension name will be different - it depends on Transactional register on each cube. Read more about Basic Concepts of Flex.bi
HansaWorld Invoice cube main register and specific measures
HansaWorld Quotations cube main register and specific measures
HansaWorld Sales Orders cube
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 | | |
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 | | |
| | | |
HansaWorld CRM
HansaWorld CRM cube
- Activity Types - ActTypeVc
- Projects - PRVc
- Activities - ActVc
HansaWorld Job Costing
HansaWorld Job Costing cube
- Projects - PRVc
- Project budget - TBBUVc
HansaWorld Financials
HansaWorld Financials cube
- Accounts - AccVc
- Objects - ObjVc
- Transactions - TRVc
HansaWorld Stock
HansaWorld Stock cube
- Location - LocationVc
- Item status - ItemStatusVc
- Item History - ItemHistVc
- Location classes - LocClTypeVc
- Location types - LocCLVc
HansaWorld Goods Receipts cube
- Goods Receipts - PUVc
- Suppliers - VGVc
HansaWorld Stock Depreciation cube
- Stock Depreciation - SDVc
- Standard Problems - StandProblemVc
HansaWorld Stock Movements cube
- Stock Movements - StockMovVc