Function to run scheduled report for past 7 days?

[gshadz37]

Hi,

Is there a function, or a way to create one that I can use in a scheduled report (webi, xir2) to look at data for the past 7 days?

Any help is greatly appreciated.

 

[ainkca]

You could try creating a condition in your Universe, and then applying the condition in your query.

As an example, I have an object in my universe that looks like this:
PATIENT.ADMIT_DT >= trunc(sysdate - 7) and PATIENT.ADMIT_DT < trunc (sysdate +1)

You may have to play with your date formatting, if your database stores the date differently that this one (Oracle).

It may be as simple as yourdate >= date - 7 and yourdate < date

Hope this helps?

 

[gshadz37]

There in lies the problem - I don't have access to the universe other than to create webi docs from them. Sorry I didn't mention that originally. Is there a way to code it into a prompt?

 

[skrandel]

Nope. Nothing you can do at the report level to do this. You need a universe object.

Steve Krandel
Symantec