Versions Compared

Old Version 11

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 12

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 will be created automatically in Analyse tab.

Each Data cube is defined by

  • list of register files that need to be uploaded or connected with Rest api 
    • Dimensions, hierarchies

    , 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 Templates and Solutions  available to make your setup easier.

    Table of Contents

    HansaWorld

    Invoices 

    Image Removed

     

    Expand
    titleHansaWorld Invoice cube registers
  • Customer Class -  CCLassVc
  • Item Class - DIVc
  • Object Class - OTVc
    • Objects - ObjVc

    Invoices, CRM, Quotations, Sales Orders and Job costing 

     

    Essential data to create cubes 

    1. Invoices -  IVVc 
    2. Base currency setting - BaseCurBlock 


    These all cubes are based on the same set of data -

    Image Added

    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

    Groups - ITVc
  • Invoices - IVVc
  • Invoice Balances - ArVc
  • Users - UserVc

    • Base currency setting - BaseCurBlock

     

    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.

    2. Item varieties - VARVc

      3. Item variety groups - VARGVc

    HansaWorld Financials

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

    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
    Stock Deprecioa
    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.