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

Guidelines for Cache

User123456usa

Hello Expert,

We have been facing some issues with our Analytics. We have been observing some difference in Numbers while running dashboards after ETL refresh. It is not consistent for same Users running different time. We have got feedback from Technical support team that it is because of Cache. I just went through article and could see we have defined row level security as per Oracle guidelines. So wondering what are standard practice for cache?

Do we need to clear cache after every database refresh? and why? are there are standard documentation or check list for cache configuration which we can refer?

I have gone through document - Work With Row-Level Security. Thank you so much in advance.

Thank you

Find more posts tagged with

Accepted answers

Steve F-2

Hi Mangesh @User123456usa ,

You can review the following:

How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using JDBC [Video Content] KB59916

Additionally, an Ideas Lab request (enhancement) can be up-voted and commented on

https://community.oracle.com/products/oracleanalytics/discussion/20955/oac-auto-cache-purge/p1

All comments

BrandonH

As part of your final ETL steps you should consider clearing the cache. Eg: SAPurgeAllCache

There are some articles you can read that have details on the topic, eg

https://www.rittmanmead.com/blog/2015/09/obiee-bi-server-cache-management-strategies/

In the above Robin shows an example of adding the clear cache to the ODI ETL.

User123456usa

Thank you for response. I was hoping there is better cache management in OACS compare to OBIEE. If we clear cache every time after ETL, may impact on performance. So seems to be there is no way getting accurate data with speed. Thank you again.

BrandonH

The tools you need to address both concerns are at your fingertips.

The data consistency with clearing the cache, and the performance with seeding it.

Steve F-2