Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
HansaWorld data 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) 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.
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
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.
Read below about each data cube and see samples with Templates and Solutions available to make your setup easier.
What defines a Hansaworld data cube ?
Essential data that has to be imported to create those cubes is
Base currency setting - BaseCurBlock
Defiles what currency your system is using and calculates in Flex.bi - Base amounts and amounnts
Transactional register - Main data source of data that belongs to this data cube.
On top of this you can add other measures that we support
Flex.bi Cloud suported data cubes
Table of Contents | ||
---|---|---|
|
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
Image Added
Expand | ||
---|---|---|
| ||
Invoices - IVVc |
Expand | ||
---|---|---|
| ||
|
Expand | ||
---|---|---|
| ||
|
CRM
Job costing
Optional ( if you are planing to analyse by this field )
Hierarchy | 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 | ||
HansaWorld CRM
Expand | ||
---|---|---|
| ||
|
HansaWorld Job Costing
Expand | ||
---|---|---|
| ||
|
HansaWorld Financials
Expand | ||
---|---|---|
| ||
|
HansaWorld Stock
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 | ||
---|---|---|
| ||
|
FAQ
What is data Cube ?
Imported data is stored in multi-dimensional data cubes. Cubes contain fact data that are divided by dimensions and each detailed fact "cell" contains measure values about that fact. This is an example of a Sales cube that has Customers, Products and the Time dimensions and has two measures - Sales amount and Units sold. Each detailed cube "cell" contains sales amount and units sold for particular product, customer and time period:
Image Modified
Read more about Basic Concepts of Flex.bi.