How to create dynamic web reports in Workday Adaptive Planning

The following article demonstrates some of different ways users can build and structure their web reports. In particular, the main concepts covered include:

  • Rolling 12 months
  • Timespans
  • Previous Month YTD

Watch the video, or continue reading below.

1. Rolling 12 month in Workday Adaptive Planning

We commonly see clients create web reports using a fixed group of months in the columns, with the anticipation to create a previous 12 month report.

The issue they face here is that each month they are then required to update the months reflected in the columns. Instead, we like to suggest building a rolling 12 month report. Continue on below if you are interested in trying this out for yourself!

In the following example, the last month shown on the report is previous month.

    1. Add any 12 consecutive months to your report (shift + click on the mouse to select), then drag these to the columns of your report
    2. Drag the latest month of the 12 months into the parameters
    3. Select the remaining 11 months and drop these on top of the Time parameter
    4. In the parameters section right click on time, select Properties then, in the Choices box, choose Previous Month.


      previous month

    5. Ensure that you have added your accounts in the rows and your chosen version accordingly.

2. Timespan in Web Reports

The Timespan feature in web reports allows the report builder to control the date range and the periods shown on the report. Timespan also allows you to display the data broken down by month, quarter or year – or all of them at once!

To add a timespan to a report, drag it across from the report elements and into the columns. Right click and select the properties. Here the date range can be specified and the level of detail (month, quarter or year) can be defined.

time span

Note that both Month and Year has been selected. This means that the data that falls within the specified time range will be displayed in both month buckets and year buckets.

month year

3. How to create a Previous Month YTD report

Another common request we get is how to create a previous month YTD report that is connected to the parameters.

    1. Add in the previous month as well as Period to Date into the columns.
    2. Drag the month from the columns into the parameter section. Now drag Period to date and drop this on top of the month in the parameters, so that they are connected.
    3. Right click to select the properties of the time parameter and change the initial choice to Previous Month. Here you can also check the Prompt Before Viewing checkbox which will force the user to select the month each time prior to the report generating.

prompt before viewing

period date

Related Articles

Harness the value of your data

We help organisations across Australia, New Zealand and South East Asia achieve better performance through business and technology solutions. Can we help you too?

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information