Versions Compared

Old Version 37

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 38

changes.mady.by.user Dace Kvalberga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

What HansaWorld data is 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) 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 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 TBBUVcItem History  ItemHistVcStock Depreciation - SDVcGoods Receipts - PUVcStock 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

 

Flex.bi Cloud suported data cubes

 

Table of Contents
maxLevel3

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

 

Expand
titleHansaWorld 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  
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 registerCubes Measures Properties

Customer Class CCLassVc

 All  
Item Class  DIVc All  
Object Class - OTVcAll  
Objects - ObjVcAll  
    

 



HansaWorld CRM

Expand
titleHansaWorld CRM cube
  1. Activity Types - ActTypeVc
  2. Projects - PRVc
  3. Activities - ActVc


HansaWorld Job Costing

Expand
titleHansaWorld Job Costing cube
  1. Projects - PRVc
  2. Project budget - TBBUVc

HansaWorld Financials

Expand
titleHansaWorld Financials cube
  1. Accounts - AccVc
  2. Objects  - ObjVc
  3. Transactions - TRVc

HansaWorld Stock

 

Expand
titleHansaWorld Stock cube
  1. Location - LocationVc
  2. Item status - ItemStatusVc
  3. Item History - ItemHistVc
  4. Location classes - LocClTypeVc
  5. Location types - LocCLVc
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
titleHansaWorld Goods Receipts cube
  1. Goods Receipts - PUVc
  2. Suppliers - VGVc
Expand
titleHansaWorld Stock Depreciation cube
  1. Stock Depreciation - SDVc
  2. Standard Problems - StandProblemVc
Expand
titleHansaWorld Stock Movements cube
  1. 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:

Read more about  Basic Concepts of Flex.bi.