OBIEE 11g Purge Cache Automatically

Open the OBIEE rpd and create a new Database in Physical Layer

(Right click on Physical Layer - > New Database)

Enter Database Name, Type and check Allow direct database requests by default

And Click OK

Create Connection Pool for the database

(Right Click on Database -> New Object -> Connection Pool)

 Enter Details of the Connection Pool
Enter Name,Call Interface Type and select Datasource Name from the drop down (appropriate ODBC) 

And Save the rpd

Log Into OBIEE Presentation and create a new Analysis to purge OBIEE cache

 Click on create Direct Database Request

 Enter "Database"."Connection Pool Name" and "Call SapurgeAllCache(); " in the SQL Statement box.

 Click on Results. Report results shows that Cache has been Successfully purged.

 And Save the analysis "Cache Purge".Select the report in catalog and click more and click Schedule

 Provide the details of the scheduler to schedule the report to execute. Whenever the scheduler executes the report then cache will be purged automatically.