TrustRadius
IBM Cognos TM1 (formerly Applix TM1) is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level.Cognos TM1, Finance's Best FriendCognos 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.,10,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.,Adaptive Insights,IBM Cognos, Microsoft SQL Server, Oracle Financials,Yes,Price Product Features Product Usability Product Reputation Prior Experience with the Product Vendor Reputation Existing Relationship with the Vendor Positive Sales Experience with the Vendor,I would avoid the technology bake-off and have each technology used in a simple POC to show how each would handle our company's specific needs.,Yes,8,Yes,It was month in and our Cognos TM1 application was logging out users and the reason wasn't obvious. I called my TAM and the issue was resolved without an intra-day application restart and the user interruption that can cause.,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.,Yes, but I don't use it,9IBM Cognos TM1 proves Flexible and On-Demand!Internally, at BPM NW Cognos TM1 is used for financial performance management including budgeting, planning, forecasting as well as operational reporting of balance sheet, P & L and Cash Flow analysis. The financial forecasting is partly driven by a second TM1 application which predicts sales pipeline and consulting revenue activities. Externally, BPM NW offers ten individuals with nearly 70 years of combined TM1 development experience using IBM and industry standard best practices in a wide variety of industries including healthcare, retail, banking, hospitality, transportation, manufacturing, government and many others. These applications are often developed in conjunction with IBM Cognos BI report development and/or Data Warehouse development.,TM1 is tremendously more flexible than the competitor products due to its ability to calculate real-time. Hierarchy changes are instantly available to take advantage of the real-time calculation. No pre-consolidations needed! Native write-back capability allows for simple, integrated budgeting, forecasting and what-if analysis. IBM is constantly improving the product and integrating with new products like Cognos BI, SPSS and is now beginning to integrate it with Watson Analytics. New cloud versions of TM1 are now providing some really great web-based tools to simplify and streamline the presentation development and strengthen the self-service reporting, analytics and what-if analysis capacity.,The ETL tool (Turbo Integrator) is very powerful, but a bit clunky: It has no debugging tool provided and doesn't even offer a simple Find function. As a result, many developers use Notepad++ with a Language template to assist in development. Cube rules are an extremely powerful tool that is hard to match in the industry. The problem here is similar to TI, there is no debugging tool available, though the Rules Editor at least provides a Find/Replace function. The relatively new Performance Modeler (PM) has some nice features and can be a nice tool as a replacement for Turbo Integrator (TI) and Rules. The problem is that once you develop with PM, you cannot go back to TI or the Rules Editor and you cannot "tweek" the PM code to improve performance or allow for exceptions or special circumstances that the PM interface does not handle.,9,Internally, using TM1 has streamlined our inter and intra-team communication. Internally and externally, TM1 has improved our accuracy in predictive analytics of our project costs and completion targets. Externally, we are better able to deliver the project needs of clients through transformation of their raw data into meaningful, appropriate, timely and insightful information.,MicroStrategy Analytics, Anaplan, SAP Business Objects and Tableau Desktop,Microsoft SQL Server, Oracle DatabaseTM1 is one of the best business application development platformsPerformance is amazing because of it's in-memory OLAP engine. With a little experience, it's a great rapid deployment platform that can model just about any business process. It is actually quite scalable considering the amount of RAM that can be installed on servers nowadays. Easy to setup and migrate to a new environment.,It lacks a pretty user interface. Learning curve can be high for non-technical person. Getting data out of the system could be easier.,With the right mix of consultants, contractors, and internal W2 employees, ROI can be as high as 160 hours saved per month for a $100K project.,10,10Pros and Cons from an Admin UserIBM Cognos TM1 has been used by the overseas operations in Latin America (8 countries + the regional office in Miami) for which I am responsible. At the corporate level, it has been also used by the European, Asian and International head office in Philadelphia. The business problems it addresses include: performance issues, not easy to manage the security access, hard work to make changes and or enhancements (the processes scripts are very sensitive and it could incur in errors).,Unique data base Most of the calculations are in real time The dimensions can be easily moved to customize the views The calculations are consistent acrros the application The expense allocation process is very effective,Security access Automate processes (some of them have to have user intervention to get the real time results) Performance More user friendly to upload data,8,Reliable data base Consistent calculations accros the application avoiding formula errors Easy consolidation (aggregation) Faster currency conversion,TM1I currently work for a company that provides TM1 services to a wide range of companies. We are involved in installation, development, upgrades, designing reports any and everything related to TM1. It is what we specialize in as a company. TM1 is the most flexible and efficient platform I have worked with. The speed at which it can perform on the fly computations is unbelievable.,Flexible OLAP engine that can report on multiple data dimensions. Ability to perform what if analysis using on the fly calculation speed. Can handle large amounts of data and report on various views within cubes.,TM1 web has bugs in formatting. No text editor provided for Rules. Not able to compare multiple user sand boxes for planning analysis.,10,Increased employee efficiency. Employees have more time to analyze the results because little time is spent gathering or compiling data More accurate forecasts and predictions based on the data due to it's efficiency Better planning for future years based on accurate historical data,Oracle Data Warehouse
Unspecified
IBM Planning Analytics
47 Ratings
Score 8.5 out of 101
TRScore

