What’s New in Planning Analytics Workspace 87

What's New in Planning Analytics Workspace 87
What's New in Planning Analytics Workspace 87
Written by Mike Bernaiche, June 28th, 2023

On May 17, 2023, IBM released Planning Analytics Workspace 87.  A reminder that each update to Workspace is cumulative and all enhancements and fixes from previous releases are included in Planning Analytics Workspace 87.  This update includes some nice enhancements and fixes.  You can always find a detailed list of fixes by clicking here

I suggest checking this link out to see if any of the issues you may encounter have been solved in a recent release of Planning Analytics, Planning Analytics Workspace, or Planning Analytics for Excel.

Books and Reporting

Search and Filter Capability Available for Current Set in Set Editor - The Current set pane in the new experience set editor now has search and filter capabilities. Previously, these features applied only to the Available members pane in the set editor.

Search and Filter Capability Available for Current Set in Set Editor
Search and Filter Capability Available for Current Set in Set Editor

Target Selection Design and Usability Improvements – The target selection is now available on the toolbar in a book.

Expand and Collapse Rows and Columns asymmetrically or symmetrically - You can now expand and collapse rows and columns in a view either asymmetrically or symmetrically.  Click the new Expand/Collapse icon in the toolbar and select how you want to expand and collapse rows and columns.

Expand and Collapse Rows and Columns asymmetrically or symmetrically in PAW 87

Zoom Bar now Available in Additional Visualizations - The Zoom bar is now available in the following visualizations.  The Zoom bar allows you to scroll and focus on a smaller area of a visualization.

  • Box plot
  • Marimekko
  • Heat map
  • Waterfall
  • Bullet

New Properties in Map Visualization – New properties include World View, Icon, Allow Overlap, and Show Map Labels.

New Properties and Changes for the Bullet Visualization

  • New Categories Slot - A new slot under Fields lets you draw multiple bullets without the use of Repeat slots. The Categories slot allows additional sorting capabilities such as sorting by Target and Bar values.
  • Padding Properties – You can now set bullet and target marker padding under Chart in Properties.
  • Style Gridlines, Axis lines, and Labels - You can style gridlines, axes lines, and axes titles and labels.
  • Zoom Bar
  • Manual Range Values - You can now specify minimum, mid, and maximum range values manually under the new Ranges section in Properties.

Ledged Alignment in Visualizations - You can now align a legend vertically to display at the start, center, or end of the plot area in visualizations.  In combination with the Legend position, this new property allows you to position the legend in twelve different areas in the visualization.

Configuration Modification for Learn Pane - The cognitive Learn Pane in Planning Analytics Workspace Local is now hosted on a new domain.  This change requires the following configuration modifications to Planning Analytics Workspace Local and Planning Analytics on Cloud Pak for Data to ensure continued access to documentation and other information through the Learn Pane.

This is an important change and I have put a detailed link HERE for instructions to make this change and continue using the learn pane.

Applications and Plans

New Tabs on the Contribution Panel Show Submissions and Approved Tasks

New Tabs on the Contribution Panel Show Submissions and Approved Tasks in PAW 87

Modeling

New View Related Cubes Option - You can now quickly identify which cubes on a Planning Analytics database include a specific dimension.  This is helpful when you are thinking about deleting a dimension and want to see the impact of the deletion on the cubes in your database.

Import a Data Source with Multiple Data Value Columns to an Existing Cube - If a data source includes multiple data value columns, you can now create mappings to import all data columns simultaneously into an existing cube. This is useful when importing data that has multiple value columns for days, weeks, or months.

Use New Editors to Manage Attributes and Security for Data Objects - New settings editors are available from the Databases tree on a modeling workbench, which simplifies the task of managing attributes or security for your database objects.

Manage Cell Security with a More Flexible Control Cube Structure - Previously, a cell security control cube contained all dimensions from the data cube, plus the }Groups dimension. In Planning Analytics Workspace 87, you can select which dimensions to include in a cell security control cube, which can make it easier to manage security.

Administration

View the Last Login Date for Planning Analytics Users - The last login date is not exposed in the Planning Analytics Administration interface but is included when you download a user report to a .csv file.

Include Modeling Workbenches in LifeCycle Management Snapshots - You can now include modeling workbenches when you use Lifecycle Management to copy and deploy Planning Analytics assets.

Summary

Some great enhancements in Planning Analytics Workspace 87.  Please make sure you read the bit on the Learn Pane.  This does require a small change in the setup and we are here to help you!  Reach out to us at services@lodestarsolutions.com.

Have you heard about our Analytics Success Klub (ASK)?  We believe that the best investment you can make is in yourself.   But analytic professionals are often too busy to attend expensive training. So, Lodestar Solutions in partnership with Heatherized, Inc. is bringing a unique membership program for ambitious analytic professionals that want to go to the next level. Regardless, of whether you use IBM, Power BI, Tableau, or Qlik, social skills are the secret to promotions, raises, and interesting projects.

Check out the full blog on ASK here.

X