Skip to Content
0
Former Member
Nov 02, 2011 at 07:59 PM

Defining "prior-week" timeframe dynamically for scheduled reports

30 Views

I have a number of reports that I need to execute each week. But, the scheduling options don't allow me to kick off the report on a Sunday AND constrain the timeframe to the prior week (Sunday-Saturday). I have a prompt built into the original query, but that's useless if I want to automate the output.

I was successful getting the query to work against the upstream database using the following query fragment:

BETWEEN CURRENT_DATE - INTERVAL '7 day' AND CURRENT_DATE - INTERVAL '1 day'

But, there is no option to enter this query into the BI.Ondemand UI.

Any insight would be helpful. This issue is hindering progress with our metrics automation plans.

Regards,

-Joe