3569578 - Not all tables are available for new C4C connection in SAC

Results are displayed incorrectly displayed when setting up a new connection between SAP Cloud for Customer and SAP Analytics Cloud.

 

• SAP Cloud for Customer
• SAP Analytics Cloud

1. Open your SAP Analytics Cloud Tenant
2. Go to Modeler
3. Create New "Model"
4. Select "Start With Data"
5. Select SAP Cloud for Customer or SAP Cloud for Customer Analytics data source
6. Create New Connection
7. Add details and use Authentication Type "Basic Authentication"
8. Click Create
9. Select "Create a new query" and Click Next

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. 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. 

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 Analytics Cloud all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions