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
...
necessary to build a cube will be connected automatically during connection set up.
| Expand | ||
|---|---|---|
|
...
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 | ||
|---|---|---|
| ||
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 . |
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 | ||
|---|---|---|
| ||
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) | ||||||
|---|---|---|---|---|---|---|
|
| Expand | ||
|---|---|---|
| ||
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
...