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

...

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.

...

You can see in the example screenshot below the register code (1.) and codes for REST API fields (2.).

2. Find the correct Cube, Dimension and Level names

Image Added

3. Configure custom field settings

Register code and register REST API code

...

Name of the dimension to which this field should be related to e.g. Invoices, Transactions, Quotations etc. Note that currently, this should be the main dimension of the cube e.g.

dimension_name = "Invoice"

Dimension level name

The name of the level within the specified dimension, where the field should be added, e,g.

level_name = "Invoice Item"

Data type of this field

One of the supported data types - integer, value, string e.g.

...

If you would like to import custom field as a measure then add

measure = trueIf the level where the REST API register code is specified is not on the record level (i.e. it is in the table or matrix of the record) then you also need to specify what level is it on:

level_name = "Invoice Item"

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. 

...