Enable simple cache in OBIEE 12.2.1.4

DENISKA80

Hi there

How to enable Presentation Services cache?

We located section ServiceInstance and included following elements into in

  <Cache>
    <Query>
      <MaxEntries>100</MaxEntries>
      <MaxExpireMinutes>60</MaxExpireMinutes>
      <MinExpireMinutes>10</MinExpireMinutes>
      <MinUserExpireMinutes>10</MinUserExpireMinutes>
    </Query>
  </Cache>

restarted Bi but nothing changed.

The behaviour of "cache" remaned unchanged.

If I execute same analysys under one user several times I get one query request to Oracle DB. But when I change user and execute this analysys Bi send request to DB one more time.

Is there any way to prevent it?

Same analysys under different users with one request to DB within a certain period of time

Christian Berg-0racle

Classic answer: "it depends".

What you're showing is an excerpt of the instanceconfig.xml and pertains to Presentation Server cache.

What you're asking about is BI server cache which is a different component of the architecture. So the question becomes: Is caching at all enabled in your environment on the level of the BI server?

https://support.oracle.com/epmos/faces/DocContentDisplay?id=1352462.1

Federico Venturin

Hi @DENISKA80 ,

As @Christian Berg-0racle already pointed out you have to enable the BI Server cache to achieve your goal.

You have to edit the NQSConfig.INI file under DOMAIN_HOME/config/fmwconfig/biconfig/OBIS and set ENABLE = YES; under the [CACHE] section.

You also have to make sure to mark your tables in the RPD as Cacheable.