Planning Analytics

IBM Planning Analytics Newsletter - September 2020

By Robert VAUTOUR posted Tue September 15, 2020 07:31 AM

IBM Planning Analytics for Microsoft Excel Release 57 is now available for both cloud and local deployments.

With IBM Planning Analytics for Microsoft Excel release 56 you can now change the font size and save views in the Cube Viewer.

The Business Application Research Center (BARC) named IBM a 2020 market leader in integrated Planning & Analytics, with products including: IBM Planning Analytics powered by TM1, IBM Cognos Analytics, IBM Watson Studio, and IBM SPSS.

Once again, IBM received top ranks in five peer groups in the Business Application Research Center's The Planning Survey 20. 

Important Reminder: As of the release of IBM Planning Analytics, TM1 Web is no longer included in the long cadence release. It will now have its own installation kit as of 2.0.55 release

Software lifecycle can help you to stay informed of our IBM software products and help you to plan for your software product upgrades. For example if you type 'Planning Analytics' in the search box you would have these results.


Virtual Event: Data and AI Virtual Forum is focused on helping you trust your data and AI outcomes. Register now for our September Virtual Forum. Sep 16
And if you missed the July 29th Data and AI Virtual Forum, you can catch the replay.

Virtual Training Course: Join LPA's Planning Analytics Workspace Developer course. You will learn to administer and develop within your Planning Analytics environment as well as how to publish rich visualizations and modify content. Sep 21

Virtual Conference: Join PMsquare's Business Analytics Conference (BACon). The BACon 2020 will focus on solving organization's data and analytics challenges throughout the analytics lifecycle. Find your analytics journey from data to dashboard. Oct 14 and 15th 
Webinar: Ask Me Anything about IBM Planning Analytics hosted by Offering Management. Oct 8

User Group: Join LPA's virtual user group sessions. Be part of the group which will discuss visualizations, advanced planning and forecasting with Planning Analytics. There will also be Cognos Analytics demonstrations of the exciting new features including data sets and updated dashboard interfaces. Sep 17
Tech Corner

"Have you ever wondered what a DBRW formula is?" View The Quick Fix  article from Cubewise where they explain one of the key IBM Planning Analytics formulas that provides read and write back capability to Excel for the functional database.

Recent updates to popular browsers restrict cookie and tracking security by default. This can affect the expected functionality for websites. But for IBM Planning Analytics, it impacts the logout functionality, IBMid logout fails. Find out how to enable logout for Planning Analytics with most recent version of the browser.

QueBIT shares  a deep dive in 'understanding TM1 Perspectives versus Planning Analytics for Microsoft Excel', where they explain differences in formula evaluation.

Revelwood shares Tips on how to use a new feature to double click, which gives you the ability to launch an exploration browser within your Excel environment.
Cloud Corner

IBM will begin to capture metrics of your usage of IBM Planning Analytics Workspace on cloud to improve the product and its capabilities, with the release of 2.0.54. If you are based in the European Union, you will see a cookies prompt the first time you log on after the deployment of Planning Analytics Workspace on cloud. To see more information about the levels of cookies, click View Cookie Preferences.

Get help managing users in an integrated environment for Cognos Analytics on Cloud and Planning Analytics on Cloud with SSO (Single Sign-On). This integration now allows users to seamlessly move between Cognos Analytics and Planning Analytics.
Gartner Peer Review Survey
 We'd love your feedback and would appreciate your product review to help others considering IBM Planning Analytics. 

Review IBM Planning Analytics here!
On-premises Corner

TM1 Web is now being delivered in its own installation kit. Review the changes to TM1 Web Deployment for Planning Analytics local with release 2.0.55.

ExploringTM1 shows how to install or upgrade Planning Analytics for Microsoft Excel TM1 add-in.

Upgrading IBM Cognos TM1 to Planning Analytics Local or Cloud? To facilitate the upgrade process for customers who are still using TM1 or if you're planning on moving to Planning Analytics on cloud the attached documents describe the process. For assistance you can also contact us at or
Recommended Resources

Watch the replay of "Building your Planning and Analytics Reports" webinar. You will understand the reporting options available in Planning Analytics for Microsoft Excel, Planning Analytics Workspace and web sheets. 

Watch the QueBIT webinar replay of "A Bright Future with IBM Planning Analytics for Microsoft Excel. " It will provide a great overview of the benefits and future of integrating Planning Analytics with Planning Analytics for Microsoft Excel.

IBMer Nigel Sutton provides an example use case of developing rich applications using IBM Planning Analytics TM1 Rest API.

Subscribe to this newsletter.
Subscribe to IBM Cognos Analytics  newsletter

NOTE: Would you like to contribute to our Newsletters? If so, please forward your content to us @


IBM Data & AI Idea Portal

Support Portal 

Support Guide

Fix Lists for Planning Analytics Workspace and Planning Analytics for Microsoft Excel

IBM User Experience Program

Copyright © 2020 IBM

Join us on:  
Linkedin  Twitter
Subscribe to Newsletter