SAP Knowledge Base Article - Public

2665247 - How to identify if a query can be used in all reports - Online Report Designer

Symptom

  • Query created in Detailed Reporting is not available for selection. 
  • Could not find the name of the query used on the pivot query.

Environment

  • SAP SuccessFactors Workforce Analytics 
  • Online Report Designer
  • Pivot Query
  • Detailed Reporting

Reproducing the Issue

  1. Go to Home; 
  2. Reporting;
  3. Analytics;
  4. Create a new detailed report and try to use or create a query.

Resolution

  •  If the query name appears on the top left corner of the report, the query was created in detailed reporting, and can be used in any other report:

    query1.PNG

  • If the query name does not appear on the top left corner of the report, the query was created within the report, and can not be used in other reports:

    query2.PNG

Keywords

 ORD, query, detailed reporting, pivot query , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1805