The primary use case of this solution is our budgeting tool, and actuals reporting.
FP&A Manager at a leisure / travel company with 501-1,000 employees
A stable solution for budgeting, but it isn't user-friendly with Excel and needs to have inbuilt reporting
Pros and Cons
- "The most valuable feature is that it is able to slice and dice the data."
- "It's wonky, and not super user-friendly with Excel."
What is our primary use case?
What is most valuable?
The most valuable feature is that it is able to slice and dice the data.
What needs improvement?
It's wonky, and not super user-friendly with Excel.
The use case is only by fiance, but It should be able to be used by the end-user of the business.
For how long have I used the solution?
I have been using an older version of IBM Planning Analytics in our company for a year and three months.
Buyer's Guide
IBM Planning Analytics
October 2024
Learn what your peers think about IBM Planning Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
What do I think about the stability of the solution?
This solution is stable and we have not experienced any issues.
What do I think about the scalability of the solution?
It's scalable to the finance team and with the growth of the team, but not for the entire company.
There are two users. This includes myself, and I am an FP&A manager, and I have an analyst on my team.
How are customer service and support?
We have a support agreement with a third party. We have not worked directly with technical support through IBM.
How was the initial setup?
I wasn't a part of the initial setup, but I know that it is complex.
It takes months to deploy.
What's my experience with pricing, setup cost, and licensing?
Our licensing cost is approximately $50,000.00 per year.
What other advice do I have?
My advice is that if you are going to be using IBM Planning Analytics, make sure that you get your data structure correct ahead of time. You will need to add a separate reporting tool.
In the next release, I would like to see reporting joined in with the tool.
I would rate this solution a four out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT Analyst at a tech services company with 10,001+ employees
It provides data storage with write-back ability. Businesses who are familiar with Excel can use it.
What is most valuable?
The most valuable features are the TM1 Perspective client and the storage of data with write-back ability. Since most businesses are familiar with Excel, they are easily able to use this tool. Also, calculations are faster compared to any other tool for quick forecasting and budgeting.
How has it helped my organization?
This tool is able to promptly consolidate all business unit data for enterprise-view and understand the area of improvement, instead of a traditional Excel-based disparate solution.
What needs improvement?
Data visualization and development interface are areas which need to be worked on.
Improvement in data visualization
Currently in TM1, web and perspective data is visualized with limited dashboarding capability and also for creating fancy reports for top management. There is a need for incorporation of functionalities similar to QlikView or Tableau solutions.
Improvement in development interface
In TM1, the conventional development interface of process and rules are not development friendly, thus reducing productivity. I would suggest to have functionalities similar to that of Java development with Eclipse, auto population of functions and validations, etc.
For how long have I used the solution?
We have used this solution for around more than 10 years.
What do I think about the stability of the solution?
It is one of the stable tools available for forecasting and budgeting.
What do I think about the scalability of the solution?
I have not encountered any scalability issues. Since this tool is in-memory based, it also vastly depends on the hardware infrastructure capability, especially the RAM.
How are customer service and technical support?
Moderate level of support is required for this tool. Business individuals can perform some of the activity themselves, provided they are equipped with necessary access and appropriate solutions during initial training.
Which solution did I use previously and why did I switch?
Previously, multiple Excel sheets were used by us. We not only found it difficult to consolidate but also calculations were not centralized and had no security around the data. However, TM1 provides centralized data in a secured manner and calculations are done on the fly without any delay.
How was the initial setup?
The initial setup was straightforward. IBM provides a license based on the requirement and infrastructure, which need to be provisioned as per estimated size of the model.
What's my experience with pricing, setup cost, and licensing?
The pricing policy depends on your requirement and IBM provides an entire range of options as per the need.
Which other solutions did I evaluate?
Tool evaluation has been done based on the requirement and capability of the tool. TM1 is the best capable tool to satisfy most of our requirements.
What other advice do I have?
For forecast, budgeting and reporting financial data, TM1 is the best tool in the market. So, I would say that it would be wise to proceed with this tool in any organization for improvised end results.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
IBM Planning Analytics
October 2024
Learn what your peers think about IBM Planning Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
Managing Consultant/Director at a tech services company with 51-200 employees
It is a modeling tool that allows us to create customized budgeting, planning and reporting solutions.
What is most valuable?
It provides all the required functionalities for Financial Performance Management, such as planning, budgeting, forecasting, consolidation and dimensional reporting and analysis.
TM1 is actually a modeling tool that allows us create our own customized budgeting, planning and reporting solutions.
How has it helped my organization?
We have been using this software to implement solutions in many different areas of business.
For example, in budget applications, it helps a lot in running the budgeting process properly. All budget inputs, calculations, submissions, reporting and analysis during the budgeting process are handled with TM1 properly.
What needs improvement?
The CAFE Excel plug-in needs to be improved to handle all the features of older TM1 Perspectives plug-in for Excel.
CAFE is an Excel add-in that allows interacting with TM1 data from within Excel, especially for generating Excel-based reports out of TM1 data. It is actually called IBM Cognos Analysis For Excel, but usually referred to as IBM Cognos CAFE. It comes with TM1. For the same purpose, we have been using IBM Cognos Perspectives for Excel for many years. CAFE is a newer tool than Perspectives, and it needs to be improved to cover some of the functionalities that already exist in Perspectives.
We know that IBM is already working on improving CAFE. In the upcoming release, probably, we will see a lot better functionality in CAFE.
For how long have I used the solution?
We have been using it for the last seven years, since version 9.4.
What do I think about the stability of the solution?
It is a very stable software product; no major stability issues.
What do I think about the scalability of the solution?
Scalability is the best feature of TM1; it is highly scalable. As the data and model grow, all we need to do is to keep the HW aligned with the increasing size of the model.
How are customer service and technical support?
All technical support information is available by Google search, but for new issues, IBM provides a good level of remote support.
Which solution did I use previously and why did I switch?
Prior to TM1, we had been using IBM Cognos Planning.
TM1 is a lot more scalable than IBM Cognos Planning. IBM Cognos Planning is only an Enterprise Planning tool. However, TM1 is also an OLAP reporting and analysis tool, in addition to being an enterprise planning tool. TM1 provides more capabilities for customization.
How was the initial setup?
TM1 is not a packaged application. It is an application development platform and toolset for performance management. Hence, you need to do a good implementation project to get an application built based on your requirements. Therefore, it is important to work with people with the proper technical skills and business knowledge. Technical installation of the platform was relatively straightforward.
What's my experience with pricing, setup cost, and licensing?
For companies that require less than 50 users in TM1, it might be better to get IBM Cognos Express PM licenses. If you require more users, then you might need to get IBM Cognos PM licenses. There is also an unlimited user licensing model, which is based on server PVUs.
What other advice do I have?
I recommend making a proper requirement analysis and model design before start developing models with TM1.
In your first implementation of TM1, it is very important to work with experienced TM1 developers.
It is better to choose TM1 consultants with both technical and financial skills and knowledge.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an IBM Business Partner and we provide implementation services to companies using IBM Cognos TM1.
TM1-Senior Consultant at a tech services company with 51-200 employees
Allows you to plan, analyze, and report data.
What is most valuable?
- Flexible: You can do almost anything you want
- Can be combined with other software
- Calculates values
- Decides who can write and read the values
- Can be used to design your reports, almost exactly as you want
- Can be used to plan/analyze/report anything. If you miss some stuff, you can program it and combine it with TM1.
I don't think there are many tools out there that are as flexible as this solution.
What needs improvement?
The surface design needs to be improved. The disadvantage is the old-fashioned surface of IBM Cognos TM1.
I would like to see a more modern design for IBM Cognos TM1 Perspectives/Architect. It is not as modern as some of the other products with which you can do your analysis and planning.
For how long have I used the solution?
I have used this solution for several years.
What do I think about the stability of the solution?
The last version,10.1, was not really stable at the beginning. However, the latest version is fine.
What do I think about the scalability of the solution?
I did not encounter any scalability issues.
How are customer service and technical support?
The technical support is okay. You can also find lots of answers in different forums on the internet.
Which solution did I use previously and why did I switch?
We were not using any other solution previously.
How was the initial setup?
The initial setup was not complex.
Which other solutions did I evaluate?
I personally have not evaluated other options. However, my company has looked at other solutions.
What other advice do I have?
It is the best solution you can have. However, you have to know what you need for sure and what you want to do with the tool.
Every product is established for some special needs. It depends on what you need. You can choose the right tool accordingly.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are a premium business partner.
President & Co-Founder at VERSATIL BPI INC
Advanced, flexible, easy to use, and one of the best
Pros and Cons
- "The ease of use is valuable. The fact that it's plugged into Excel spreadsheets is also valuable. It provides additional functionality where you can slice and dice the information in a way that you can't do with spreadsheets"
- "It is a bit expensive, but it does the job."
What is our primary use case?
We're a business partner of IBM. We resell Planning Analytics, and we have clients utilizing Planning Analytics.
How has it helped my organization?
Our clients really like it because they're able to do their budgeting, planning, and forecasting using it. It connects to their Cognos dashboard. We do the integration between different technologies with Cognos and TM1. We also do predictions with SPSS.
What is most valuable?
The ease of use is valuable. The fact that it's plugged into Excel spreadsheets is also valuable. It provides additional functionality where you can slice and dice the information in a way that you can't do with spreadsheets.
We really like the flexibility of it.
What needs improvement?
It is a bit expensive, but it does the job.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
It can scale big.
How are customer service and support?
They've been very good with us and our clients. It has been fine.
How was the initial setup?
It is easy to set it up. It has a familiar interface. It is like using the Excel interface.
What's my experience with pricing, setup cost, and licensing?
It is a bit expensive, but you get what you are paying for.
What other advice do I have?
It is a great tool. It is quite advanced. There is not really any other equivalent on the market right now. To implement this type of tool, you need to be surrounded by a good partner to make sure that you can benefit from it.
Implementing TM1 is not just about financials. It is also about understanding the data structure and making sure that you have a good design in the backend to take full advantage of TM1.
I've been in this industry for about 30 years, and I really like Planning Analytics. I would rate it a 10 out of 10. It is absolutely one of the best.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Principal Consultant at a tech consulting company with 51-200 employees
Cognos BI/TM1: An Expected Integration
In recent years, IBM has worked towards the integration of two major components of its Information Management offering: Cognos BI and Cognos TM1.
The pairing of the two IBM IM flagships is gradually becoming an appealing combination for the vendor on the BI front. In this article, I will describe some of the main integration points from a technological point of view, some of their advantages for the business and related considerations.
Portal integration
Historically, the first effort made towards the integration of the two products consisted of making TM1 components available in Cognos Connections. Today, we have a series of widget and servlets serving this purpose. A user can, for example, access TM1 Applications (formerly TM1 Contributor) from within Cognos Connection or browse a TM1 cube in Business Insight. Although this approach provides a single point of entry for both products and represents a first step towards the integration, it can barely be considered an applicative integration as no real communication occurs between the two toolsets. For example, users are forced to identify twice (once in Cognos BI, once in TM1) even if they seem to be working in the same application. The workaround for this issue is discussed in the paragraph on shared security.
TM1 as a datasource of Cognos BI
Since Cognos 8 latest versions, TM1 cubes are fully supported datasources of the BI suite. This allows the TM1 cubes to be analysed and reported on within the various Cognos BI studios. The direct advantage of this is that TM1 has renowned performance when handling large amounts of data and can be leveraged in the Cognos BI reporting suite. Another not so direct advantage is the ability to mix budgeting and forecasting data from the TM1 cubes with operational data from a classic data warehouse. This requires both TM1 cubes and the data warehouse to be prepared upstream, but the benefit can be huge (actual vs budget data comparison, strategic dashboard). It has to be emphasized that in order to use TM1 cubes in Cognos BI, some additional developing effort is necessary. For example, in TM1, it is important to create aliases for the elements of the dimensions so that they are properly displayed in the BI reporting tools. A measure dimension has to be explicitly defined as well and named levels have to be created to allow the use of all the Report Studio functionalities when consuming a TM1 cube.
Framework Manager as TM1 logical Layer
Thanks to the more recently introduced IBM Package Connectors, Framework Manager Packages can now be used as datasources in TM1 Turbo Integrator, not unlike Cognos Transformer using Framework Manager Packages (or Impromptu IQDs for those who have been in the game for longer) as a datasource. The difference being that TM1 requires dimensionally modelled packages. This means that all the dimensional modelling happens in Framework Manager and that TM1 role is limited to storing and retrieving the data. Cognos FWM acts in this case as the sole semantic layer for classical BI packages (relational or dimensional) and TM1 cubes. If governed properly, this strategy will facilitate data consistency across the TM1 and Cognos BI platform and ensure the business logic is the same across all the solutions. This method requires the creation of TI process based on Framework Manager DMR package. The main TI process then generates a series of sub-processes (one per imported dimension) automatically. The code created this way is not necessarily easy to read (and probably was never intended to be read), which can be confusing for TM1 developers used to be in control of their TI processes.
You can now browse your FWM DMRs and use them as datasource in your TI processes.
Security
Major steps towards a unique authentication/security service for the two products have been taken in the recent years. TM1 can access Cognos BI authentication namespaces, including the third-party authentication provider namespace, meaning that BI users and user groups can be used to implement security in TM1. The implication for the end user is that they can use the same login to access both TM1 and Cognos BI content by identifying only once in the Cognos Connection portal. However, row-level security strategy implemented in Framework Manager (using security filter, for example) will have to be re-implemented in TM1 using element or cell level security.
On the other hand the groups on which the security is based won’t need to be recreated as they can be imported from Cognos BI. Ways of reducing the amount of duplicate work include creating and maintaining a relational table on which both Framework Manager Security filters and TM1 element/cell security would be based.
Cognos BI Groups and Users are available in TM1 Security.
As we have seen, TM1 and Cognos BI are more integrated version after version. Although the integrating process is not entirely smooth yet, it is already possible to achieve very interesting outcomes using this combination. As for all BI toolsets, there is no one size fits all and this may not be the best option for your needs. Generally speaking, the TM1 / Cognos BI combination is an option to be seriously considered when TM1 is already implemented in the company as a forecasting solution.
Disclosure: My company is partners with SAS, SAP, MicroStrategy, Informatica, Panorama & AnalytiX
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Accounting Services Finance Manager M&S at a hospitality company with 10,001+ employees
Brings together data from different platforms and it's all very well integrated
Pros and Cons
- "All the different platforms are well integrated."
- "Extracting data is a little slow."
What is our primary use case?
I'm an accountant services finance manager and we are customers of IBM.
What is most valuable?
I like that the solution brings together a lot of data from different platforms and it's all integrated.
What needs improvement?
I'd like to see an increase in speed on extracting the data. That would be an improvement.
What do I think about the stability of the solution?
It's a very stable solution.
What do I think about the scalability of the solution?
This is a scalable solution.
What's my experience with pricing, setup cost, and licensing?
I think the price is okay, of course it's always good to have a discount.
What other advice do I have?
I would rate this solution an eight out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Managing Consultant at Cubewise
Is robust and stable, and easy to implement
Pros and Cons
- "It's a very stable, robust product."
- "The dashboard is very poor and needs a lot of improvement."
What is most valuable?
My favorite features of IBM Planning Analytics are the integration with Access and the ETL integration tool, TurboIntegrator.
What needs improvement?
The dashboard is very poor and needs a lot of improvement.
For how long have I used the solution?
I have more then 10 years of experience with IBM Planning Analytics.
What do I think about the stability of the solution?
It's a very stable, robust product.
What do I think about the scalability of the solution?
I rate the scalability of IBM Planning Analytics at nine out of ten. There may be 400 to 900 users depending on the client.
How are customer service and support?
I would rate IBM's customer service at nine out of ten.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup is straightforward, and I'd rate it at nine out of ten. Depending on the complexity of the requirements, the deployment can take a minimum of one month to a maximum of three months. A team of five to 10 can handle the deployment.
What's my experience with pricing, setup cost, and licensing?
IBM Planning Analytics is not the cheapest solution, but it's priced per the market standard for this type of solution. I rate the price at seven out of ten.
What other advice do I have?
I recommend IBM Planning Analytics and rate it at nine out of ten. It's a great tool.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Download our free IBM Planning Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Product Categories
Business Performance ManagementPopular Comparisons
Microsoft Power BI
Databricks
Amazon QuickSight
IBM Cognos
SAP Analytics Cloud
Qlik Sense
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
SAS Visual Analytics
MicroStrategy
Oracle Analytics Cloud
Oracle Hyperion
Buyer's Guide
Download our free IBM Planning Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- TM1 Express vs. TM1 Enterprise
- Is Board better than Anaplan as a Business Intelligence (BI) solution?
- What business performance management software do you recommend for a large enterprise?
- What are the most important metrics to track in business performance management?
- What are some of Profile Management's use cases?