The following updates are available in release 2.0.65 SC of Planning Analytics.
The following new features are available in Planning Analytics Workspace.
You can now open the modeling workbench from the user interface; you no longer need to enter a URL to the modeling perspective in your Planning Analytics Workspace environment.
To create a new workbench, click the Home menu , then click New > Workbench.
To open an existing workbench:
- Click the Home menu, then click either Shared or Personal, depending upon where the workbench is saved.
- Click the workbench you want to open. To make it easier to find your workbench, click the Filter icon and select Workbench. You can also search for a workbench.
- Create, edit, and delete any of these objects: dimensions, hierarchies, sets, processes, chores, and rules
- Run processes and chores
- Create and save cube views
- Edit settings for cubes, dimensions, processes, and chores
- Create drill processes, import data, import dimensions, reload, and unload cubes
- Reorder dimensions
- Refresh security, set cell security
See the updated view name when you save a view to the server
Use abbreviated format to display large numbers in a view
The Short abbreviations data format is now available to format large numbers in a view.
Depending on how large the number is, it's shortened by using a locale-specific abbreviation. In English, it's K for thousands, M for millions, B for billions, and T for trillions. For example, the value of 1500 is shown as 1.5K, and the value of 1500000000 is shown as 1.5B.
The abbreviations are locale-specific.
For more information, see Change the format of data in a view.
Assign multiple data items per slot in a visualization
You can assign multiple data items to a single slot in a visualization.
For example, in the following screen capture, the Model and Region dimensions are mapped to the Bars field.
In previous versions, only one data item could be assigned to a slot.
Create calculations for named sets
If a dimension includes named sets, you can create a calculation that is based on the set members.
To launch the calculation editor in a view, right-click a row or column label, or the rows or columns handle . Then, click Subset calculation.
The calculation options are the same as in the Summarize all calculation. The Aggregate option is available only on a server that supports aggregates.
If you created the subset calculation for specific rows or columns, the calculation is added in the grid after the related row or column. If you created the subset calculation from the rows or columns handle, the calculation is added as the last row or column.
Minor changes to the procedures for creating applications and plans
The user interface and procedures for creating plans and applications have been updated to simplify the creation and editing process. The capabilities of plans and applications remain unchanged. The information on IBM Documentation will be refreshed upon the release of 2.0.65 to describe the new interface and procedures.
In previous versions of Planning Analytics for Microsoft Excel, the installation was performed with a bundled installer. Starting in Planning Analytics for Microsoft Excel version 2.0.65, users can install and launch Planning Analytics for Microsoft Excel with the Planning Analytics for Microsoft Excel add-in.
The new add-in installation method allows users to quickly upgrade multiple instances of Planning Analytics for Microsoft Excel without having to run an installer for each instance or uninstall the previous version of Planning Analytics for Microsoft Excel.
Was this topic helpful?
11 June 2021