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
Note |
---|
Custom fields are supported from flex.bi version 5.0 and are supported only for import over REST API. |
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.
...
A name for the field describing the logic in the most understandable for you way e.g.
name = "Price"
Cube Name
The cube name where the custom field will be available. You can find the full cube names in Analyze section in your flex.bi.
cube_name = "HansaWorld Invoices"
Dimension name in flex.bi for the register
...
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.
...