Skip to Content
0
Jun 11, 2018 at 06:40 PM

What ERP TCodes/Authorizations are required to access Query data from SAP Cloud Analytics?

112 Views

I am trying to create a role for users to import data in to SAP Cloud Analytics using SAP ERP as a datasource however I am having an issue when connecting, which appears to be security related. From the menu I select Create --> Model and then Use a datasource, choosing SAP ERP. I select my connection name and the option "Create a new query", then click OK. My connection seems to be OK but when I try to expand Global or Local under Select Data, I get an error "An error occurred in Connection Server service: Unexpected exception occurred". I can connect to other systems with no issue but I noticed that I have SAP_ALL and SAP_NEW in my profile. In this particular system I do not. I was instructed to give full authorization access to SQ02, which I have done so. I am assuming there is some additional security on the ERP side that I need to complete.