![]() ![]() ![]() For more information, see Configure Numeric Dimensions. You might also need to run some SQL updates for numeric dimensions. For more information, see Configure Alphanumeric Dimensions. You can configure any of these dimensions as alphanumeric. MEMBER_COL specifies the numeric member code column.Īny 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.Ī 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.This is optional for numeric dimensions, where alphanumeric and numeric member codes would be equivalent. An Alphanumeric Sender ID is your company name or brand used as the Sender ID in one-way SMS messages send to supported countries. MEMBER_CODE_COLUMN specifies the member table column which holds the alphanumeric member code.The column MEMBER_DATA_TYPE_CODE with value ’NUMBER’ identifies a dimension as numeric and value ‘VARCHAR2’ identifies a dimension as alphanumeric.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. For more information, see Adding Member Definition section in OFS Analytical Applications Infrastructure User Guide. After performing the Dimension configuration explained in this section, the Alphanumeric Code field in the Member Definition (New Mode) window becomes editable. ICAO Annex 10 and Doc 4444 contain provisions related to the acceptance of alphanumeric call signs with the following definition in DOC 4444: Aircraft. An alphanumeric dimension will additionally store an alphanumeric member code. Depending on the specific use, alphanumeric character sets may distinguish between upper- and lower-case letters, meaning the number of alphanumeric. The reason is that the alpha-numerical classification is an elastic one. Both dimension types require a numeric member code. Files can be expanded to an unlimited extent. OFSAAI supports both numeric and alphanumeric codes for Members of a Dimension. 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. 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. This section explains the configuration required if you want to enable alphanumeric codes for Dimension Members in the Dimension Management module. Configurations to use Alphanumeric and Numeric Codes for Dimension Members Configurations to use Alphanumeric and Numeric Codes for Dimension Members ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |