Symptom
Results are displayed incorrectly displayed when setting up a new connection between SAP Cloud for Customer and SAP Analytics Cloud.
Environment
- SAP Cloud for Customer
- SAP Analytics Cloud
Reproducing the Issue
- Open your SAP Analytics Cloud Tenant
- Go to Modeler
- Create New "Model"
- Select "Start With Data"
- Select SAP Cloud for Customer or SAP Cloud for Customer Analytics data source
- Create New Connection
- Add details and use Authentication Type "Basic Authentication"
- Click Create
- Select "Create a new query" and Click Next
Cause
- The oData query in SAC returns the same data that's returned when executed in the browser. If it doesn't work in browser, it won't work in SAC.
- As per the SAC documentation (https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/7dba0c7838af4e428a88217eaa8994f4.html#procedure), SAC have recommended the report-based oData connection, /sap/byd/odata/cc_home_analytics.svc.
- If you read the C4C documentation (https://help.sap.com/docs/SAP_CLOUD_FOR_CUSTOMER/66e9a9081a7b40e38c8604d6617d0311/extract-report-data-using-odata-ddb9bc5e63ad4333b455f9a906dcd4cf?locale=en-US&state=PRODUCTION&version=CLOUD#conventions-for-building-odata-services-for-the-sap-solution), you should note that this URL only works for Business Users and not Technical Users.
- Additionally, this access is based on the reports available to the specific user and so you need to consider the Business Role assigned to the user.
- Please also review 2602051 - Users Cannot Access Reports via ODATA (https://me.sap.com/notes/2602051) for more information on how to ensure full access. I have double checked internally and ana_businessanalytics_analytics.svc is working for this connection also.
- In summary, the issue is that you are not using the a Business User credential with full access and therefore the results are incomplete.
Resolution
Please rebuild the connection with either https://myxxxxxx.crm.ondemand.com/sap/byd/odata/cc_home_analytics.svc or https://myxxxxxx.crm.ondemand.com/sap/byd/odata/ana_businessanalytics_analytics.svc and enter the credentials of a Administrative Business User that has the necessary report assignments.
Keywords
SAC, ANA, Import, Connection, Modeler, table, report, datasources , KBA , AP-RC-ANA-SAC , C4C, ByD: SAC Integration , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
SAP Knowledge Base Article - Public