Versions Compared

Old Version 54

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 55

changes.mady.by.user Dace Kvalberga

Saved on

Key

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

...

Essential registers :
Essential to create data cube
Base currency setting - setting 
code : BaseCurBlock

 Defines what currency your system is using and gives directions how to calculate measures (Currency, Base currency, Base currency 1)

Main data source register

(Depends on data cube, see list below )

Main data source of data that belongs to this data cube

For example:  Hansaworld 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

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)

Registers  with DimensionOtional data source register

Optional registers are all the rest that you decide to import and would like to use in your reports as measures or filters.

Registers with Dynamic dimension  registers
Data registers that can be only partially imported are Dynamic
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.

 

 

 

Type

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
(Measures dimension)

Transactions TrVc

Invoices
IVVc

Quotations
Qtvc

 Sales Orders
ORVc

Activities
ActVc

Project budget
TBBUVc		Item History
ItemHistVc		Stock Depreciation - SDVcGoods Receipts - PUVcStock Movements StockMovVc

Invoice balance Arvc

Extra register



  •   
  •  Shared
  •  Shared 

 

     

Object Class

ObjTypeVc

           

 


Objects ObjVc

Dynamic dimension
( Objects class  dimension )

  •   
  •   
  •   
  •   
  •   
  •   
  •   
  •   
  
 Gives name to Objects level members ( if not imported, Object name is missing, only code can be taken from main register )
 

 

  •   
  •   
        
 Item Groups - ITVcHierarchy
(Item Dimension)		          
            
            
            
Customers  CUVc Dimension          

...