SAP Knowledge Base Article - Public

2349672 - Calculated Columns don't work under Manage Filters

Symptom

We have created a Detailed Reporting Live Data query using Online report designer but when we are trying to filter the report based on calculated column, it is not giving any results

Environment

SAP SuccessFactors Workforce Analytics

Reproducing the Issue

  1. Login to The instance
  2. Go to Analytics Online Report Desinger
  3. Open The report > Edit Query
  4. Go to Manage Filters
  5. Apply a calculated column as filter

Cause

Limited support for calculated columns of certain data types.

Resolution

Currently the following Calculated Column definitions are not supported.

  • If a calculated column contains an Adhoc column of type timestamp
  • If an AGE function is involved
  • If it uses Conditional If/Then/Else statements
  • If the source is Learning or LMS domain
  • If the Calculated column is based on another calculated column.

 This will be an enhancement.

 

Keywords

cannot filter on calculated columns, blank results for calculated columns, date calculated columns, filter operators not working , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core 1605