Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using SYSDATE in a condition for scheduled report

ErikZAug 29 2012 — edited Oct 26 2012

Every Monday I have to run a report. The 3 tabs take about 30 minutes to run. So I am trying to set it up as a scheduled report, but don't want to have to modify it every week. So I thought I would do a condtion using SYSDATE. I have used it before but not this way. I tried using TRANSACTION DATE BETWEEN "SYSDATE-7" & "SYSDATE-1" to run every Sunday AM for the previous Sunday (-7 part) to Saturday (-1 part). Then I tried using TRUNC(TRANSACTION DATE) BETWEEN TRUNC(SYSDATE-7) & TRUNC(SYSDATE-1). In plus (OracleBI Discoverer 10g (10.1.2.1)), it says no data. In Desktop, it says Query has changed. What am I missing?

Thanks.

Erik

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2012

Added on Aug 29 2012

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

8 comments

1,672 views