2.0.48 – What’s new, 14 January 2019
Abbreviate numbers in views to thousands or millions
In a view, you can update the data format of a number quickly making it easier to read and customise books.
Identify broken button links when you migrate a snapshot
If you migrate a book with a button, but do not migrate the target of the button, the button will be broken after migration. The snapshot logs now display a list of broken buttons enabling you to identify and resolve any snapshot migration issues faster.
This is particularly useful if you have multiple environments over which you are migrating snapshots.
2.0.47 – What’s new, 20 November 2019
Create a cube by importing a text file
You can now create and populate a cube without having to write processes by importing a test file into IBM Planning Analytics Workspace. Populating a cube via PAW creates a process in the background (so it actually automatically creates a TI).
Unfortunately, this method of upload is not dynamic and it’s quite difficult to reuse the same process for any other scenario, or even with a new set of data. It is more suitable for an ad-hoc cube upload.
Improvements to importing into dimensions
It is now possible to update existing dimension hierarchies, whereas previously you could only import into an empty hierarchy. You can also create a dimension with multiple levels by importing via text file. This means more control over the dimension structure and ease of use.
Apply aggregate calculations in a view
You can now apply aggregate calculations to two or more values in a view and use these calculations to summarise values that can’t simply be added up or averaged. This means more completeness when creating reporting views to analyse data/trends.
2.0.46 – What’s new, 15 October 2019
Quickly set the data format in the view
You can now set the format of data by column and row directly in the cell view. This is a nice feature that will make it easier to change formats whist viewing data.
Drill up on visualisations
Previously, you could only drill up on visualisations that had been drilled down on by pressing the undo button. Not only was this cumbersome but a little unintuitive. Having a drill up option next to the drill down is a feature that users will inherently look for.
See thresholds and alerts for individual databases from the database activity report page
Being able to apply unique threshold and alert settings for each database is extremely useful. This will help administrators maintain and monitor their environment proactively.
View system resource thresholds and alerts combined in a single configuration page
This complements the above update of setting thresholds and alerts. You can now configure system resource thresholds and alerts on a single page in Planning Analytics Administration. It provides greater control over multiple Agents as you can uniquely apply settings per agent whilst viewing everything in the one page.
2.0.45 – What’s new, 21 August 2019
Give your dashboards a corporate look and feel using custom fonts and chart palettes
A lot of clients want the ability to create dashboards using their company colours and branding, but previous versions of Planning Analytics Workspace did not allow for that. With this update, not only can we now create more customised dashboards for our clients but also introduce this capability to previously hesitant customers.
Show parents and children of members in the dimension editor
This is useful to identify if the correct member has been used in a set. It allows for quicker analytics and selection which will be helpful to users.
2.0.44 – What’s new, 24 July 2019
Share views between Planning Analytics Workspace and Planning Analytics for Microsoft Excel
Previously, views created in Planning Analytics Workspace could only be seen within Workspace. This led to some duplication in effort when using PAX as view editor or an exploration needed to be used to re-create views.
Refresh a book after executing a process from a button
Now, when a process is run in Workspace you select if the book should refresh after finishing. The benefit of this is that any dependant calculations are updated, without the need to press refresh on the toolbar.
Create user groups in the Settings editor
You can now easily create user groups within Workspace, which makes the task of assigning group security more straightforward for administrators.
2.0.43 – What’s new, 20 June 2019
Prevent data updates to cubes
This is an interesting concept because most people assume data updates should not occur asynchronously. Some potential use cases are to update specific cubes, prevent metadata updates or archive a retired cube and its data. I believe most people will not need to use this functionality on a regular basis. However it does have practical benefits.
Smaller tiles on the Welcome page use space more efficiently
Whilst a purely aesthetic update, I hope this is a prelude to more user customisation. The tiles are simple with a white background. In the future I hope users may be able to add specific designs/icons to help differentiate books visually.
View process error log messages directly in Planning Analytics Workspace
Previously, viewing logs could not be done in the Planning Analytics Workspace. Having this now is useful as it reduces the navigation process to open logs and identify errors, and makes logs available to end-users, rather than needing to maintain separate logging cubes.
Export to Excel now includes attribute values that are displayed in the view
Looking at attributes in view helps further analysis and understanding of data. Exporting attributes to Excel will be enable users to take their analysis offline.
2.0.42 – What’s new, 24 May 2019
Organise users into groups to make object security easier
You can now create, export, update and delete groups in Planning Analytics Workspace. This has been highly requested and will make security assignments a lot easier to manage.
Create and edit sets from the content tree
This update takes updating a set from two steps to a one step process. It streamlines opening/using the set editor.
Manage the vertical axis range to create more informative Line and Column visualisations
You can now share a vertical axis range for line and column visualisations. This means two measures can share an axis resulting in tidier graphics. Previously, two measures would be displayed on separate vertical axes.
View properties and multiple attributes in the set editor
You can now view multiple attributes and member properties in the set editor. This is useful as it gives a holistic view of the dimension and its properties.
2.0.41 – What’s new, 12 April 2019
Define drill-through directly in Planning Analytics Workspace
You can now create and edit drill rules/processes in Workspace. This provides more flexibility for reporting and analytics. For example, providing the ability to drill through to transactions from a Profit and Loss cube.
Fine tune your levels
The set editor now lets you use greater than/less than operators to define levels in a hierarchy. The benefit is users can now create dynamic hierarchy selections based on ranges of levels.
Quickly see what’s dynamic
The icons between dynamic (predictive) and static (current) sets are now different. This helps users quickly identify if they need to manually update a set or if it should dynamically change.