Versions Compared

Key

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

...

Cubes and main registers overview

Cube nameMain Register and code (Measures dimension)

Extra register and codes (adds extra values to Measure dimension)

HansaWorld InvoicesInvoices - IVVc

Invoice balance - ARVc

Bank

holidays BHollVc

holidays - BHollVc

Transferred working

days EPWorkDayChVc

days - EPWorkDayChVc

HansaWorld FinancialsTransactions - TrVc
HansaWorld Sales OrdersSales Orders - ORVc
HansaWorld Purchase OrdersPurchase Orders - POVc
HansaWorld Purchase InvoicesPurchase Invoices - VIVcPurchase Invoice balance - APVc
HansaWorld QuotationsQuotations - Qtvc

HansaWorld Stock

Item History - ItemHistVc

Item Status - ItemStatusVc

HansaWorld Goods ReceiptsGoods Receipts - PUVc
HansaWorld Stock DepreciationsStock Depreciation - SDVc
HansaWorld Stock MovementsStock Movements - StockMovVc
HansaWorld Job CostingProject budget - TBBUVc

HansaWorld CRM

Activities - ActVc
HansaWorld POSPOS 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

...