SAP Knowledge Base Article - Public

2272271 - "No Realm is available" - Unable to select any Object or Data field from the Advanced reporting

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

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:

  1. The Advanced Reporting company was not created automatically in the Analytics backend or its setup is not correct.
  2. 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.
  3. Schema or dbpool name is incorrect in backend (wstwebapp).
  4. 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

Product

SAP SuccessFactors HCM Suite all versions