SAP Knowledge Base Article - Public

1943485 - Create Relative Selections


In release 1311 a new feature is available for Administrators in Business Analytics: Relative Selections.

You wonder what is the purpose and how to use this new feature.

Reproducing the Issue

  1. You go to the Business Analytics work center
  2. You go to the Design Data Sources view
  3. You select the Relative Selections sub view
  4. You click on the button New


The requirement for the Administrator to create relative selects was this example:

You - as a user in Financials and Accounting - work on financial reports and the current quarter is Q1. In April the usual “current quarter” relative selection changes to Q2.
However, in order to work on your business you need to select Q1 e.g. until mid of April as you still do some bookings for the first quarter.

In such scenario the Administrator would use Q1 first as value and once Q1 is no longer interesting for his organization he switches to Q2 and all reports select then on Q2.

Advantage of this new feature is that you can use one relative select in multiple selections or report definitions. If you want to change the value you need to change only the relative selection.

Without the new relative selection you need to adjust each selection and report definition which contains the old values – the key user for his objects and every end user for his own objects.


The Type of the relative selection determines in which basic time characteristic or data source the relative selection is available.

For example, when the type of your relative selection is Month you will find it in characteristics defined as Month only (e.g. Calendar Month in the Sales Order Volume report).


KBA , custom relative selection , relative selection , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions