Convergent Charging Tier Table
A tier table is a table used for mapping an input field that contains a value range to a set of output columns(sting/number). Tier Table can be queried from the price plan of the charge.
The below post shows a simple use case of Tier Table(s).
We have the CIT class that passes Duration as one of the attribute.
Let’s create a tier table.
Provide a name and description. The output column is Price with Computation type as Single Linear. Go to the Table Instance Tab.
Create 3 entries.
Double click on each range and provide values as below.
Now for each row provide a price.
Our first tire table is ready which is Single Linear.
Create a similar table but with computation type as Cumulative Linear.
Create a similar table but with computation type as Single Non-Linear.
Create a similar table but with computation type as Cumulative Non-Linear.
Now we have 4 Tier Tables with different computation mode.
Let’s create a charge and price plan which uses this tier table.
Now in below charge the Tier Table- SL_TT (Single Linear) is used.
The Usage rate contains a linear function.
Now test the price plan.
The input Duration is 20 secs. So it falls in the first range of the Tier Table.
As the computation is linear. So the amount= 20 * .25 = 5 EUR.
The input Duration is 30 secs. So it falls in the first range of the Tier Table.
As the computation is linear. So the amount= 30 * .25 = 7.5 EUR.
The input Duration is 40 secs. So it falls in the Second range of the Tier Table.
As the computation is linear. So the amount= .35 *( 40-30) = 3.5 EUR
The input Duration is 50 secs. So it falls in the Second range of the Tier Table.
As the computation is linear. So the amount= .35 *( 50-30) = 7EUR
The input Duration is 70 secs. So it falls in the Third range of the Tier Table.
As the computation is linear. So the amount= .5 *( 70-60) = 5 EUR
The input Duration is 90 secs. So it falls in the Third range of the Tier Table.
As the computation is linear. So the amount= .5 *( 90-60) = 15 EUR
Now lets assign the tier table: SN_TT ( Single Non-Linear) to the price plan and test.
The input Duration is 20 secs. So it falls in the First range of the Tier Table.
As the computation is non-linear. Amount= .25 EUR
The input Duration is 30 secs. So it falls in the First range of the Tier Table.
As the computation is non-linear. Amount= .25 EUR
The input Duration is 40 secs. So it falls in the Second range of the Tier Table.
As the computation is non-linear. Amount= .35 EUR
The input Duration is 50 secs. So it falls in the Second range of the Tier Table.
As the computation is non-linear. Amount= .35 EUR
The input Duration is 70 secs. So it falls in the Third range of the Tier Table.
As the computation is non-linear. Amount= .5 EUR
The input Duration is 90 secs. So it falls in the Third range of the Tier Table.
As the computation is non-linear. Amount= .5 EUR
Now assign Cumulative Linear Tier Table and test the price plan.
The input Duration is 20 secs. So it falls in the First range of the Tier Table.
As the computation is Cumulative linear. Amount= 20 * .25 = 5 EUR
The input Duration is 30 secs. So it falls in the First range of the Tier Table.
As the computation is Cumulative linear. Amount= 30 * .25 = 7.5 EUR
The input Duration is 40 secs. So it falls in the Second range of the Tier Table.
As the computation is Cumulative linear.
Amount= [ 30 * .25 ] + [ (40-30) * .35] = 7.5 + 3.5 = 11 EUR
The input Duration is 50 secs. So it falls in the Second range of the Tier Table.
As the computation is Cumulative linear.
Amount= [ 30 * .25 ] + [ (50-30) * .35] = 7.5 + 7 = 14.5 EUR
The input Duration is 90 secs. So it falls in the Third range of the Tier Table.
As the computation is Cumulative linear.
Amount= [ 30 * .25 ] + [ (90-60) * .35] + [ (90-60) * .5] = 7.5 + 10.5 + 15= 33 EUR
Now lets assign the Cumulative Non-Linear tier table in the price plan and test the price plan.
The input Duration is 20 secs. So it falls in the first range of the Tier Table.
As the computation is Cumulative non-linear. Amount= .25 EUR
The input Duration is 30 secs. So it falls in the first range of the Tier Table.
As the computation is Cumulative non-linear. Amount= .25 EUR
The input Duration is 55 secs. So it falls in the second range of the Tier Table.
As the computation is Cumulative non-linear. Amount= .25 + .35 = .6 EUR
The input Duration is 80 secs. So it falls in the third range of the Tier Table.
As the computation is Cumulative non-linear. Amount= .25 + .35 + .5 = 1.1 EUR
SAPCODES 