What is a HansaWorld Data Cube in flex.bi?

What defines a HansaWorld data cube ?

ESSENTIAL

Essential data that you have to connect to create data cube and start analysing is only couple of HansaWorld standard data files mentioned below. For Rest api all necesarry to build a cube will be connected automatically during connection set up.

Base currency setting

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

code : BaseCurBlock

Main data source register

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 - Record and item level measures (Item base amount,Invoice amount etc.)

OPTIONAL

Optional registers and measures that you can connect will add other extra Measure values conecteed to main data cube register, give names to members and create properties that you can use in data filtering and sorting.

Extra Measure registers

Optional registers contain extra values that can be added to Measures dimension based on some specific register in HansaWorld. For example, Invoice Balance ( Invoices ) , Item Status ( Stock)

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:

Cubes and main registers overview

_Type

_{HansaWorld Financials}

_{HansaWorld Invoices}

_HansaWorl_{Purchase
Invoices}

_HansaWorld

_Quotations

_{HansaWorld Sales Orders}

_{HansaWorld Purchase 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}

_{Purchase
Invoices
VIVc}

_{Quotations
Qtvc}

_{Sales Orders
ORVc}

_{Purchase Orders
POVc}

_{Activities
ActVc}

_{Project budget
TBBUVc}

_{Item History
ItemHistVc}

_{Stock Depreciation - SDVc}

_{Goods Receipts - PUVc}

_{Stock Movements StockMovVc}

_{Extra register}

_{(adds extra values to Measure dimension)}

^{Invoice balance ARVc}

^{Purchase
Invoice balance APVc}

^{Item Status}

^ItemStatusVc

Essential to create any data cube

Base currency 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 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 - Record and item level measures (Item base amount,Invoice amount etc.)

Optional registers and measures that you can connect : will add other measure values, give names to members and create properties that you can use in data filtering.
Extra Measure registers	Optional registers contain extra values that can be added to Measures dimension based on some specific register in HansaWorld. For example, Invoice Balance ( Invoices ) , Item Status ( Stock)
Data Filters	Optional registers are all the rest that you decide to import and would like to use in your reports as measures or filters.
Dynamic dimension registers	Data registers that can be only partially imported are Dynamic
Shared 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.