OBIEE 11g Cache Clean

To delete the cache of OBIEE:


We can delete the cache through OBIEE analytics page. Login as administrator user and navigate to Administration - > Issue SQL.
Then type as below.

1. Deletes all cache info :   Call SAPurgeAllCache() ;

2. Deletes specific table cache :  Call SAPurgeCacheByTable( ‘Datwarehouse’,  ”,’DWH’, ‘XW_SALES_F’);

3. Deletes all cache related to a specific database :  Call SAPurgeCacheByDatabase( ‘Datwarehouse’ );

4. Deletes specific logical SQL Cache : Call SAPurgeCacheByQuery(‘SELECT   0 s_0,    “Sales Subject Area”.”Time – Dimension”.”MONTH_NAME” s_1, “Sales Subject Area”.”Fact Sales”.”COST_PRICE” s_2 FROM “Sales Subject Area” ORDER BY 1, 2 ASC NULLS LAST ; ‘)