How to schedule queries to run together or one after another

[Former Member]

I have to run the same query with different variables to create 400 different financial reports. Each is a small one page report. How can I schedule them to run one after another? We don't have a set date yet to run them. Is it possible to schedule one query, and have that trigger the remaining queries?

Thank you for any suggestions.

[Former Member]

Thank you for your response. But in Broadcaster, you can't schedule queries to trigger another query, I will have to execute all 400 reports. I was hoping there was a job script that might do this in BI as can be done in ECC.

Thanks.

[Former Member]

Hi,

sounds like you need to create different variants for each report and schedule the query using the broadcaster.

Siggi