TUAM Analytics Integration – Financial Modelling, Budgeting and Forecasting with Cognos TM1
DLawson 27000369MF Visits (3548)
The TUAM reporting team has developed an initial integration with IBM Cognos® TM1® to provide an environment for developing timely, reliable and personalised forecasts and budgets.
IBM Cognos® TM1® is a complete enterprise planning solution. It supports a full range of enterprise planning requirements including financial analytics and financial modelling.
It provides a facility to load data from a variety of sources and model this as OLAP cubes. Rules and calculations can then be added to these cubes prior to being made available to the users who can then interact with the cubes to work with their data. A flexible modelling environment is provided whereby users can perform adhoc analysis of the data in the cube, or remodel the data in the cube by amending values and seeing the effects.
IBM Cognos® TM1® is fully scalable and capable of handling large, sophisticated models and large data sets. Furthermore, role-based security is available that supports multiple users and ensures that users see only those portions of the plan that they need to.
There is also a choice of interfaces available including Microsoft® Excel® and Cognos TM1 Web allowing you to work with your preferred look and feel.
How will this work with TUAM?
The first integration scenario covered is to provide a way to calculate the values for rates based on usage for cost recovery.
The TUAM integration blueprint provides a set of processes to create cubes containing data from TUAM. Summary data will be available for use by forecasting and planning processes and can also be made available for reporting, providing users with the ability to slice and dice the data to get a full understanding of their costs and usage as well as monitoring how costs are being recovered. Processes will also be available to write back any relevant calculations to the database which in the initial case will be the calculated rate values.
Using and then extending these processes will help users to model what-if scenarios to understand what the effects would be of adding additional costs, changes in usage or other scenarios that can occur across a financial year. Users can amend their costs or forecasted usage and redistribute these across clients or financial periods and see immediately the effect this will have on cost recovery.
IBM Cognos® TM1® is compatible with Tivoli Common Reporting so reports can be written based on the cubes defined in TM1. Extending the existing capability will allow users to create reports to show Actuals against Budget and Forecast so users can stay up-to-date with their cost recovery. Users will also be able to create their own reports to show data for their own specific needs.
By working with this initial package or blueprint, all the benefits of IBM Cognos® TM1® can be utilised to forecast and plan usage and monitor the progress of cost recovery.
What can I expect to see?
The initial stages provide processes to create and incrementally update the summary data stored in TUAM. This allows users to be able to quickly query the data and get an understanding of the usage and charges being accrued. This will be created with a view to being a data source for the usage data required to calculate the values for the rates in the modelling process.
If you would like more details of this and some assistance with getting started then please post an entry in the TUAM forum.
How can I learn more?
Details of the benefits and functionality of TM1 can be found here.
An example of how TM1 can be applied to a industry solution such as Banking and Insurance can be found here.
How do I get this solution?
This is a integration solution so you will need to purchase IBM Cognos® TM1® separately. See here for details.
Note: The provided package has been installed and tested successfully by TUAM development on 32 bit systems. There are known issues with 64 bit systems which the team will address in the future if the functionality proves popular. All feedback is welcome but please ensure you install on a 32bit system before looking for help with installing on the TUAM forum (link). General feedback is welcome in the comments section on this page