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.
These all cubes are based on similar set of data and will look almost the same - except the name of Main register dimension.
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
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 Invoice cube registers
Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes.
HansaWorld CRM
HansaWorld CRM cube
Activity Types - ActTypeVc
Projects - PRVc
Activities - ActVc
HansaWorld Quotations
HansaWorld Quotations cube
Quotations - QtVc
HansaWorld Sales Orders
HansaWorld Sales Orders cube
Sales Orders - ORVc
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
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: