Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...