3409462 - When trying to edit one connection shared by another user without credential shared, new user credential cannot be saved in SAP Analytics Cloud (SAC)

• When trying to edit one connection shared by another user without credential shared, new user credential cannot be changed/saved in SAP Analytics Cloud (SAC)
• The change could only be saved when being prompted to enter credential in order to use the connection to create model/query

• SAP Analytics Cloud, Enterprise Edition 2023.21.8

1. Log on to SAC tenant with user A.
2. Create one Import Data connection which supports sharing, like Import Data Connection to SAP S/4HANA.
3. Enter Credential of user conn-1 but DO NOT check option 'Share these credentials when sharing this connection'.
4. Share this connection to another user B.
5. Log out and then log on with user B.
6. Edit the connection shared by user A.
7. Enter credential of user conn-2 and then click OK.
   => It shows 'Connection successfully changed' .
8. Try to create model based on this connection.
    => It still prompts to enter credential in order to use the connection.
    => It seems that the change done in step 7 is not saved.
9. Enter credential of conn-2 again. 
     => It works fine to connect to the data source.
     => After that, no need to enter credential again to use this connection even starting a new session to SAC tenant.
10. Repeat step 6-7 to enter credential of user conn-3 and then click OK.
      => It shows 'Connection successfully changed'.
      => However, if trying to open the connection dialog again, conn-2 appears in User field.
11. Try to create model based on this connection.
      => User conn-2 will be still used to connect to data source.
      => For User B, it is impossible to change connection user (from conn-2 to conn-3) again.

• This is by design when the user B has Connection Manage role and tries to modify a connection that belongs to another user at Connection page.  The user is updating the credential on-behalf of connection owner introduced in 2022 QRC1.
• Instead, the user B could input his own credential in prompt dialog when trying to use the connection to create a model at the first time (as step 8-9 above).

Workaround to update credential of a shared connection: 

1. Find the role assigned to the user B.
2. Temporary remove Connection Manage permission.
   => The user B would be able to update own credential of a shared connection at Connection page.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

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, Share, connection, credential, user, edit, change, save , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem