How to bypass OBIEE server cache

Post date: 18-Jan-2010 13:12:04

How to bypass server cache for a specific report on Dashboard or Dashboard Prompts

We have requirement for a specific report not hitting cache and data in the report should come directly from database tables.

Use the following syntax for the query

SET VARIABLE DISABLE_CACHE_HIT=1;SELECT "Paint"."Year" FROM Paint order by "Paint"."Year" ASC

SET VARIABLE syntax can be directly coded into Dashboard prompt as SQL.

For a specific report it can be included in the Advanced section under Prefix.