nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Cache Not Working

user2053645

In Oracle Enterprise manager, we have "Enable cache" unchecked. We don't want the data to cache. However, when running

reports in OBIEE, it's clear that the cache is being used. The data results are not correct. As soon as we manually clear the

cache, the results are correct.

We want global caching turned off.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Which exact version?

Are you sure that the server has been bounced after setting cache as disabled?

Syedsalmancs110

If BI Server cache has been disable in your environment and still reports are hitting cache then did you check if cache is still getting seeded when a non cached report is run?

After disabling cache did you purge already seeded cache, because I am not sure but I dont think by just disabling cache it also ensures CACHE HIT for previously generated cache is disabled, may be I am wrong.

Yeah also do check if cache disbaling changes through EM is reflected in NQSConfig.INI under [CACHE] section.

DO NOT CHANGE NQSConfig.INI FILE DIRECTLY JUST BECAUSE I MENTIONED IT HERE.

Here is a blog(Under Section Application Level) which talks about naviagtion to disable BI Server Cache through EM:

Oracle Business Intelligence: Enable / Disable Cache in OBIEE 11g

user2053645

Hi All - I took the steps of turning cache on and off again (and restarting services) in EM this morning and it now appears that

all is behaving as intended at the report level. Thank you.

We've had caching turned off (at least as evidenced in EM and I verified in the nqslog) for a long time.

What would make caching at the report level show up anyways despite having caching globally turned off? My concern

is that it's a ticking time bomb that needs constant babysitting.

Gianni Ceresa

If cache is off it is off, you can even set in the RPD the no cache info on each physical source object to make it even more "no".

But you will anyway still have a browser / front-end caching.

Cache off doesn't mean the analysis is executed again every time you refresh the page (in the same session), that's the front-end cache which is always there to not run queries for nothing.

Also another thing: if cache is hit you see it in the logs, so keep an eye on logs to see if you have a cache hit info coming to confirm your cache is off.

You never posted the version of OBIEE you are talking about, but I don't remember any with cache being on even when set to off...

Chris Arnold

As mentioned above, it sounds like you are bypassing the cache to the tables in the RPD & in EM -- which I believe means it will not use the BI SERVER cache -- but your reports are still using the Presentation Server cache.

To bypass that here is what I do:

To bypass cache in a single report

----------------------------------

1)Go to Advanced tab of Report

2)Go to Advance SQL section

3)Check the 'Bypass Oracle BI Presentation Services Cache' check box

4)Go to Prefix Section

5)Write the below command:

SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

*make sure before saving click Apply SQL Query Button in the bottom

6)Save the report

Hopefully this helps.

user2053645

Ok. The issue is probably the Presentation server cache. Will try last suggestion. Thanks all!

user2053645

I'll keep all posted. I've also implemented the suggestion to disable presentation services caching.

Here's why I'm doing this. We're incorporating VPD (virtual private database) whereby depending upon who

runs a given query, a different set of data will show up. We need the query to hit the database each time so

that users do not see data they are not supposed to see. In some of our testing, when I did not go back to the

database, I was seeing info that I was not supposed to.

user2053645

Here is what was throwing me - when you search the web for turning off the cache in obiee, several places basically say in order

to do this at the application level, do it in Enterprise Manager. Isn't BI Presentation Services considered part of the application?

I thought so. So didn't realize that I also need to deal with the Presentation Services cache at the report level. Upon further

research, I'm seeing this suggestion. I won't be able to fully test until next week. If all goes well, I'll mark the last suggestion

showing the Advanced tab in a report as the correct answer. Really appreciate EVERYONE's help!

Gianni Ceresa

First thing you still didn't say what version of OBIEE you are talking about, so you make it quite hard to give you useful answers! ( )

The presentation cache is personal, it isn't shared, so it can't be an issue. If it would be shared almost 90% of the OBIEE setup wouldn't work because it would destroy any security setup.

As apparently you are setting up VPD you maybe want to finish the full config of VPD before to test to get a real view of what happen, because what you described sounds a bit weird and honestly never saw that if not with a missing or wrong cache management strategy.

But again: it also depends on what version you use as between OBIEE 10g, 11g and 12c there are like 10 years of multiple different versions ...

user2053645

It is version 11.1.1.7.

If the user hits the same report, you sure the presentation server cache not shared? When I cleared all cursors manually, the problem went away.

VPD itself is working. If I manually clear all cursors, a person who was not seeing the correct data on the page now does see the correct information.

We are going to test further today. Here is what has been done on caching:

-Turned off in EM

-Cachable property turned off on every physical table in the Physical layer of RPD. My understanding is that this is not necessary if we took the EM step, but

leaving in place for now.

-On every report on the dashboard, on Advanced tab, checked option to bypass presentation services and added the script suggested above to the prefix

In our testing, it does appear that if users run the same report (and the bypass presentation services option not checked on the report), the presentation services

cache is shared. Also, in the rpd, we're not processing against the database with individual database accounts or using the :USER variable. We're using a service

account and added a script to pass the Active directory id of the person who logged in back to the database.