BCA Scheduling for a report with prompts

If I schedule a report, which has prompts, to be refreshed and printed everyday, using BroadCast Agent, how will it work out with prompts?

Chandru


tendulkar :india: (BOB member since 2004-03-15)

You will be prompted during the schedule process. Each response you make during the schedule process will be used during the BCA run. So if you have a prompt for Department, and you enter “A” during the schedule process, then department “A” will always be used.


Dave Rathbun :us: (BOB member since 2002-06-06)

You will be asked to provide the prompt values as you schedule the report.
If you have date prompts in your scheduled report it will run for the dates you provided at the time of scheduling.


Andreas :de: (BOB member since 2002-06-20)

In reports that are used on the BCA as well as interactively we create predefined conditions in the universe in this format (Oracle :smiley: ):

Trunc(order.deliverydate) = Decode(@Prompt('Delivery date (ddmmjjjj) or 0 for systemdate','A',,mono,free), '0', Trunc(SysDate), Trunc(TO_DATE(@Prompt('Delivery date (ddmmjjjj) or 0 for systemdate','A',,mono,free))))

It asks you to specify a date but for use with the BCA the 0 option is the one to choose. The decode then sorts out what you want and passes the right date to the condition.
This saves on maintenance (otherwise one interactive report and a second one for the BCA) and very often users also use the 0 option because thats what they usually want :wink: .

HenkK


HenkK :netherlands: (BOB member since 2004-03-02)

Thanks Dave, Andreas & Henk !! Henk … that was a good idea. Thanks.

Cheers
Chandru


tendulkar :india: (BOB member since 2004-03-15)

Hey tendulkar, I had the same problem last week just run the report with
prompts & then schedule it on BCA to refreash & print ,It will not prompt U again , It will work fine the only problem is if you change filter prompts in Universe then all the prompts in BCA fail , untill you are not doing that U can refreash & print reports in BCA perodically without any issues


rockstart (BOB member since 2004-05-14)