The Tier Table Introducer component allows you to use an existing tier table in a plan.
In a tier table, each group consists of one or more numerical intervals. The output columns of the tier table are number or string values assigned to each numerical interval. The Tier Table Introducer component compares row by row each numerical interval of a group with a property value of the plan. The comparison stops when the property value matches a numerical interval of the group. The output columns related to the numerical interval are retrieved in generated properties that you can use in the plan.
With the Tier Table Introducer component, you can:
Select a tier table
Select one of the groups of the tier table
Select the property value to compare with the numerical intervals of the group
A service provider bills Internet services to its clients according to their contract length. To calculate the service price, a tier table provides the contract lengths with their price. The contract type (Gold price or Silver price) determines the service price. To use the tier table, a Tier Table Introducer must be inserted in the decision tree of the price plan. The tier table "TieredTariff" consists of:
Numerical intervals representing the contract length in months (]-∞, 6], ]6, 12], ]12, 24], ]24, +∞[)
Output columns representing the related prices (Gold price and silver Price) in USD
In the price plan, the Tier Table Introducer component shows the following information:
The "TieredTariff" tier table
The "ContractLength" price plan property that is compared to the numerical intervals (contract lengths) of the group
The "GoldenPrice" price plan property that retrieves the value of the "Golden price" output column
The "SilverPrice" price plan property that retrieves the value of the "Silver price" output column
In this example, the tier table "TieredTariff" uses the default group. Therefore, the Group Name Property is "Default Group". If the tier table uses another group, the list of Group Name Properties must contain the property whose value is the group name.
Name: Type the name of the component (mandatory).
Description: Allows you to type the description of the component (optional).
Tier Table: Provides the list of available tier tables. Select the tier table that you want to use with the Tier Table Introducer. To open and modify the tier table, click
.
Mapping Property: Provides the list of properties. Choose the property to compare with the numerical intervals of the selected group.
Group Name Property: Provides the list of properties. Choose the property whose value is the group name, or choose the default group.
Mapping of Generated Properties: Displays the output columns of the tier table and allows you to rename the generated properties. When a comparison is true between a numerical interval and the property, the generated properties retrieve the output column values of the tier table.
Column Name: Displays the output column name of the tier table.
Column Description: Displays the description of the output column of the tier 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 tier table. To change the name of the default generated property, double-click the entry, and then type a new name. You can use the generated property in the plan.