What defines a HansaWorld data cube ?
...
Essential
Essential data that
...
will be connected to create data cube and start analysing
...
.
...
...
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
...
Support registers
While main data source registers add all the numbers to the data cubes they only contain codes for all the information. To add full names and descriptions for all the information support registers need to be added. Some examples of support registers are Customers (CUVc), Persons (UserVc) and Items (INVc).
Optional
Optional registers and
...
measures that you can connect will add other extra Measure values
...
connected to main data cube register, give names to members and create
...
properties that you can use in data filtering and sorting.
...
title | 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).
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: |
Read more about What is Data cube, Dimension and Calculated Members? of Flex.bi.
Cubes and main registers overview
...
Type
...
HansaWorld Financials
...
HansaWorld Invoices
...
HansaWorl
Purchase
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
...
Extra register
(adds extra values to Measure dimension)
...
Invoice balance ARVc
...
Item Status
ItemStatusVc
...
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.)
...
will add other measure values, give names to members and create properties that you can use in data filtering.
...
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.
...
Shared measures
If you are importing multiple cubes in one account then flex.bi automatically shares some of the measures between different data cubes. You can use some support register that is common for different data cubes and using shared measures see the information combined in one report. For example, both Invoices (IVVc) and POS (IVCashVc) registers contain items so you can have a report that shows the total of Invoices and POS sales combined.
Extra dimensions
Please see HansaWorld Extra dimension (importing objects, classifications, varieties) page for more information.
Cubes and main registers overview
Cube name | Main Register and code (Measures dimension) | Optional registers and codes (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 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 |