SAP Knowledge Base Article - Public

2326069 - Role based security prevents the viewing of this component message - Advanced Reporting / Report - Canvas

Symptom

When running an Advanced Reporting certain users receive the following message:
[Role based security prevents the viewing of this component]

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

Reproducing the Issue

From the reporting menu

  1. Run report
  2. Select filters if applicable
  3. Done
  4. Message "[Role based security prevents the viewing of this component]" displays

Cause

 Possible causes:

  1. Missing functional permissions 
  2. Missing field level permissions

Resolution

For missing Functional permissions: With Report Center enabled, it isn't that obvious if an end user does not have the required functional permissions. Hence this has to be checked before report admins / designers share Report - Canvas reports with end users. Check and grant at least the following permission:

Manager permission Roles > Choose the desired role > Permission > Analytics permission > Detailed Reporting

Missing field level permissions: Try to find the missing permission using the Check Tool for RBP and ORD report -> 2857327 - [Q4 2019] Check Tool for Report - Canvas (Detailed & Advanced Reporting)

If the Check tool does not work, please try the following:

Find another user that can run the report successfully and has access to Report Designer.
Log in or proxy as the user that can run the report successfully.
Create a copy of the report. Use this copied report to start troubleshooting using the following:

Note: a user would need to edit the component(s) on the report designer page editor to view the underlying query

1. check the columns used in the report and check that the affected user can view the information in EC portlets for example employees

  • if the user can view this information go to step 2
  • if the user CANNOT view the information, check RBP for that user for the affected columns.
    You can also remove the affected columns from the report to see if the rest of the report can be run by the affected user

2. check filters in the report

  • try to remove all built in filters and re-run the report as the affected user

3. remove calculated columns

  • try to remove any calculated columns (that may use columns not contained in the report) and re-run the report as the affected user

4. check design of the query in the "Objects" tab

  • try to remove any objects, one at a time, that are not joined to 2 other ojects/at the end of the design that contain no columns - re-run the report as the affected user
  • try then to remove any objects, one at a time, that are not joined to 2 other ojects/at the end of the design that contain columns - re-run the report as the affected user

KB - objects design.png

5. If the affected user still cannot run the report successfully when there is only one object, no filters and no calculated columns then the issue will lie with the one object and columns left in the design of the report.

  • start removing columns one by one and re-running the report as the affected user after each column is removed until the RBP factor is found and the report starts running as the affected user.

If the issue cannot be found using these troubleshooting tips, please log a support case for assistance.

Keywords

Advanced Reporting, report, canvas, role based security, missing, permission, RBP, error, center, ORD, Online, Designer , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Suite all versions