...
Essential registers : | Essential to create data cube |
---|---|
Base currency setting - 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 HansaWorld Invoices main register is Invoices, For Hansaworld Financials - Transactions. See full list below . |
Optional registers and measures : | will add other measure values, give names to members and create properties. |
---|---|
Extra Registers | Extra values that can be added to Measures dimension based on some specific register in Hansaworld. For example, Invoice Balance ( Invoices ) , Item Status ( Stock) |
Registers with DimensionOtional data source register | Optional registers are all the rest that you decide to import and would like to use in your reports as measures or filters. |
Registers with Dynamic dimension registers | Data registers that can be only partially imported are Dynamic |
Shared Registers and 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. You can suggest shared measures of your choice - support@flex.bi. |
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 | |||||||||||
Objects ObjVc | Dynamic dimension | ||||||||||
Gives name to Objects level members ( if not imported, Object name is missing, only code can be taken from main register ) | |||||||||||
| |||||||||||
Item Groups - ITVc | Hierarchy (Item Dimension) | ||||||||||
Customers CUVc | Dimension |
...