0 Replies Latest reply on May 13, 2019 11:07 AM by 3997513

    Cache sharing for dedicated users in OBIEE 12c

    3997513

      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.

       

      Regards, Luke