OBIEE 11g: Direct Query from Database, bypassed Cache

To make sure the Oracle Business Intelligence Enterprise Edition (OBIEE) report / analysis' query pulls data directly from the database and not from Presentation or Server cache, follow these steps:

1. After selecting appropriate columns in Criteria tab

2. Click on Advanced tab

3. On Prefix section, enter: SET VARIABLE DISABLE_CACHE_HIT=1;

4. Click on Results tab.

5. Keep in mind that it might take little longer than usual, since the report will have to pull fresh data.

Hope this helped & feedback is always welcomed!