Symptom
How to Save the Query in Report Center for future use (Canvas report )?
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HCM Suite
- Report Center: Report - Canvas
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
- Create a New Canvas Report
- Select the Query Type ( Such as Detailed Reporting )
- Select New
- Add fields as desired and save > click on return
- 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 )
To Re-use the same query in another report
- Create a New Canvas Report
- Select the Query Type - Detailed Reporting
- In the Query list box > Search for the Query saved earlier (e.g. SF_Test_SAVE_Query)
- 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)
Keywords
Report, Center, Save, Query, Re-use, canvas, change, reuse, Save As, clone, copy , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem
Product
SAP SuccessFactors HXM Suite all versions