Mapping Versions for Usage in the Variance Chart

Map the versions in order to use them in the variance chart.

Context

Before you can use a version in a variance chart, the version has to be visible. To make the version visible in the user dialog, it needs to be mapped in the model dialog for a Data Source (either BW, BPC, HANA, or Universe), because this logic will not be mapped automatically. In the live data model the versions Actual, Budget, Planning, Forecast, Rolling Forecast have to be mapped to use the functionality of version-based variance chart. It results in a comparison of a measure restricted by version based on the report designers choice, for example, Sales Volume Actual compared with Sales Volume Planning.

Map the SAC versions of the drop-down list box in the model to the corresponding version instances of the source system:

Procedure

  1. Choose Live Data connection for your model.
  2. Enter the corresponding System Type, Connection, and Data Source.
  3. Select the Version Information .
    1. Choose the corresponding version name from Select Version ID Column.
    1. Map each entry with one of the categories: Actual, Budget, Planning, Forecast, Rolling Forecast.
  4. Go to your story and when creating the variance you can use the versions.
Related Information