Oracle Transactional Business Intelligence

Products Banner

Setting relative dates in a filter for an OTBI Analysis

Received Response
1371
Views
17
Comments

Summary

In an OTBI Analysis is there a way to add into a relative date range into a filter?

Content

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

Answers