SAP Knowledge Base Article - Public

2300382 - Tables missing via Detailed Reporting - Report Canvas section when creating a Query

Symptom

You want to create a new query via Detailed Reporting function from Report Canvas although no table is available for selection from the left panel.

2019-07-29_20-09-32.png

"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

Reproducing the Issue

  1. Login to the instance
  2. Go to Report Center an select a Report Canvas Report
  3. Select the Detailed Reporting
  4. No tables are available from the list. Instead the below message is shown:
    • Drag tables/columns onto canvas
  5. The expected is to have the list of tables/schemas fields which you can drag to the report area.
  6. In this case, the affected User did not have access to Report Table permission as it was not granted to the role the user belonged to.

Cause

User did not have Create report permissions under Reports Permission. The permissions for the domains to create and run report for Report Table and Detailed Reporting (one of the tools from Report Canvas) are the same.

Resolution

The issue is solved by providing the Create Report Permission as follow:

  1. Admin Center
  2. Manage Permission Role then select the desired Role. e.g. SFTEST
  3. Click on Permission
  4. Make sure the desired modules are selected for Create and Run Report

    2019-07-29_19-31-51.png

    2019-07-29_19-32-08.png
  1. Afterwards the respective tables should be available via on the detailed report as per below example.

2019-07-30_09-39-57.png

Keywords

online report designer, domain, schemas, ad hoc report, ord, live data , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM suite all versions