General Configurations for Dimension Management Module
These configurations are applicable only if you are using the Dimension Management features provided in OFSAAI.
A new table called AAI_AMHM_PROPS table is introduced to configure properties related to the Dimension Management module. Note that in 8.0.x versions, the AMHMConfig.properties file was used. The attributes in this table are as follows:
- V_PARAM_NAME- Enter the parameter name. See the succeeding table for the parameter names for the available properties.
- V_INFODOM- Enter the Information Domain name for which you want to apply the property. For each Infodom, you should add a new row with the required Information Domain name in the table.
- N_DIMENSION_ID- Enter the dimension ID of the Dimension for which you want to apply a property. For each dimension, you should add a new row with the Dimension ID in the table.
- V_PARAM_VALUE- Enter the value for the corresponding parameter name. See the following table for the available values for various properties.
Table 3-1 Parameter value and their description for configuring the Dimension Management module
| V_PARAMNAME | V_PARAM_VALUE | Description | Example |
|---|---|---|---|
| TREE_NODE_LIMIT | An integer number |
Specify the maximum number of tree nodes that should be allowed for the hierarchy. NOTE: This property is used to display the Hierarchy as a small or a large Hierarchy. If the tree node limit exceeds the set limit, the Hierarchies are treated as large Hierarchy. The value of V_INFODOM and DIMENSION_ID must be NULL in the AAI_AMHM_PROPS table. |
30 |
| SEARCH_TREE_NODE_LIMIT | An integer number |
Specify the maximum number of tree nodes that should be allowed for the Hierarchy during search. NOTE: The value of V_INFODOM and DIMENSION_ID must be NULL in the AAI_AMHM_PROPS table. |
50 |
| MEMBER_DEL | Y or N |
Set this property to Y to allow the user to delete the Members of the Dimension. NOTE: The value of V_INFODOM and DIMENSION_ID must be given in the AAI_AMHM_PROPS table. |
Y |
| ATTR_DEF_DATE_FORMAT | Date format |
Specify the default date format for the date type Attributes in the Attributes window. NOTE: The value of V_INFODOM must be given in the AAI_AMHM_PROPS table. |
DD/MON/YYYY |
| MEMBER_REVERSE_POP | Y or N |
Set this property to Y to allow the reverse population of the Members of the Dimensions. NOTE: The value of V_INFODOM and DIMENSION_ID must be given in the AAI_AMHM_PROPS table. |
Y |
| HIERARCHY_REVERSE_POP | Y or N |
Set this property to Y to allow the reverse population of Hierarchies of the Dimensions. NOTE: The value of V_INFODOM and DIMENSION_ID must be given in the AAI_AMHM_PROPS table. |
Y |
| MAX_DEPTH-FUSION | An integer number |
Specify the maximum level to be allowed to build the Hierarchy tree structure. The maximum levels allowed in the Hierarchies should be less than or equal to 15. If the HIERARCHY_REVERSE_POP parameter is set as "Y" and more than 15 levels are created, then an alert is displayed as "The number of levels is exceeding the limit". If the maximum level allowed is set as more than 15 and the HIERARCHY_REVERSE_POP parameter is set as "Y", then an alert is displayed as "Error occurred in Reverse populating the hierarchy". NOTE: The value of V_INFODOM must be given in the AAI_AMHM_PROPS table. |
15 |
| HIERARCHY_IN_FILTER_SORT | Y or N |
Set this property to Y to sort the nodes alphabetically. NOTE: The value of V_INFODOM and DIMENSION_ID must be given in the AAI_AMHM_PROPS table. |
Y |
Note:
During the upgrade from 8.0.x versions, the properties already configured in the AMHMConfig.properties file are automatically populated into the AAI_AMHM_PROPS table.Figure 3-1 Parameter value for configuring the Dimension Management module
