Skip to Content
0
Former Member
Jul 01, 2009 at 03:54 AM

Using Broadcaster to run a query for sequential Variable Values

34 Views

Hi SDN Community

I came across a powerpoint slide regarding broadcasting which i hope to use in one of our reports.

We are on SAP BW 35.

Broadcaster has been used

Your opinion would be greatly valued in regards to the direction i should proceed for our particular purpose.

We basically have a report which is a web report. This contains much html and javascript enhancements.

But it essentially has queries with a series of variables.

The customer would like the Queries to be cached for each variable value for performance reasons, on a daily basis.

eg. Run the same query for Variable value BMABRM, then BMASRM, etc...

In a loop fashion.

Do not need to set a process chain to trigger broadcaster, or rather simply to schedule the broadcaster to run daily.

I would basically then want to run this (cache) query in an iterative fashion, ie. rerun it for all the sites.

Can you please make a recommendation to which is the best approach, whether a process chain should be set up, and any experience you may have had setting up a query to rerun for different variable values. We would of course want the query to run successfully before rerunning it for the next variable to avoid locks, etc.

Thank you in advance.

Simon