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:
Read more about Basic Concepts of Flex.bi. | What HansaWorld data is supported by Flex.bi ?Currently Flex.bi Cloud version supports data import for selected HansaWorld modules and features (listed below) - it means that if you upload standard HansaWorld exported register files (*txt) or connect with Rest api - Data Cubes with dimensions, hierarchies, measures and properties that will be created automatically based on data received will be created automatically in Analyse tab. For Flex.bi Private - you can create and combine together also other data cubes as this version is open for customizations. This allow to create data cubes not only for other specific Hansaworld modules but also other from SQL and Rest api conected data. If you have a question about data cubes, dimensions, hierarchies - please read more about Basic Concepts of Flex.bi or contact us support@flex.bi | In this page
|
...
What defines a HansaWorld data cube ?
...
| Essential to create any data | cubecube | ||
|---|---|---|---|
| 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 . | ||
| Optional registers and | measuresmeasures that you can connect : will add other measure values, give names to members and create | propertiesproperties that you can use in data filtering. | |||
|---|---|---|---|---|---|
| Registers | Extra Optional data 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) | |||
| Otional data source register 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. | ||||
| Dynamic dimension registers | Data registers that can be only partially imported are Dynamic | ||||
| Shared Measures | In HansaWorld ERP typically you can create reports based on current modules data, in Flex.bi - data can be mixed together from different data cubes as long as they makes sense and have valid connection. Those are called Shared Measures. | ||||
...
Type | Hansaworld Financials | Hansaworld Invoices | Hansaworld Quotations | Hansaworld Sales Orders | Hansaworld CRM | Hansaworld Job Costing | Hansaworld Stock | Hansaworld Stock Depreciations | Hansaworld Goods Receipts | Hansaworld Stock Movements | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Main Register | Transactions TrVc | Invoices | Quotations | Sales Orders | Activities | Project budget TBBUVc | Item History ItemHistVc | Stock Depreciation - SDVc | Goods Receipts - PUVc | Stock Movements StockMovVc | Invoice balance Arvc | Extra register |
|
|
| |||||||
Object Class ObjTypeVc | Dynamic dimension | |||||||||||||||||||||
| Gives name to Objects level members ( if not imported, Object name is missing, only code can be taken from main register ) | ||||||||||||||||||||||
| Hierarchy (Item Dimension) | |||||||||||||||||||||
| Customers CUVc | Dimension | |||||||||||||||||||||