Page Comparison

...

ESSENTIAL

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

...

title	Base currency setting

...

Base currencies block - 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

...

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 - HansaWorld record and item level measures

OPTIONAL

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

...

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).

Cubes and main registers overview

_Type

_{HansaWorld Financials}

_{HansaWorld Invoices}

_HansaWorl_{Purchase
Invoices}

_HansaWorld

_Quotations

Cube name	Main Register and code (Measures dimension)	Extra register (adds extra values to Measure dimension)
HansaWorld Invoices	Invoices - IVVc	Invoice balance ARVc Bank holidays BHollVc Transferred working days EPWorkDayChVc
HansaWorld Financials	Transactions - TrVc
HansaWorld Sales Orders	Sales Orders - ORVc
HansaWorld Purchase Orders	Purchase Orders - POVc
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

Purchase Invoices	Purchase Invoices - VIVc	Purchase Invoice balance APVc
HansaWorld Quotations	Quotations - Qtvc
HansaWorld Stock	Item History - ItemHistVc	Item Status ItemStatusVc
HansaWorld Goods Receipts	Goods Receipts - PUVc
HansaWorld Stock Depreciations	Stock Depreciation - SDVc
HansaWorld Stock Movements	Stock Movements - StockMovVc
HansaWorld Job Costing	Project budget - TBBUVc
HansaWorld CRM	Activities - ActVc
HansaWorld POS	POS Invoices - IVCashVc
HansaWorld Deliveries	Deliveries - SHVc

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 - HansaWorld record and item level measures

...

Versions Compared

Old Version 5

New Version 6

Key

ESSENTIAL

OPTIONAL

Cubes and main registers overview