Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Enable simple cache in OBIEE 12.2.1.4
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
Answers
-
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
0 -
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.INIfile underDOMAIN_HOME/config/fmwconfig/biconfig/OBISand setENABLE = YES;under the[CACHE]section.You also have to make sure to mark your tables in the RPD as Cacheable.
1
