Versions Compared

Old Version 3

changes.mady.by.user Dace Kvalberga

Saved on

compared with

New Version 4

changes.mady.by.user Dace Kvalberga

Saved on

Key

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

 

To understand what is data cube  - please read about Basic Concepts of Flex.bi

Read more about each cube and its possibilities

HansaWord Invoices

HansaWorld Financials

HansaWorld Sales Orders

HansaWorld Quotations

HansaWorld CRM

HansaWorld Stock

HansaWorld Stock Depreciations

HansaWorld Stock Movements

HansaWorld Goods Receipts 

HansaWorld Stock Job Costing


HansaWorld Invoices

 

Expand
titleHansaWorld Invoice cube registers
  1. Customer Class -  CCLassVc
  2. Item Class - DIVc
  3. Object Class - OTVc
  4. Objects - ObjVc
  5. Customers - CUVc
  6. Items - INVc
  7. Item Groups - ITVc
  8. Invoices - IVVc
  9. Invoice Balances - ArVc
  10. Users - UserVc

  11. Base currency setting - BaseCurBlock

    Note

    Item varieties and Item variety groups are not available in Job Costing, CRM and Financials cubes.

  12. Item varieties - VARVc

  13. Item variety groups - VARGVc


Expand
titleHansaWorld Financials cube
  1. Accounts - AccVc
  2. Objects  - ObjVc
  3. Transactions - TRVc
Expand
titleHansaWorld CRM cube
  1. Activity Types - ActTypeVc
  2. Projects - PRVc
  3. Activities - ActVc
Expand
titleHansaWorld Quotations cube
  1. Quotations - QtVc
Expand
titleHansaWorld Sales Orders cube
  1. Orders - ORVc
Expand
titleHansaWorld Job Costing cube
  1. Projects - PRVc
  2. Project budget - TBBUVc
Expand
titleHansaWorld Stock cube
  1. Location - LocationVc
  2. Item status - ItemStatusVc
  3. Item History - ItemHistVc
  4. Location classes - LocClTypeVc
  5. Location types - LocCLVc
Note

Goods Receipt, Stock Depreciation, Stock Movement cubes require that the Stock cube is also imported with locations and the optional  location classes and location types.

Expand
titleHansaWorld Goods Receipts cube
  1. Goods Receipts - PUVc
  2. Suppliers - VGVc
Expand
titleHansaWorld Stock Depreciation cube
  1. Stock Depreciation - SDVc
  2. Standard Problems - StandProblemVc
Expand
titleHansaWorld Stock Movements cube
  1. Stock Movements - StockMovVc

What 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:

What is dimension  ?

Typical cube dimensions are Time, Customers, Products, Locations, Employees, Projects etc. Use dimensions that are best suited to your business domain.

Each dimension can have either just detailed level of all dimension members or you can define hierarchy with several levels. For example, Customers dimension could have Country, State and Customer Name levels:

Image Added

All measures are automatically aggregated (typically as sum of detailed level values) in upper hierarchy levels. E.g. looking at Sales amount measure at Country level will give total sales amount for this country.