Oracle Transactional Business Intelligence
Setting relative dates in a filter for an OTBI Analysis
In an OTBI Analysis is there a way to add into a relative date range into a filter?
I need an Analysis with a filter to pick up dates within the last week. I don't see a way to do this in the normal filter properties and I'm getting errors when i add the below code into "Convert this filter to SQL" Is there a way to do this either with the regular filter or with the Advanced SQL filter?
BETWEEN (SYSDATE - 7) AND SYSDATE