You can use flex.bi advanced settings to add support for additional HAL fields as well as modify import options for standard fields.
Advanced settings are not supported with file import.
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 screenshot 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.