Symptom
When creating an Advanced Reporting query, the drop down shows 'No Realm is available' and you are not able to do anything with any of the functions on this screen.
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 HXM Suite
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
- Online Report Designer
- Advance Reporting
- Online Report Designer
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
Reproducing the Issue
1. Go to Report Center and create a new Report - Canvas
2. Add a List report table component
3. Select the component and click Edit Query
4. If the Advanced Reporting tab is available, click on New. In the new query editor window that opens, the drop down will show "No Realm is available"
Cause
Issue might be caused due to incorrect back-end configuration:
- The Advanced Reporting company was not created automatically in the Analytics backend or its setup is not correct.
- The Advanced Reporting is enabled but Employee Central is not configured > The Advanced Reporting is a feature within SuccessFactors that allows users to query Employee Central data. If Employee Central is not configured the Advanced Reporting will not work.
- Schema or dbpool name is incorrect in backend (wstwebapp).
- This error happens after instance refreshes. Advanced reporting must be manually refreshed by the support team after an instance refresh.
Resolution
In case you face one of the above scenarios please reach out to Customer support in order to change such backend configuration or to refresh the advanced reporting metadata.
Keywords
No, Realms, realm, is, available, cannot, create, query, Advanced, reporting, not, working, reports,error, rendering, list, report, blank, empty, Objects,Tables , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem