Oracle Analytics Cloud and Server Idea Lab

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

OAC Auto Cache Purge

Needs Votes
278
Views
15
Comments
2»

Comments

  • Manu R-Oracle
    Manu R-Oracle Rank 4 - Community Specialist

    @Michal Zima Purging the server cache is very basic requirement in analytics world. Incremental data gets loaded everyday once at least. Hence the global server cache should be purged for fresh data to be reflected across. The case you are referring might be a specific one for a few reports, this is more of generic requirement at Enterprise level.

    Please share if you have any specific solution for this else will be taken by the product team based on priority.

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    @Manu R-Oracle I have a feeling, that you don't understand what I have written (not even how BI Server cache works) , so further discussion seems useless . Have a good day.

  • Manu R-Oracle
    Manu R-Oracle Rank 4 - Community Specialist

    @Michal Zima Please DM if clarification needed to understand the requirement. Any valuable contribution/solution will be appreciated Thanks. Have a great day ahead.

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Innocent questions,

    @Bret Grinslade - Oracle Analytics-Oracle and/or @RajeshPolavarapu-Oracle ,

    1) where does the documented solution run? is it on an on-premise server?

    2) if so, do i need to install any pre-requisites on that server? e.g. oracle client, oracle analytics client tools, etc?

  • Chad Williams
    Chad Williams Rank 5 - Community Champion

    I know this is over a year late, but I want to put in word of support for Manu. We are currently facing the same issue.

    This method used to work for us in in OBIEE versions and earlier. Not sure if it ever worked in OAS versions or not to be honest.

    Clear OAC cache automatically. One of the requirements that customers… | by Eloi Lopes | Medium

    We are experiencing issues where users are frustrated because results they are pulling are stale, and they need to take extra steps to ensure that their results.

    Michael, I think you and Manu were talking about different things, and simply are not connecting to see what each other are talking about. Since we have a pretty customer area that we need to address, we may look to set properties for caching in the RPD, but… we'd still like to be able to do something similar to what we did before. We don't any user getting stuck with days old data because the data was cached for some reason. Normally, we have to run the cache command, clear the cursors, and log out and back in to get the right results. This is not ideal.

    Would love to hear if anyone found a workaround to this before I start looking at the JDBC/cron method described above.

    Regards,

    Chad Williams