SAP Knowledge Base Article - Public

2910928 - How to know the teams list which a user is belonging to in SAP Analytics Cloud (SAC)

Symptom

How to know the teams list which a user is belonging to in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2023.21

Resolution

In SAP Analytics Cloud the information can be confirmed as the following steps:

  1. Log on to SAP Analytics Cloud tenant with the user who has BI Admin or Admin roles.
  2. Go to Security -> Users List and find the user who is the check target.
  3. Select the user and click Edit icon to open the Edit user dialog
  4. No need to change anything, just click Next Step twice to go to Tab Team Assignment.
  5. In the right side of the dialog, the currently assigned team information is listed.

The following method can be also considered by using SAP Analytics Cloud User and Team Provisioning APIGET /api/v1/scim/Users/<USER ID> API to fetch the user information.

In the result json, groups section will list the teams which this user is belonging to. For more details about this API, please check online document: 
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/92be826c07414b23b9c93ab988a63f60.html

Below is a simple sample which is using Postman to consuming this API to get the data:

  1. Log on to SAP Analytics Cloud with BI Admin role user.
  2. Go to System -> Administration -> App Integration.
  3. Add a new OAuth client, set the Purpose as API Access and Access as User Provisioning.
  4. Specify value for OAuth Name, OAuth Client ID and Secret. Save the setting.
  5. Now start Postman, run a POST request to:
    URL: <Token URL which is in App Integration page>?grant_type=client_credentials
    Authorization: Basic Auth; Username: OAuth Client ID value; Password: Secret value
    HEADERS: x-sap-sac-custom-auth:true; Content-Type:application/json
  6. In the returned json result, copy the value from access_token.
  7. Run a GET request to:
    URL: <TENANT FQDN>/api/v1/scim/Users/<USER ID>
    Authorization: Bearer Token; Token: access_token value which is get in step 6.
    HEADERS: x-sap-sac-custom-auth:true; Content-Type:application/json; x-csrf-token:fetch
  8. Confirm the groups section in the returned json result.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-ADM , SAC Administration , LOD-ANA-LS , Licensing and Full User Equivalent , How To

Product

SAP Analytics Cloud 1.0