Financial Services
| Function: | Products: |
| Budgeting, Planning, Reporting | IBM Planning Analytics |
Challenge
A financial services company specializing in retirement and life insurance had a problem with repetitive TurboIntegrator scripts.
Solution
A review of their existing TurboIntegrator scripts found that many of their processes used pre-built source views. Each view differed only slightly. For example, one view would define subsets in approximately eight dimensions and focus on a single time period, while a second view would contain the same subsets and focus on a different time period. This approach led to more than 50 repetitive scripts that were run via chores.
Results
We changed the approach to create a source view in the prolog. This allowed a single script to be run over and over via parameters that were defined during each iteration. This resulted in faster maintenance since changes only had to be coded once. It also ensured that changes to public views and subsets would not impact these scripts.