Set version

The Set Version feature can be used to compare two or more measures in the report and calculate absolute and percentage variances automatically. One-click variance analysis of measures such as current year, plan, forecasts, or budgets using IBCS templates can also be achieved.

Click Set version in the Insert tab of the toolbar. The current AC, PY, PL, and FC mapping is shown along with other measures created in the visual - such as simulations and budgets.

1. Prerequisite

A minimum of two series is required to enable Set Version.

2. Search for a series

If there are a large number of series in the report, use the Search box to find a specific series as highlighted below.

3. Map measures

The default mapping can be modified by

• Unchecking the measures to be removed from the measures field or from the 'Series' section

• Dragging and dropping the series in the corresponding measure field

The measure mapping is modified as shown below. Click Update.

4. Displaying variance fields

Based on the configurations in the Set Version window, Premium table will calculate the absolute and relative variance between the AC/PY/PL/FC measures. You can view the variance fields from the Manage Columns interface. Select the variance fields that are required for your report.

Variance fields are displayed in the report.

Another way to access the Set Version dialog box is by using Manage Columns. Click Manage columns and then the settings icon.

Select the Versions tab as shown in the image. You can assign measures and configure variances as we saw in earlier sections.

In the next section, we'll look at paginated reports.