Hi there,
I'm new to this forum and TM1 so am looking for some assistance.
I work as a the systems guy in a medium sized company. We are using TM1 version 9.5. At present we only use it for annual budgets but I'm looking to expand it's use and implement it across other areas of finance such as monthly reporting, financial reporting, asset reports, ad-hoc analysis etc... We have some old and manual reporting processes which I'm hoping to replace.
My first plan is to get the financial statements compiled using figures from TM1. Currently we are using Cognos CDM to produce the reports, but linking to manual spredsheets. I'm aiming (with the help of consultants) to create a cube just for the general ledger. A TI process would run update the general ledger data from the GL source system into TM1. I then want to link CDM with TM1 so that the figures automatically populate into the financial statements. This would overcome the massive problems we are having with maintaining these messy spreadsheets. It will also help in our long term plan to move over to TM1 and CDM for all financial reporting.
I've searched the forums but haven't found too much about this and was wondering if we should do the notes to the financial statements in TM1 or CDM.
Does anyone have any general experience with using TM1 and CDM? Is there anything else I should consider?
Thanks in advance
Cognos TM1 with CDM Integration
-
pandinus
- Posts: 78
- Joined: Tue Mar 18, 2014 8:02 am
- OLAP Product: TM1, Cognos Express
- Version: 10.2.2
- Excel Version: 2013
Re: Cognos TM1 with CDM Integration
You should know that CDM is a solution for what IBM calls 'narrative reporting'.
The strength of CDM is dynamically loading numerical data from predefined sources (not just TM1, but any ODBC, flat file, etc) and combining that with the tools you would generally use for backing up your numerical data with text (Word, Excel, Powerpoint).
With a click of a button your report is generated.
Building one cube for the reporting is a good approach, but in combining CDM with TM1 as a datasource the key is defining the correct views to use for your data queries.
From my experience with TM1 in combination with CDM you would definitely want to use CDM for keeping track of the textual data as CDM contains a very complete way of tracking any changes, which is what you would probably want as an audit trail.
The strength of CDM is dynamically loading numerical data from predefined sources (not just TM1, but any ODBC, flat file, etc) and combining that with the tools you would generally use for backing up your numerical data with text (Word, Excel, Powerpoint).
With a click of a button your report is generated.
Building one cube for the reporting is a good approach, but in combining CDM with TM1 as a datasource the key is defining the correct views to use for your data queries.
From my experience with TM1 in combination with CDM you would definitely want to use CDM for keeping track of the textual data as CDM contains a very complete way of tracking any changes, which is what you would probably want as an audit trail.