2543169 - How to Save the Query in Report Center for future use

SAP Knowledge Base Article - Public

2543169 - How to Save the Query in Report Center for future use

Symptom

How to Save the Query in Report Center for future use ( Canvas report )

Environment

 SAP SuccessFactors HCM Core

Reproducing the Issue

  • Create a new Canvas Report in Report Center >
  • Select Detailed Reporting >
  • New Query >
  • Add the fields and save
  • Return to create another Report based on the saved report above >
  • Select new Canvas >
  • Detailed Reporting >
  • Search in the list of query, the query is not found.

Cause

The report was saved without exporting the query.

Resolution

  1. Create a New Canvas Report 
  2. Select the Query Type  ( Such as Detailed Reporting )
  3. Select New 
  4. Add fields as desired and save > click on return
  5. On the next window > on the top left there are 3 buttons, the button in the middle with up arrow is to export query. Select to export > Name and save the query ( see below screenshot )

Export and save query.png

To Re-use the same query in another report

  1. Create a New Canvas Report
  2. Select the Query Type  - Detailed Reporting
  3. In the Query list box > Seearch for the Query saved earlier ( e.g. SF_Test_SAVE_Query )
  4. The report will use the same query.

This is useful if you deleted the report, you can still re-use the same query to create the same report. ( see below screenshot )

Re-use query.png

Keywords

  • Report Center
  • Save Query
  • Re-use canvas report query
  • change query
  • save query in report center
  • reuse the canvas report query 
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core 1708