IBM Planning Analytics Reviews

IBM Planning Analytics
47 Ratings
Score 8.5 out of 101
Show Filters 
Hide Filters 
Filter 47 vetted IBM Planning Analytics reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-5 of 5)
  Vendors can't alter or remove reviews. Here's why.
No photo available
March 28, 2018

IBM Planning Analytics Review: "Cognos TM1, Finance's Best Friend"

Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
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.
Read this authenticated review
Christopher Redmond profile photo
May 13, 2016

IBM Planning Analytics Review: "IBM Cognos TM1 proves Flexible and On-Demand!"

Score 9 out of 10
Vetted Review
Reseller
Review Source
Internally, at BPM NW Cognos TM1 is used for financial performance management including budgeting, planning, forecasting as well as operational reporting of balance sheet, P & L and Cash Flow analysis. The financial forecasting is partly driven by a second TM1 application which predicts sales pipeline and consulting revenue activities.

Externally, BPM NW offers ten individuals with nearly 70 years of combined TM1 development experience using IBM and industry standard best practices in a wide variety of industries including healthcare, retail, banking, hospitality, transportation, manufacturing, government and many others. These applications are often developed in conjunction with IBM Cognos BI report development and/or Data Warehouse development.
  • TM1 is tremendously more flexible than the competitor products due to its ability to calculate real-time.
  • Hierarchy changes are instantly available to take advantage of the real-time calculation. No pre-consolidations needed!
  • Native write-back capability allows for simple, integrated budgeting, forecasting and what-if analysis.
  • IBM is constantly improving the product and integrating with new products like Cognos BI, SPSS and is now beginning to integrate it with Watson Analytics.
  • New cloud versions of TM1 are now providing some really great web-based tools to simplify and streamline the presentation development and strengthen the self-service reporting, analytics and what-if analysis capacity.
  • The ETL tool (Turbo Integrator) is very powerful, but a bit clunky: It has no debugging tool provided and doesn't even offer a simple Find function. As a result, many developers use Notepad++ with a Language template to assist in development.
  • Cube rules are an extremely powerful tool that is hard to match in the industry. The problem here is similar to TI, there is no debugging tool available, though the Rules Editor at least provides a Find/Replace function.
  • The relatively new Performance Modeler (PM) has some nice features and can be a nice tool as a replacement for Turbo Integrator (TI) and Rules. The problem is that once you develop with PM, you cannot go back to TI or the Rules Editor and you cannot "tweek" the PM code to improve performance or allow for exceptions or special circumstances that the PM interface does not handle.
TM1 is first and foremost an analytical tool which lends itself very well to budgeting, forecasting, what-if analysis and model design flexibility.

