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

Reproducing the Issue

Cause

Resolution

Now 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 User List and find the user who is the check target.
  3. Click the link in the User ID column.
  4. In the coming User Profile dialog, it will list the teams information which the user has been assigned.

The following method can be also considered by using SAP Analytics Cloud User and Team Provisioning API: GET /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/viewer/298f82da4b184d1fb825b7ffe365e94a/release/en-US/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 , How To

Product

SAP Analytics Cloud 1.0