SQL/OBIEE: Query CURRENT YEAR / QUARTER / MONTH

To query current year, current quarter and current month, run below query:

SELECT
TRUNC(cast(TO_CHAR(SYSDATE,'YYYY') as VARCHAR(20))),
TRUNC(CAST(TO_CHAR(SYSDATE,'Q') AS VARCHAR(20))),
TRUNC(CAST(TO_CHAR(SYSDATE,'MM') AS VARCHAR(20)))
FROM DUAL;

OBIEE 11g Note: This query can also be used in OBIEE RPD in defining Repository Initialization Block (Repository Variable) to use CURRENT_YEAR, CURRENT_QUARTER, CURRENT_MONTH rather than Session variable.

OBIEE 11g: Enable Analysis/Report Performance Improvement

OBIEE 11g analysis has query performance option to "Share query with multiple users" that improves performance after initial run. This option comes handy for reports that are used in the dashboard.

To enable this option, go to: 

1. Analysis' Advanced tab 

2. In the bottom of the page select "Share query with multiple users (may improve performance after initial run)

3. Click "Apply" and save your analysis.

OBIEE 11g: Manually Clearing Cache from Presentation Services

To manually clear ALL Cache from OBIEE Presentation services, go to:
Administration > Issue SQL >
   Call SAPurgeAllCache();

To manually clear Cache by specific Database, from the same path (Administration > Issue SQL)   

   Call SAPurgeCacheByDatabase('DB Name');
   ('DB Name' can be obtained from RPD's Physical Layer)