Scheduling with Prompts

[Former Member]

Post Author: mithungandra

CA Forum: Administration

Hi all,

I want to schedule a report which takes prompts on weekly basis. I am able to schedule the report and it is successful but unable to find where exactly to give the prompt values.

Is it possible by scripts. if so can any one send me the script of tell me how i can do it.

can any one help me.

Regards,

Mithun.G

[Former Member]

Post Author: jsanzone

CA Forum: Administration

Mithun.G:

(this suggestion will only work if you have an attribute in your database that is date/time based) If you are scheduling this to run each week (weekly) and you want to see some type of accumulated data for the period of the last seven days, then you have two choices:

1) after you build your report, remain in the Edit Query mode and click on SQL, then click on custom SQL and modify the WHERE clause to also include a condition for <columnThatIsDateTime> between <today's date -7 days> and <today's date>

2) you can create a filter at the Universe level that does the same as suggestion #1, therefore you can re-use this in your reports instead of customizing every report's SQL.