Symptom
- Reports received by email using Report Distributor Tool doesn't contain any data
- Reports give output without any issues when run online/offline from Report Center
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Navigate to Report Center
- Click View Schedules --> Switch to legacy Report Distributor tool
- Schedule Reports by choosing Destination as Email
- Select Email Recipients
- Click Run Report Distributor
- In the email which you have received file contains below mentioned error
[Report query or data access restrictions prevent the viewing of this component]
No data can be shown for this request. Things to try
- access to this data may not be allowed (check role permissions)
- resubmit your request
7. In the logs from Analytics you can see below mentioned exception
ERROR Hrml.DataObjects.OdsReporting.AdHoc.HrmlBizXRoleBasedSecurityException: Exception of type 'Hrml.DataObjects.OdsReporting.AdHoc.HrmlBizXRoleBasedSecurityException' was thrown.
Resolution
Suppose if a user has multiple entries in User Maintenance one with user name something@***.com and the other with EmployeeId_CompanyId then in email recipients of Report Distributor Tool we need to select one with EmployeeId.
Keywords
Report, Query, Data, Access, Restrictions, Prevent, Viewing, Component, No, Request, Things, Check, Role, Permissions, Resubmit, DataObjects, Hrml, OdsReporting, Adhoc, Exception, Thrown, HrmlBizXRoleBasedSecurityException , KBA , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , Problem
SAP Knowledge Base Article - Public