Auto Refresh Problem

[dbomrrsm]

We are using Broadcast Agent to schedule refresh of a number of reports each morning after a batch load completes.

We have set it up using filewatcher where the batch load of data, once complete, writes a file to a location and Broadcast Agent picks up the fact that the file exists and starts the refresh.

So far so good.

A number of the reports take input parameters such as date ranges and things such as department. All of the parameters other than dates need to be set to ALL before the refresh and the date ranges required each morning move each day.

Is there any way of populating these parameters (usually input by users when running the reports) before the daily refresh without rewriting all of the reports.

Any help gratefully received.

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[sh4kil]

In BCA you should be able to provide default values for prompts.

As for the dates you should change the reports to make them dynamic, i.e. sysdate, sysdate + 1, etc

 

[skrandel]

Take a look at

http://f1.pg.briefcase.yahoo.com/bc/skrandel@sbcglobal.net/lst?.dir=/Business+Objects&.view=l.

You'll see some presentation material from the 2003 BO conference that has some dynamic calendar examples.

Steve Krandel
Symantec

 

[dbomrrsm]

Steve

Tried the link you gave above but with no luck.

Could you repost please as this seems very interesting.

TIA.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

This should work

http://f1.pg.briefcase.yahoo.com/bc/skrandel@sbcglobal.net/lst?.dir=/Business+Objects&.view=l

Steve Krandel
Symantec

 

[skrandel]

http://f1.pg.briefcase.yahoo.com/bc/skrandel@sbcglobal.net/lst?.dir=/Business+Objects&.view=l

Steve Krandel
Symantec

 

[skrandel]

It's a bug with this board. Copy the text starting with the HTTP part and it works fine.

Steve Krandel
Symantec

 

[dbomrrsm]

Steve

Thanks very much - link worked - will take a look at the 2003 material.

Thanks again.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]