I have a data model including two data sources (SAP & Salesforce) - please see the attachment. SECURITYKEY is in SAP table. After applying section access, some data rows from Salesforce table disappear. How can this be fixed?
All rows in SAP data have a non null value for SECURITY_KEY and SAP_KEY
All rows in Customer table have values for SAP_KEY and SF_KEY
All rows in SF_KEY table have values for SF_KEY.
In addition make sure that all SECURITY_KEY values are present in your Section Access table to avoid limiting access to the user who should see all data (*).
in the meantime, make sure the reduce field has all the values available, otherwise, some values will be removed.
For example, let's say you are limiting the data based on SiteID and there are 10 SiteIDs (1, 2, 3, 4, 5, 6, 7, 8, 9, 10). Your section access needs all 10 to be listed.
All rows in SAP data have a non null value for SECURITY_KEY and SAP_KEY
All rows in Customer table have values for SAP_KEY and SF_KEY
All rows in SF_KEY table have values for SF_KEY.
In addition make sure that all SECURITY_KEY values are present in your Section Access table to avoid limiting access to the user who should see all data (*).
