Support center for flex.bi version 4.0

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

You can use flex.bi advanced settings to add support for additional HAL fields as well as modify import options for standard fields.

Additional custom fields

If you would like to import in flex.bi additional fields with a custom field type that is not supported by default, then you can add a definition of how this custom field should be imported. Also, if some default custom field settings should be changed, then it can be done with adding necessary custom field configuration parameters.

At first, you need to find out the register and rest api code for the field. You can find codes for registers in the HanasWorld source File import documentation page. Then you can use the code to find code for rest api field in HansaWorld "Module Technics → Reports → Import/Export format". 

You can see in the example screeshot below the 1. register code and 2. codes for rest api fields.



Then add the following line to advanced settings:

Now you need to add the register code and register rest api code in the following line to advanced settings.

[resgister_code.register_rest_api_code]

Where register_code is register code and register_rest_api_code is the register rest api code. This will start the block of configuration parameters for the custom field. 

Then you need to specify the name for the custom field:

name = "Price"


Then you need to specify the dimension name in flex.bi for for the register.


dimension_name = "Invoice"


After that line, specify the data type of this field:

data_type = "string"

By default, the string maximum length is 255 characters. If there is a need to import longer string values, then use additional limit setting and specify the maximum length.
Other available types are text, integer, decimal, date, datetime.

If you use the decimal data type, then by default the precision (maximum number of digits) is 15 and the scale (digits after the decimal point) is 2. You can change these defaults with additional precision and scale settings.

If you would like to import custom field as additional dimension then add

dimension = true

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

measure = true

If the level where rest api register code is specified is not on the record level then you also need to specify what level is it on:

level_name = "Invoice Item"

Here is 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.

Finally, Edit the HansaWorld source application again and in "Cube properties" section select your new defined custom field for import.

Please contact support@flex.bi for more information. 


  • No labels