Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
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.
Table of Contents | ||
---|---|---|
|
HansaWorld Invoices, Quotations, Sales Orders Orders data cubes
These all 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 | ||
---|---|---|
| ||
|
Image Removed
Essential data that has to be imported to create those cubes is
- Base currency setting - BaseCurBlock
- Transactional register - ( Invoices - IVVc, Quotations - QTVc, Sales Orders - ORVc )
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 Quotations
HansaWorld Sales Orders
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:
Read more about Basic Concepts of Flex.bi.