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- Scheduled analysis return cached data

Youssef_B_82

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

Find more posts tagged with

OBIEE

Accepted answers

All comments

[Deleted User]

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

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]

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

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]

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

ok thank you