IBM Planning Analytics
IBM Planning Analytics (formerly TM1) is essentially a high-performance, multidimensional in-memory database for planning and analysis. Planning Analytics is targeted at business power users who build individual planning and OLAP analysis applications with the flexible database. The solution, which uses Excel as its main front end, offers capabilities for creating content (e.g. modeling, templates) in Excel and publishing it to the web.
IBM is one of the world’s largest vendors of IT hardware, software and services. The company, which generated $ 79.9 billion in revenues during 2016, has a global workforce of approximately 380,000 em¬ployees and is active in over 170 countries. At the end of 2007, IBM purchased the Canadian software vendor Cognos for about $ 5 billion (including Planning Analytics, formerly TM1) to become the center of its future business intelligence (BI) product portfolio.
IBM offers a comprehensive portfolio of BI, performance management and advanced analytics solutions. The core offering consists of IBM Cognos Analytics, IBM Planning Analytics, IBM Watson Analytics and the IBM SPSS Predictive Analytics portfolio.
Planning Analytics has been on the market since the early 1980s. Cognos acquired the product as part of its takeover of Applix shortly before Cognos itself was purchased by IBM. Due to Planning Analytics’ rich functionality for planning and OLAP analysis, and its in-memory technology, the product plays a strategic role for IBM. Planning Analytics is essentially a high-performance, multidimensional in-memory database for planning and analysis.
Planning Analytics is targeted at power users who build individual planning and analysis applications based on the in-memory database. It is not focused on any one specific industry or enterprise size.
Planning Analytics is based on a classical, three-tier client-server architecture that consists of a database, application server and front ends. All components use the multidimensional database for data storage. The data is stored centrally in the memory of the OLAP server.
Planning Analytics is especially popular in companies whose employees frequently work with Excel. Users can connect existing Excel sheets directly to the database without having to adapt to a new environment.
User & Use Cases
IBM Planning Analytics is primarily a planning/budgeting and OLAP analysis product. Based on Excel as a front end, ad hoc query and standard/enterprise reporting are also frequent use cases. Dashboards/scorecards and advanced analysis are planned use cases for nearly half of our survey respondents.
IBM targets large corporations and mid-sized companies across all industries. Nearly 70 percent of our sample comes from large corporations (with more than 2,500 employees) with a median of 500 users. The mean of 1,646 users suggests there are also some much larger implementations.
Customers achieve an average of 6 percent usage penetration among all employees (compared to the survey average of 17 percent). This indicates that the product is focused more on trained business power users than the majority of employees in a company.
Current vs. planned use
N = 32
5 products most often evaluated in competition with IBM Planning Analytics
N = 30
Percentage of employees using IBM Planning Analytics
N = 32
Number of users using IBM Planning Analytics
N = 32
Tasks carried out with IBM Planning Analytics by business users
N = 30
Company size (number of employees)
N = 32