Cognos TM1, Finance's Best Friend
March 28, 2018
Cognos TM1, Finance's Best Friend
Score 10 out of 10
Overall Satisfaction with IBM Planning Analytics Local
Cognos TM1's ability to store and provide fast access financial data both on-premise and in the cloud makes it best-of-breed when it comes to implementation flexibility. For example, with Cognos TM1 is an in-memory OLAP data structure so data access is quick which helps out when it comes budgeting season and your FI application is getting hammered. All the while you can have one data solution that pulls data together with data from Hyperion Planning (Oracle) and Microsoft Dynamics (MM) into the same system as part of a financial consolidation project.
- Cognos TM1 is great for planning, both workforce and financial, as it allows for complex hierarchies to be built and maintained via automated routines and simple scripts.
- Cognos TM1 ability to directly connect to an external system and extract data allows you to roll your own ETL processes and keep the bottleneck (that is IT) out of your financial consolidation project.
- Cognos TM1 has the ability to be both cloud based and fully on-premise which is of great for institutions that are cloud adverse and want an alternative Adaptive Analytics.
- The memory and core management of Cognos TM1 could be improved to make system administrators happier.
- It could be cheaper on PVU basis or licenses could be more flexible to the needs of finance.
- The user community for Cognos TM1 is not lead by IBM, but instead the users/developers themselves. I think IBM could improve this somewhat by organizing things a bit better.
- The company saw positive ROI of around $100K during the first quarter following the implementation of Cognos TM1.
- The flexibility of Cognos TM1 to meet the complex planning needs of a customer allowed the implementation to be headache-free.
- Cognos TM1's use of Excel helped the finance department get onboard and pick things up quickly. This accelerated user adoption and lessened the need for paid training.
- Cognos TM1's development language is script based so anyone familiar with VBA for Excel for data processing/transformation can adapt and pick things up quickly.
Cognos TM1's ability to store and provide fast access financial data both on-premise and in the cloud makes it a great fit in a company with a small FI team. Compared to Adaptive Insights the management of Cognos TM1 is simpler and for most financial consolidation projects a full-time application administrator is not required as power users can do most things without intervention.
There are good support people in Ottawa, but having access to the development team and a TAM make the support. Without that access I don't think IBM Support would be as highly rated.
Cognos TM1's ability to store and provide fast access financial data both on-premise and in the cloud makes it a great asset during month-end or year-end closing. The speed at which it can be updated and reflect GL changes for reporting makes it well suited for PL and BL reporting. For example, when it comes budgeting season and your FI application is getting hammered a speedy application makes your user base happy. However, Cognos TM1 is not well suited for reporting when you have to store a lot of granular data, think retail transaction level stuff, as Cognos TM1 is an OLAP data structure rather than relational.
IBM Planning Analytics Feature Ratings
Evaluating IBM Planning Analytics Local and Competitors
Yes - Infinium Financials was replaced because that technology was AS/400 based and difficult to adapt to a changing company.
IBM Planning Analytics Local Support
Kept well informed
Immediate help available
Support understands my problem
Support cares about my success
Yes - I pay for premium support, because it gets me access to higher level support faster and I get a TAM assigned to my account.
Yes - Yes and no. It depends on the bug and whether is was solvable is a configuration change or was in need of a code fix from IBM.
Using IBM Planning Analytics Local
Like to use
Easy to use
Quick to learn
Feel confident using
- Data entry into the system was easy and I could bulk upload via flat files.
- Moving data between accounts within the system was simplier than other systems I've used.
- Intercompany eliminations via Rules was a godsend compared to the report level math I've had to maintain in the past.
- If you end up having to write a bunch of scripts that rarely get used in lue of users to manual things, then it can't be frustrating.
- User account setup can be cumbersome due to amount of configuration necessary to make the IT Security team happy.
- Cognos TM1 has be a system that is easy to maintain, but it is only as easy as the accountants make it. Getting them to understand that is it not an Excel workbook in the sky can be challenging.