SAP Knowledge Base Article - Public

2779479 - Role based security issue or blank result in WFA report with custom member and scorecard - Workforce Analytics

Symptom

  • Users are facing the "Role based security" issue in a WFA report that has a scorecard or any report component with a custom member
  • The report is blank for some users (e.g. admin user)
  • An admin user is able to run the report successfully
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SuccessFactors Workforce Analytics (ANA) - All versions
SAP SuccessFactors HCM Suite

Reproducing the Issue

Role Based Security issue in Scorecard:

  1. Create a WFA/Canvas report in Report Center
  2. Add a Scorecard table component
  3. Select a custom member as a measure
  4. Under the Columns tab add a new column
  5. Select Dimension for Type
  6. Set a static dimension e.g. Location in "North America"
  7. Share the report with an user who has Tree Security permission only to see data from Location in "Europe"
  8. When this user runs the report, he sees the "Role Based security" error message
  9. The same can happen if editing the scorecard, a static filter is applied under the Filters tab

Role Based Security issue in a Report Component:

  1. Create a WFA/Canvas report in Report Center
  2. Add a report component (e.g. Composite Query)
  3. Select a custom member as a measure of the query
  4. Share the report with an user who has a restriced Tree Security permission to all items e.g. Location, Supervisor and Org Unit
  5. When this user runs the report, he sees the "Role Based security" error message

Blank result:

  1. Create a WFA/Canvas report in Report Center
  2. Add a Scorecard table component
  3. Select a custom member as a measure
  4. Under the Columns tab add a new column
  5. Select Dimension for Type
  6. Set "Selectable Structure" as dimension
  7. Run the report with an Admin user and check that the result is blank

Cause

  • Role Based Security issue in Scorecard: The user does not have permission in Tree Security to see the data that was set in the dimension or filter of the scorecard.
  • Role Based Security issue in Report Component: The user needs at least one Top Level node permission in Tree Security (e.g. All Locations) to run WFA reports with custom members
  • Blank result: The current runtime filter (e.g. All Org Unit) is not fetching any result from the custom member

Resolution

Role Based Security issue in Scorecard:

Review the Tree Security configuration of the user i.e. enable the permission to access the data that was defined in the filter (e.g. Location in "North America") or change the filter/dimension configuration of the component to use a dynamic filter e.g. Selectable Structure:
selectable structure.png

Role Based Security issue in Report Component:

Enable at least one top Level node permission in Tree Security (e.g. All Locations) for the user to run WFA reports with custom members:

rbp.png

Blank result:

You can either set a static filter in the component to something that you know will bring data or use the Filters panel while running the report (e.g. Report By in a specific Org Unit).

See Also

2371918 - Custom Member filter is not working or it is not available for some users

2359762 - Custom Member not appearing in filter selection

2366301 - Range Types in WFA Tree Security

Keywords

Role based security issue WFA report scorecard component custom member calculation workforce analytics user blank scorecard tree security , KBA , LOD-SF-WFA , Workforce Analytics & Planning , How To

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions