I need to use dedicated usernames in OBIEE connection pool (no single technical user can be used as per requirement). At the same time, I have enabled BI Server cache and would like to share cache entries between users (in case somebody runs a specific query in the morning and there's another person that runs same/similar query later, the results from previous query would be used). Underlying database is non-Oracle database.
Shared logon option does not help here since in connection pool properties, username and password are specified as values taken from nqsession.
Therefore the question is if it's possible to use dedicated usernames and still share BI Server cache between them (even if it requires some workaround)?
This is in context of OBIEE 12c.