OBIEE- Scheduled analysis return cached data

Youssef_B_82 · Apr 6, 2020 4:30PM

Hi,

I have an agent scheduled to send email everyday. The data we get by email are not up to date.

When I run the same analysis manually (not scheduled) I get the up to date data.

As a work around, I added a prefix to the analysis

SET VARIABLE DISABLE_CACHE_HIT=1;

The scheduled data are now up-to-date.

I don't understand what changed, and I am looking for an alternative to fix this on a global scale rather than modify every single analysis.

Any idea why this is happening?

I am using OBIEE 11.1.1.7.150120 (Build 150113.1200 64 bit) installed on Linux server.

Thanks

Youssef

[Deleted User] · Apr 6, 2020 4:33PM

If you're confused by cache - why use it in the first place? You can't just turn on cache and it automagically does "things"

Do you have an actual caching strattegy? Why are which objects set to caching enabled in your RPD?

Youssef_B_82 · Apr 7, 2020 10:29AM

Hi Christian,

That's a good question. It was setup like that, probably whoever set the cashing on the RPD was to enhance the performance.

I will try that and update the thread here.

Thank you

[Deleted User] · Apr 7, 2020 11:01AM

Youssef_B_82 wrote:probably whoever set the cashing on the RPD was to enhance the performance.

That's about as correct as making a car go faster by taking a picture of the landscape and pulling it past the window really, really fast.

Youssef_B_82 · Apr 13, 2020 11:43AM

I am not 100% sure how the setup was made or why it was made in certain way.

I will try to disable the cash on the rpd if that is the root cause.

Please note, I am fairly new to OBIEE.

Thanks

[Deleted User] · Apr 13, 2020 2:52PM

Get someone knowledgeable who won't BS you, sugar-coat things or play a political game and get an in-depth review of your system.

Ping me if you require support.

Youssef_B_82 · Apr 13, 2020 6:24PM

ok thank you

MFA for Oracle Community