SAP Knowledge Base Article - Public

1908102 - Relative Selections for Fiscal Time Characteristics Not Possible

Symptom

You have created a customized data source using FIN data sources. In step 4 of the Report Wizard you are trying to assign a relative selection to a fixed value selection for a fiscal time characteristic such as Fiscal Year. However after confirming this with OK you are receiving a warning message:

Relative selects for fiscal time deleted (no keyfigure group is used)

Also you notice that your changes on this characteristic are gone i.e. the field Value Selection shows the default value again instead of Fixed Value Selection.

Environment

SAP Business byDesign

SAP Cloud for Customer

Reproducing the Issue

  1. You go to the Business Analytics work center.
  2. You go to the Design Reports view.
  3. Mark the report which was built on the joined data source and click on Edit With Report Wizard.
  4. Proceed to step 4.
  5. For the Fiscal Year attribute select Value Selection = Fixed Value Selection.
  6. Click on button Set Fixed Value Selection.
  7. For the Fiscal Year attribute click on More and choose Relative Select = last 2 fiscal years.
  8. Click OK, and then OK again.

You will get the warning message Relative selects for fiscal time deleted (no keyfigure group is used).

Also the value selection for Fiscal Year is reverted from Fixed Value Selection to No Value Selection.

Cause

This happens because relative selections require specific coding exits (e.g. for the determination of applicable fiscal year variant) which are only available on SAP delivered key figure structures. These key figure structures are only available on SAP delivered standard data sources.

Resolution

You cannot use relative selections for fiscal time characteristics (fiscal year, quarter, etc) on customized data sources.

Keywords

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

Product

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