Symptom
Data is not getting loaded when trying to execute report based on live data connection to Datasphere in SAC. The following error message is being displayed in SAC:
''Unable to authenticate. Please ensure your credentials are valid''
Environment
- SAP Datasphere
- SAP Analytics Cloud
Resolution
- In order to be able to access the story based on live data connection between SAC and Datasphere, it is a requirement to have an active user in both SAC and Datasphere. Currently there is no workaround for this requirement and not possible to have only user existing in SAC within this configuration.
- ''To be able to consume SAP Datasphere data in stories, make sure that you have the DW Consumer role assigned in SAP Datasphere. This role is required for SAP Datasphere data consumption in stories in SAP Analytics Cloud.'' which means there is should be a user created with respective role in Datasphere.
Help guides for this configuration:
Keywords
sac, story, dwc, datasphere, ds, data consumption, live data connection, sap analytics cloud , KBA , DS-SEC , Security (Users, Roles) , Problem
Product
SAP Analytics Cloud 1.0 ; SAP Datasphere 1.0