Cognos TM1 with CDM Integration
Posted: Wed Mar 25, 2015 11:03 pm
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
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