Introduction
CXO cockpit support SSO mode for Essbase connections but it works for single Essbase server only. In case of multiple essbase servers used in one application, SSO is possible to only the first essbase server. It should be possible to connect to other Essbase servers using the username of the currently logged on user without requirement to know the password of the currently logged on user.
In this scenario Essbase Server 1 is used for authentication and can also be used for SSO but Essbase server 2 is not used for authentication so the SSO mode is not possible. In this case, Impersonation mode can be used.