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.

...

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 = true

If 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.

...