Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Guidelines for Cache

Accepted answer
51
Views
4
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • 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

Answers

  • Rank 5 - Community Champion

    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.

  • Rank 2 - Community Beginner

    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.

  • Rank 5 - Community Champion

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.