Workday Adaptive Planning 2023 R1 Release Review

Jessica Meldrum

Jessica Meldrum

B.Com (BA & SCM), BA (PR)

CONNECT
QMetrix boardroom meeting

The drilling capabilities in Web Reports has been enhanced, allowing report developers the ability to control the drill through options for reports.

In Report Properties there is a new tab labelled Drill. Here, report developers are able to select and deselect the dimensions and attribute available for the end user to explore. If nothing is selected, all options will be available.

Screenshot of a "Report Properties" settings page in adaptive planning 2023 r1 release, displaying the "Drill" tab with a list of selectable dimensions and attributes for drill-down options.

User experience updates

  • Parameters can be expanded or collapsed from the report viewer
  • Updates to the report snapshot and report download pages
  • Ability to cancel and return to the previous page when on the report prompting page
  • Ability to refresh entire matrix report viewer after making a parameter change or selecting save as

Some of the most exciting enhancements that have come out of the Workday Adaptive Planning 2023R1 release are related to dashboards.

Scatter Charts

Scatter charts have been introduced in Workday Adaptive Planning dashboards. This can be found alongside all of the other visualisations available for analysis.

A dashboard interface displays chart options on the left menu, with the "Scatter" chart type highlighted in red—reflecting updates from the adaptive planning 2023 r1 release.

Users are now able to set up links on dashboards to web reports, making the process of navigating between dashboards and reports easier. It also allows you to analyse your plans from a single location.

From the charts option, insert a Text. From the popup menu, select Insert Link

A software interface from the Adaptive Planning 2023 R1 release displays chart options on the left and a text editing box on the right, with the "Insert link" button highlighted in the toolbar.

You can then either select a Shared Report or insert the report URL.

A dialogue box titled "Enter Link" with options to select link type (Report or URL), a dropdown for Shared Report, a text field, and OK and Cancel buttons, reflecting enhancements from the Adaptive Planning 2023 R1 release.

Snapshot schedules

Dashboard snapshot schedules can now be paused and resumed on command. A new column is also included in the schedule to identify whether the schedule is paused or active.

Sheets on dashboards

The “Optimise Sheet” option has been enhanced. Specifically for modelled sheets, when the optimise sheet property is enabled, users are now able to:

  • Add rows
  • Copy and Paste multiple rows
  • Save changes made to the sheet
  • Add, edit and delete values.

For all sheets, when the “Optimise Sheet” has been enabled, there is also the option to change the column width and view cell notes in a pop-up window.

Creating a new Level Assigned or Assumption Sheet has been made easier with the addition of an Add New button from the Sheets overview page. Similar to the function in the Report Overview Page, this will allow you to quickly create a new sheet.

Screenshot of a spreadsheet interface, featuring a sidebar with options like "Level Assigned" and "Assumptions," alongside "Financial Statements," "P&L," and "Functional P&L"—highlighting elements from the adaptive planning 2023 r1 release.

There is also a new menu for each row which will allow you to rename, edit and delete the sheet.

Display cube sheet size

Users are now able to view the percent of capacity a cube sheet is consuming by version. If capacity on a cube sheet is fully consumed, the sheet will not be able to display data.

To view the capacity of a cube sheet, select Edit next to the sheet name from the overview section of either the Level assigned or Assumption sheet. From here, the new View Capacity option will appear.

Screenshot of a "Sheet Summary: Sensitivity Analysis" page from the adaptive planning 2023 r1 release, featuring "Done," "Erase All Data," and a "View Capacity" button outlined in red.

Users will then be prompted to select a version.

Please note – this function is only available on cube sheets.

Row totals in cube sheets

Users can now customise which row totals are visible on cube sheets. By navigating to the display options in a cube sheet, select the Hide Row Totals tab.

A settings menu in the adaptive planning 2023 r1 release showing options to hide row totals for "Class" and "Accounts," with tickboxes, a search bar, and OK or Cancel buttons at the bottom.

Version availability for list dimensions

There is now a List dimension property available under dimension details.

A software interface titled "Detail: Account" shows fields for name, short name, description, and display options with the "List dimension" tick box disabled in the adaptive planning 2023 R1 release.

By selecting one of the dimension values, we can see that there is a version settings property, allowing you to select which version to make available.

Screenshot of a settings menu in adaptive planning 2023 r1 release, displaying options for dependencies, version settings, dimension attributes, and custom properties, with "All accessible versions" selected.

By selecting Generate printable view you are able to Bulk update the dimension values to specify whether they are “available” or “not available” in the version column.

Dimension dependencies

It is now easier to see where a model uses and references dimension values through the view dependencies property. This allows you to find and erase data against a dimension prior to deleting the dimension.

Under view dependencies, there are new tabs which provide further information around issues that must be resolved before you are able to delete the dimension value.

Connect with us and stay up to date with Workday Adaptive Planning news and releases: