2.0.60 - Feature updates and known issues, December 17, 2020
IBM® Planning Analytics for Microsoft Excel was refreshed on December 17, 2020 to include the following features and notices.
Updates to each version of Planning Analytics for Microsoft Excel are cumulative. To see what was new in previous releases, see What's new in Planning Analytics for Microsoft Excel.
Show and hide your TM1 servers
You can now select specific TM1 servers to hide in Planning Analytics for Microsoft Excel.
In previous versions of Planning Analytics for Microsoft Excel, you were shown a full list of all of the TM1 servers in your TM1 datasources when connecting to a TM1 datasource from the ribbon or from the task pane. As of Planning Analytics for Microsoft Excel version 2.0.60, you can now select specific TM1 servers to hide from these menus. For more information on this feature, see Show and hide servers in a TM1 datasource
Saving or renaming a view in the set editor
When you save or rename a view in the set editor, the title bar in the set editor now updates to display the name of the view. A view saved from the set editor now also automatically appears in the task pane.
In previous versions of Planning Analytics for Microsoft Excel, the title bar of the set editor did not update to show the name of the view. As of Planning Analytics for Microsoft Excel version 2.0.60, when you save or rename a view, the title bar of the set editor shows the updated view name. The task pane now also shows new views that are saved from the set editor without the need to manually refresh the task pane.
Quick Report sheet names in the task pane
Quick Report sheet names are updated in the Workbook tab of the task pane.
In previous versions of Planning Analytics for Microsoft Excel, the
Workbook tab only displayed the sheet number of a sheet. As of Planning Analytics for Microsoft Excel version 2.0.60, Quick Report sheets in the
Workbook tab now display a sheet name in the following format:
Sheet[sheet number] [cube name]: [report name] [Report ID number]
.
Planning Analytics for Microsoft Excel: login or server access may fail in new experience
This issue may occur only when authenticating against a local TM1 database in the Planning Analytics new experience. You will not encounter this issue when authenticating against a local database in Planning Analytics classic or any Planning Analytics on Cloud database.
When attempting to log in to a TM1 database from Planning Analytics for Microsoft Excel, you may receive the following error under certain configurations or conditions: Cannot load the requested view.
To work around this issue, you can dismiss the error and again select the desired TM1 database and continue to log in with a valid user name.
This issue will be corrected in an upcoming release.