Versions Compared

Old Version 14

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 15

changes.mady.by.user Dace Kvalberga

Saved on

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

Essential data to create cubes 

  1. Base currency setting - BaseCurBlock
  2. Transactional register  - ( Invoices -  IVVc, Quotations - QTVc, Sales Orders - ORVc )   


These all cubes are based on the same 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 registerCubes Measures Properties

Customer Class CCLassVc

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



Expand
titleHansaWorld Invoice cube registers


  1. Note

    Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes.

HansaWorld CRM

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

HansaWorld Quotations

Expand
titleHansaWorld Quotations cube
  1. Quotations - QtVc 

HansaWorld Sales Orders

Expand
titleHansaWorld Sales Orders cube
  1. Sales Orders - ORVc

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

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.