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

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

...

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.

...