The Translation Table Introducer component allows you to use an existing translation table in a plan. The Translation Table Introducer component allows you to use an existing translation table in a plan.
The Translation Table Introducer component compares row by row the input columns of a translation table with properties of the plan. The comparison stops when the properties match at least one row of the input columns. The order of the rows in the translation table is therefore important. The output columns related to the input columns are retrieved in generated properties that you can use in the plan. If no property matches the comparison, the translation table returns a default value for each generated property.
|
Note: The number of properties must be equal to the number of input columns of the translation table. |
With the Translation Table Introducer component, you can:
Select a translation table
Select the properties to compare with the input columns of the translation table
Select the type of comparison
An operator bills telephone calls according to the geographic zone of the called numbers. To calculate the price of each call, a translation table provides the price plan with the geographic zone code that is assigned to each telephone number prefix. To use the translation table, a Translation Table Introducer must be inserted in the rating tree of the price plan. The translation table "TableZone" is made up of the input column "Prefix" and the output column "ZoneCode". The input column contains the telephone number prefixes, and the output column contains the geographic zone codes.
In the price plan, the Translation Table Introducer component shows the following information:
The "TableZone" translation table
The "NumberCalled" price plan property that provides the telephone number to the translation table
The "GeographicZone" price plan property that retrieves the value of the "ZoneCode" output column
The comparison test "starts with" that is used to compare the price plan properties with the input columns of the translation table
Name: Type the name of the component (mandatory).
Description: Allows you to type the description of the component (optional).
Translation Table: Provides the list of available translation tables. Select the translation table that you want to use with the Translation Table Introducer. To open and modify the translation table, click 
.
Comparison Operator: Provides the list of comparison operators. To compare the properties with the input columns of the translation table, select one of the following operators:
Is equal to: The comparison is true when the property matches the value of the input column. For example, if the property that contains "06526179" is compared with an input column entry that contains "06526179", the comparison is true; otherwise, the comparison is false.
Starts with: The comparison is true when the property starts with the value of the input column. For example, if the property that contains "06526179" is compared with an input column entry that contains "06", the comparison is true; otherwise, the comparison is false.
Contains: The comparison is true when the property contains the value of the input column. For example, if the property that contains "06526179" is compared with an input column entry that contains "261", the comparison is true; otherwise, the comparison is false.
Ends with: The comparison is true when the property ends with the value of the input column. For example, if the property that contains "06526179" is compared with an input column entry that contains "79", the comparison is true; otherwise, the comparison is false.
Reference Date: Is an additional criterion to compare a date with the Start Date and End Date columns of the translation table (*). If you do not select a Reference Date, this option is ignored. If selected, the comparison result depends on the following rules:
If a row includes a non-null Start Date and a non-null End Date, the comparison is true if the Reference Date is equal or greater than the Start Date and strictly less than the End Date; otherwise, the comparison is false.
If a row includes a non-null Start Date and no End Date (**), the comparison is true if the Reference Date is greater than or equal the Start Date; otherwise, the comparison is false.
If a row includes no Start Date (**) and a non-null End Date, the comparison is true if the Reference Date is strictly less than the End Date; otherwise, the comparison is false.
If a row includes no Start Date (**) and no End Date (**), the comparison is always true.
(*): Reference Date is used in combination with the Start and end dates can be specified for each row option of translation tables. For more information, refer to the online Help of SAP CC Core Tool.
(**): Cell left blank.
Mapping of Rating Context: Displays the input columns of the translation table, and allows you to select the properties that you want to compare with the input columns.
|
Note: In the Type column, you are allowed to select only one multi-valued string as a property type. |
Column Name: Displays the input column name of the translation table.
Column Description: Displays the description of the input column of the translation table.
Type: Provides the list of two property types: String or Multi-Valued String. Select a property type.
Mapping Property: Provides the list of properties relating to the selected type of the Type column. Select the property that you want to compare with the input column.
Mapping of Generated Properties: Displays the output columns of the translation table, and allows you to rename the generated properties. When a comparison is true between properties, Reference Date (if selected), and input columns, the generated properties retrieve the values of the output column entries.
Column Name: Displays the output column name of the translation table.
Column Description: Displays the description of the output column of the translation table.
Type: Displays the type of the generated property.
Generated Property Name: Displays the default generated property that retrieves the output column value of the translation table. To change the name of the default generated property, double-click the entry, and then type a new name. You can use this new generated property in the plan.