SAP Knowledge Base Article - Public

2742771 - Access Context in Joined Data Sources


You created a customized report on top of a joined data source (left outer join) and defined an access context while creating the data source. Now when you are running your customized report the data shown is not restricted.


  • SAP Cloud for Customer
  • SAP Business by Design

Reproducing the Issue

  1. Go to the work center Business Analytics.
  2. Go the view Design Reports.
  3. Show all and search for the report ABC (ABC stands for your customized report).
  4. Run the report with the selection you would like to use.
  5. You notice that the report data shown is not restricted as expected.


The access context in your joined data source that the report was build on was not set correctly. In joined data sources (when the join condition was defined as a left outer join) the data is fetched from left to right. It starts with the anchor data source and goes to the most right data source. In this example it fetches the data from the anchor data source first and since there is no access context on this data source maintained all data is fetched.


For the access context to work correctly in joined data sources, please get the access context from the anchor data source so that the full data will be restricted. Another option would be to change the join condition to an inner join.

See Also


access context, restricted data, restriction, join data source, joins, customized report, left outer join , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions