2418519 - ORD query blank when filter removed

SAP Knowledge Base Article - Public

2418519 - ORD query blank when filter removed

Symptom

A query in Detailed Reporting, Advanced Reporting or Report Designer containing at least one Calculated Column gives blank results, either by default or when a certain filter is removed

The blank display comes up quickly so it is not timing out.

Environment

SAP SuccessFactors Online Report Designer

Reproducing the Issue

Open the query in question in the editor.  If data is showing, remove the filter in question.

Cause

If a calculated column divides by zero, it causes an error which will not allow any results to display.  Removing a filter gives the query access to more categories and more potential zeroes.

Resolution

Check the Calculated Columns for any divisors.  For each one you find, use if-then clauses to check whether the denominator is zero before applying the division.  What happens if it is zero (e.g. returning zero as a result, using an alternate field) should be decided based on the purpose of the column.

Keywords

KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors Workforce Analytics 1608