Often times, users not familiar with analytical concepts view the tool as little more than another data source to extract data into MS Excel or MS Access to "rotate the cube". What they fail to realize is that TM1 is already a cube environment with Excel interfaces available as well as report publishing on the web and other capabilities.
Read Christopher Redmond's full review
David Chen profile photo
July 30, 2013

IBM Planning Analytics Review: "TM1 is one of the best business application development platforms"

Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Performance is amazing because of it's in-memory OLAP engine.
  • With a little experience, it's a great rapid deployment platform that can model just about any business process.
  • It is actually quite scalable considering the amount of RAM that can be installed on servers nowadays.
  • Easy to setup and migrate to a new environment.
  • It lacks a pretty user interface.
  • Learning curve can be high for non-technical person.
  • Getting data out of the system could be easier.
Software may not be cheap but a cheaper version (IBM Cognos Express) is out there if you don't have that many users.
Read David Chen's full review
No photo available
September 16, 2015

IBM Planning Analytics Review: "Pros and Cons from an Admin User"

Score 8 out of 10
Vetted Review
Verified User
Review Source
IBM Cognos TM1 has been used by the overseas operations in Latin America (8 countries + the regional office in Miami) for which I am responsible. At the corporate level, it has been also used by the European, Asian and International head office in Philadelphia.

The business problems it addresses include: performance issues, not easy to manage the security access, hard work to make changes and or enhancements (the processes scripts are very sensitive and it could incur in errors).
  • Unique data base
  • Most of the calculations are in real time
  • The dimensions can be easily moved to customize the views
  • The calculations are consistent acrros the application
  • The expense allocation process is very effective
  • Security access
  • Automate processes (some of them have to have user intervention to get the real time results)
  • Performance
  • More user friendly to upload data
The what if scenarios feature is not fully appropriate to get a complete P&L result. The copy process for Versions and Scenarios is not 100% reliable. The key questions are in regards to the real time information, high performance with a big sized data base and processes, user friendly, easy maintenance.
Read this authenticated review
No photo available
February 01, 2015

IBM Planning Analytics Review: "TM1"

Score 10 out of 10
Vetted Review
Verified User
Review Source
I currently work for a company that provides TM1 services to a wide range of companies. We are involved in installation, development, upgrades, designing reports any and everything related to TM1. It is what we specialize in as a company. TM1 is the most flexible and efficient platform I have worked with. The speed at which it can perform on the fly computations is unbelievable.
  • Flexible OLAP engine that can report on multiple data dimensions.
  • Ability to perform what if analysis using on the fly calculation speed.
  • Can handle large amounts of data and report on various views within cubes.
  • TM1 web has bugs in formatting.
  • No text editor provided for Rules.
  • Not able to compare multiple user sand boxes for planning analysis.
IBM Cognos TM! is primarily is used for budgeting and planning because of it's speed and flexibility.
Read this authenticated review

Feature Scorecard Summary

Long-term financial planning (3)
10.0
Financial budgeting (3)
10.0
Forecasting (3)
10.0
Scenario modeling (3)
10.0
Management reporting (3)
10.0
Financial data consolidation (3)
10.0
Journal entries and reports (3)
8.0
Multi-currency management (3)
10.0
Intercompany Eliminations (2)
10.0
Minority Ownership (2)
8.0
Local and consolidated reporting (3)
10.0
Detailed Audit Trails (3)
7.0
Financial Statement Reporting (2)
10.0
Management Reporting (2)
10.0
Excel-based Reporting (2)
10.0
Automated board and financial reporting (2)
10.0
XBRL support for regulatory filing (1)
7.3
Personalized dashboards (2)
10.0
Color-coded scorecards (2)
10.0
KPIs (2)
10.0
Cost and profitability analysis (2)
10.0
Key Performance Indicator setting (2)
10.0
Benchmarking with external data (2)
10.0
Flat file integration (3)
10.0
Excel data integration (3)
10.0
Direct links to 3rd-party data sources (3)
10.0

About IBM Planning Analytics

IBM Cognos TM1 (formerly Applix TM1) is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level.

IBM Planning Analytics Technical Details

Operating Systems: Unspecified
Mobile Application:No