If REV_DIMENSIONS_B.Member_Code_Column is populated for a dimension, any UI which displays an alphanumeric code will look in the specified column for the member's alphanumeric code. If REV_DIMENSIONS_B.Member_Code_Column is null, the UI will assume no alphanumeric code column exists in the member table and will display the alphanumeric code with the same value as the numeric code. Therefore, for numeric dimensions, you may want to update the metadata.
There are two options available to configure Numeric dimension.
· Option 1: When the dimension does not have <DIM>_CODE column in <DIM>_B table
· Option 2: When the dimension have <DIM>_CODE column in <DIM>_B table
NOTE |
By default, no configuration changes are required in Rev_Dimensions_B for Numeric dimension, since the REV_DIMENSIONS_B.MEMBER_CODE_COLUMN column has value either <Dim>_Code or null depending on the availability of <Dim>_Code column. |
Option 1: When the dimension does not have <DIM>_CODE column in <DIM>_B table.
In this case, the alphanumeric and numeric code value are stored in the same <DIM>_ID column.
· Back up the table REV_DIMENSIONS_B, if you have not done it already.
· Clear the Member Code Column entries for applicable dimensions.
Example:
§ For specific numeric dimensions, use the following code:
Update REV_DIMENSIONS_B Set Member_Code_Column = null Where Dimension_ID in([values]);
Commit;
§ For all editable numeric dimensions, use the following code:
Update REV_DIMENSIONS_B Set Member_Code_Column = null Where Member_Data_Type_Code = 'NUMBER' and DIMENSION_EDITABLE_FLAG = 'Y';
Commit;
NOTE |
If the dimension has <Dim>_Code column and Option 1 is used (that is, the REV_DIMENSIONS_B.MEMBER_CODE_COLUMN is set to null), this will cause the dimension loaders and seeded T2T extracts to fail. |
Option 2: When the dimension have <DIM>_CODE column in <DIM>_B table.
In this case, the alphanumeric and numeric code value are stored separately in <DIM>_CODE and <DIM>_ID column (though both the values are same).
· Back up the table REV_DIMENSIONS_B, if you have not done it already.
· Populate the Member Code Column entries for applicable dimensions.
Example:
§ For specific numeric dimensions:
Update REV_DIMENSIONS_B Set Member_Code_Column = <dim>_code Where Dimension_ID in([values]);
Commit;
§ For all editable numeric dimensions:
Update REV_DIMENSIONS_B Set Member_Code_Column = <dim>_code Where Member_Data_Type_Code = 'NUMBER' and DIMENSION_EDITABLE_FLAG = 'Y';
Commit;