Example of LoadData Method Using Field [n]
Golden Gate Bank defines its product rates in the Buscomp Financial Product. The following table shows the fields in Buscomp Financial Product and some sample data.
Region | Product | Balance | Rate |
---|---|---|---|
West |
Checking |
10000 |
0.2 |
West |
Saving |
29000 |
2.1 |
West |
N Market |
87560 |
2.5 |
East |
Checking |
40000 |
0.24 |
The following table shows the arguments used to retrieve the data and store it in a format as defined by the ProductRate Vector sample diagram shown in About Business Rule Process Property Types type.
Input Argument Name | Value |
---|---|
Buscomp |
Financial Product |
IsCachedData |
Y |
Hierarchial 1 |
Region |
Hierarchial 2 |
Product |
Sort Spec |
Region, Product |
Field 1 |
Balance |
Field 2 |
Rate |
The data is stored into a vector named productRateVector. Then, the rate of the Checking product in the East region can be retrieved as:
productRateVector["East"]["Checking"]["Rate"]
using a PropertySet Value statement.