This section explains the configuration required if you want to enable alphanumeric codes for Dimension Members in the Dimension Management module. This feature can be used if you want to use dimensions that are available in external source systems, for which the members may be maintained as a Number or alpha numeric text. For example, for dimensions like currency, alphanumeric codes can be used to denote the currency codes such as INR, USD, and so on, along with the exact amount.
OFSAAI supports both numeric and alphanumeric codes for Members of a Dimension. Both dimension types require a numeric member code. An alphanumeric dimension will additionally store an alphanumeric member code. After performing the Dimension configuration explained in this section, the Alphanumeric Code field in the Member Definition (New Mode) window becomes editable. For more information, see Adding Member Definition section in OFS Analytical Applications Infrastructure User Guide.
The REV_DIMENSIONS_B table stores the required dimension metadata including dimension member data type and the member column names for dimension member tables where the numeric and alphanumeric codes are stored.
In the REV_DIMENSIONS_B table:
· The column MEMBER_DATA_TYPE_CODE with value ’NUMBER’ identifies a dimension as numeric and value ‘VARCHAR2’ identifies a dimension as alphanumeric.
· MEMBER_CODE_COLUMN specifies the member table column which holds the alphanumeric member code. This is optional for numeric dimensions, where alphanumeric and numeric member codes would be equivalent.
· MEMBER_COL specifies the numeric member code column.
|
NOTE |
Any change done in REV_DIMENSIONS_B table requires restart of the web server because the dimension definitions data in cache memory has to be refreshed. |
A new installation by default will have the seeded key dimensions configured as numeric, although those dimension member tables include a column for alphanumeric member codes. You can configure any of these dimensions as alphanumeric. For more information, see Configure Alphanumeric Dimensions.
You might also need to run some SQL updates for numeric dimensions. For more information, see Configure Numeric Dimensions.