1. Administration and Configuration Guide
  2. Dimension Management Module Configurations
  3. Configurations to use Alphanumeric and Numeric Codes for Dimension Members
  4. Configure Numeric Dimensions

Configure Numeric Dimensions

If REV_DIMENSIONS_B.Member_Code_Column is populated for a dimension, any UI that displays an alphanumeric code checks in the specified column for the member's alphanumeric code. If REV_DIMENSIONS_B.Member_Code_Column is null, the UI assumes no alphanumeric code column exists in the member table and displays the alphanumeric code with the same value as the numeric code. Therefore, for numeric dimensions, you should 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 the Rev_Dimensions_B table for Numeric dimension, since the REV_DIMENSIONS_B.MEMBER_CODE_COLUMN column has value as 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 values are stored in the same <DIM>_ID column.

  • Back up the REV_DIMENSIONS_B table, if you have not done it already.
  • Clear the Member Code Column entries for applicable dimensions.
For 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), then the dimension loaders and seeded T2T extracts will 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 REV_DIMENSIONS_B table, if you have not done it already.
  • Populate the Member Code Column entries for applicable dimensions.
For 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;