...

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

Essbase logs in case of impersonation

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

Based on tests performed by CXO, Essbase logs the impersonated user, and not the service account when we retrieve data (Mdx queries).
Below is an example from Essbase log when "EssLoginAs" functionality is used. In the use case below the Impersonated username is Julien.

[Mon Jun 14 07:11:10 2021]Local/ASOsamp///2052/Info(1042059)
Connected from [::ffff:172.31.35.177]

[Mon Jun 14 07:11:10 2021]Local/ASOsamp/Sample/Julien@Native Directory/2052/Info(1013091)
Received Command [MdxReport] from user [Julien@Native Directory]

[Mon Jun 14 07:11:10 2021]Local/ASOsamp/Sample/Julien@Native Directory/2052/Info(1260039)
MaxL DML Execution Elapsed Time : [0.031] seconds

[Mon Jun 14 07:11:10 2021]Local/ASOsamp///2280/Info(1042059)
Connected from [::ffff:172.31.35.177]

[Mon Jun 14 07:11:10 2021]Local/ASOsamp/Sample/Julien@Native Directory/2280/Info(1013091)
Received Command [MdxReport] from user [Julien@Native Directory]

[Mon Jun 14 07:11:10 2021]Local/ASOsamp/Sample/Julien@Native Directory/2280/Info(1260039)
MaxL DML Execution Elapsed Time : [0] seconds