Monday, August 5, 2013

OBIEE 11g: Query Tuning / Friendly Alternative for CURRENT_DATE

Using in Analysis:
"Date_Column" IN (TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE))
This will return yesterday's date - it is an alternative to CURRENT_DATE - 1.

Using Dashboard Prompt:
SELECT TIMESTAMPADD (SQL_TSI_DAY,-1,CURRENT_DATE) 
FROM "Subject_Area_Name"

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.