What defines a HansaWorld data |
...
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.bicube ?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 |
|
...
What defines a HansaWorld data cube ?
Item Status ItemStatusVc |
Essential to create any data | cubecube | ||
---|---|---|---|
Base currency setting - 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 HansaWorld Invoices main register is Invoices, For Hansaworld HansaWorld Financials - Transactions. See full list below . |
Hansaworld Invoices
Hansaworld
Quotations
Hansaworld Sales Orders
Hansaworld
CRM
Hansaworld Job Costing
Hansaworld
Stock
Hansaworld Stock Depreciations
Hansaworld
Goods Receipts
Hansaworld
Stock Movements
Ivvc
Transactions
Trvc
Quotations
Qtvc
Sales Orders
ORVc
Activities
ActVc
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
(Measures dimension)
Transactions TrVc
Invoices
IVVc
Quotations
Qtvc
Sales Orders
ORVc
Activities
ActVc
TBBUVc
ItemHistVc
Invoice balance Arvc
Extra register
- Shared
Optional registers and measures that you can connect : will add other measure values, give names to members and create | propertiesproperties that you can use in data filtering. | ||
---|---|---|---|
Extra RegistersExtra Measure registers | Optional registers contain extra values that can be added to Measures dimension based on some specific register in HansaworldHansaWorld. For example, Invoice Balance ( Invoices ) , Item Status ( Stock) | ||
Registers with Dimension 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. | ||
Registers with Dynamic dimension registers | Data registers that can be only partially imported are Dynamic | ||
Shared Registers and 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. You can suggest shared measures of your choice - support@flex.bi. |
Shared |
Object Class
ObjTypeVc
Objects ObjVc
Dynamic dimension
( Objects class dimension )
(Item Dimension)
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
...
title | HansaWorld Invoice cube main register and specific measures |
---|
Optional ( if you are planing to analyse by this field )
...
Hierarchy
Measures |
Items - INVc
Item varieties - VARVc
...
Dynamic Dimensions ( selected during import in Surce appplication tab )
Customer Class CCLassVc
. |
...
...
...
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 | ||
---|---|---|
| ||
|
...
title | HansaWorld Stock Movements cube |
---|
- Stock Movements - StockMovVc