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 registers :
essential to create data cube
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
(Depends on data cube, see list below )
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
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
Invoices
Ivvc
Transactions
Trvc
Quotations
Qtvc
Sales Orders
ORVc
Activities
ActVc
Project budget TBBUVc
Item History ItemHistVc
Stock Depreciation - SDVc
Goods Receipts - PUVc
Stock Movements StockMovVc
Extra register : creates extra measures, but not essential
Invoice balance
Arvc
Item Status
ItemStatusVc
Optional registers and measures :
will add other measure values, give names to members and create properties.
Extra Registers
Extra values that can be added to Measures dimension based on some specific register in Hansaworld. For example, Invoice Balance ( Invoices ) , Item Status ( Stock)
Other Registers
Optional registers are all the rest that you decide to import and would like to use in your reports as measures or filters.
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.
On top of this you can add other measures that we support
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 ofFlex.bi
HansaWorld Invoice cube main register and specific measures
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
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
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
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.
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
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: