Versions Compared

Old Version 66

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 67

changes.mady.by.user Dace Kvalberga

Saved on

Key

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

What defines a HansaWorld data cube  ?

Essential to create any data cube

Expand
titleBase currency setting

  Defines 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 - FAQ : What is the difference between record and item level measures

Child pages (Children Display)
depth5
styleh6
pageHansaworld Data Cubes explained

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  Basic Concepts of Flex.bi. 

 

...