Versions Compared

Key

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


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. 

Expand
titleBase 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


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

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. 

Expand
titleExtra 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)


Child pages (Children Display)
depth5
styleh6
pageWhat is a HansaWorld Data Cube in flex.bi?Cubes


Expand
titleWhat 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 Main concepts of Flex.bi.

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 - SDVcGoods Receipts - PUVcStock Movements StockMovVc

Extra register

(adds extra values to Measure dimension)



Invoice balance ARVc

Purchase
Invoice balance APVc





Item Status

ItemStatusVc




...