Page Comparison

You can use flex.bi advanced settings to add a measure, property or dimension for existing cubes in one of these cases:

• Standard ERP fields that are not imported by flex.bi by default
• additional data fields added to your Standard ERP installation using HAL
• to modify import options for standard fields e.g. to import already supported field as a measure or even a separate dimension

Limitations

Currently only fields from the main register i.e. Invoices, Sales Orders, Quotations etc. are supported. For example, you can't import Customer register field Credit limit as a measure. This will be supported in the future versions.

Custom fields are supported for all data cubes except Financials (Transactions and Simulations registers), Job Costing (Projects and Project budgets registers), Stock Movements and Stock (Item History and Item Status registers). Please contact us if you have use cases for these cubes and we will work with you on a solution.

...

Example of custom string type dimension definition

[IVVc.Price]
name = "Price"
cube_name = "HansaWorld Invoices"
data_type = "decimal"
level_name = "Invoice Item"
dimension_name = "Invoice"
measure = true
dimension = true

Add additional custom field definitions as needed in advanced settings text area field and then click Save.

3.

...

Select custom fields for import

Edit the HansaWorld source application again and in , in "Cube properties" section select your new defined custom field for import and save the application.

Save the application settings and start the import. After the import is finished start using your property, measure or dimension in your reports

4. Re-import data

To make sure that the historical data is also linked to the custom fields re-import the data.

In case of any questions please contact support@flex.bi for more information. 

...