...

1. Essbase Authentication plugin with SSO mode enabled
2. Use User Impersonation (recommended approach)

Essbase Authentication plugin with SSO mode enabled

...

1. Start the Source system manager (if you want to check if the connection is working you need to login with a cxo user, that also exists in Essbase)
2. Select the Essbase source system
3. Click Connector Properties
4. Under SSO Login, check Impersonate User

The way how Essbase logs activities from "EssLoginAs" functionality is managed by Oracle.

Based on tests performed by CXO, Essbase logs during data retrieval (Mdx queries) the impersonated user.