Automation of BI server and BI Presentation server cache in OBIEE 11g

Question

Hi Experts ,

My current OBIEE 11.1.1.7 environment is a cluster, it has 4 node cluster . I want to clear the BI server cache and Presentation server (Close All Cursors ) cache  every 12 hrs .Actually total no of users are around 250 users per day, This is the average users are using BI system every day . Some times users are complaining that still they are seeing stale data, instead of real-time data .So i want to automate the cache script that ensure it clear all BI server which means RPD and BI Presentation server which is Close All Cursors in Analytic page .

Please suggest that how can i do this .If i want to achieve what all i need to do . Please advice .

Thanks for your help in advance .

rmoff · Answer

SAPurgeAllCache clears the BI Server cache only.

2844292 · Answer

Thank you for your suggestions ...

Still am having some doubts .. if i have a automate cache script which is CALL SAPURGEALLCACHE() . If i schedule this batch script file will it be automatically clear Close All Cursors in BI presentation server ??

Once this CALL SAPURGEALLCACHE() procedure schedule automatically will it take care clearing Presentation and Server cache ?? Please clarify.

Thank  your support

rmoff · Answer

Why not purge your cache when the data changes, rather than some spurious schedule?

Have a read of this: OBIEE BI Server Cache Management Strategies - Rittman Mead Consulting