What defines a HansaWorld data cube ?Essential to create any data cube | HansaWorld InvoicesHansaWorld FinancialsHansaWorld Sales OrdersHansaWorld QuotationsHansaWorld CRMHansaWorld StockHansaWorld Stock DepreciationsHansaWorld Stock MovementHansaWorld Goods ReceiptsHansaWorld Job CostingRead more about Basic Concepts of Flex.bi.
|
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 . |
Optional registers and measures that you can connect : will add other measure values, give names to members and create properties that you can use in data filtering. | |
---|---|
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) |
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 |