An end user opens a report for which there is an access context (for example, 1015 Employee, Territory, Account, Sales Data). Instead of seeing his own (and his employee's) data only, one of the 2 scenarios happens:
- The user sees all data
- The user sees no data at all
Reproducing the Issue
- Open the report from the assigned work center.
- Check the Access Context - it will be restricted.
- Click on Go.
Either you will see all the report data, or the report returns no results at all. For this user however, it is expected to show some specific (restricted) results.
There are 2 possible reasons for this:
A) There are no access restrictions maintained for the work center view(s) that this report is assigned to. The access context of the report can only work if there are also access restrictions on the respective work center views. If there are no restrictions, this will create a conflict.
B) The report is assigned to a work center for whic there is a conflict in access contexts. Whenever such an assignment is done, the access restricton cannot be applied.
- Go to the work center Application and User Management, view Business Users.
- Search for the respective user and click on Edit > Access Rights
- Go to the tab Access Restrictions
- Search for every work center view that the report is assigned to
- Under Read Access, maintain an access restriction.
This has to be done for all work center views that this report and this user are assigned to. If you are using business roles, please maintain a restriction on the business role level.
- Go to the work center Business Analytics, view Design Reports.
- Search for the report and click on Assign.
- From the Show dropdown, select Assigned (this will show all work centers that the report is assigned to).
- Check if there is a conflict with the access context of this work center view. If there is, the access restriction cannot work. You can unassign the report from this work center to avoid this.
2575041 - Conflict of Access Context During Report Assignment
2592130 - How to Set the Access Context of the Report
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To