flex.bi advanced settings can be used to import additional fields that are not available by default and to modify in import logic for exiting fields that are imported through custom field definition. The imported fields in flex.bi can, for example, be used as new Dimensions, new Properties, additional Measures and even new data Cubes. Dimensions from custom fields can have hierarchies, with custom fields it's possible to share measure between cubes and they can be used to define drill option for custom cubesWhat is Advanced settings and where to find them?
Advanced settings is a section in flex.bi applications that allow you to define custom data input for flex.bi data cubes, create new data cubes and adjust them.
(picture)
What can be a custom field?
Field in Source system that is not imported in flex.bi by default, For example : Custom Field that is customer specific
Transaction Register Field in Source system that is not imported in flex.bi by default, For example : Custom Module that is customer specific and is based on customer register
Any addition data structure that exists in Source system that needs be used in flex.bi as dimension/ Measures or property etc. in reports
With Advanced settings for Custom Fields functionality you can :
Add New Dimensions
Add new Properties
Add new Measures
Add new Hierarchies
Share measures between cubes
Define Drill Options
...
How to use this function?
STEP 1
Define what you want to add in “Advanced settings” section.
For Example: of custom dimension definition
Code Block |
---|
[ORVc.LangCode]
name = "Language code"
cube_name = "HansaWorld Sales Orders"
data_type = "string"
dimension_name = "Sales Order"
level_name = "Sales Order"
dimension = true |
STEP 2
Select in Cube Properties section — Custom Fields section what you want to import and how.
...
Advanced setting key components
...