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.
