SAP Knowledge Base Article - Public

2906153 - Exception/ Condition Does Not Work For a Date Key Figure

Symptom

You are trying to create an exception or condition based in a date key figure and you see it does not work.

Environment

  • SAP Cloud for Customer 

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports work center view.
  3. Search for a report.
  4. Open it.
  5. Go to Exception.
  6. Click on New.
  7. Select a date key figure.
  8. Click on Ok.

You can see it applied to all key figures.

Cause

The framework does not support exceptions and conditions on date values. Hence, any exception or condition created on a date key figure won't work.

Resolution

In a data source, a date key figure is provided to make mathematical calculations. It is not designed to be used as exception and conditions on reports. If you would like to filter or differentiate date values, you can find the same date fields as characteristics in the same data source, which can help you to get required data when providing date as a selection parameter (filter) via Selection pane in the report.

See Also

 2520400 - Exceptions and Conditions for Key Figure in a Report are not Saving

Keywords

exception key figure, key figure date, date field exception, condition date key figure, condition date field   , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-RC-ANA-UI , C4C, ByD, Travel: Analytics UI Framework , How To

Product

SAP Cloud for Customer core applications all versions