Important:SAP BO BI 4.1 sp6: mass generation/schedule of 6000 reports

[Former Member]

SAP BO 4.1 Sp6

Hi All,

I have a single report. The report has 2 input parameters:
1) date: which would always be "yesterday"
2) group: this would change for each report output, there are about 6000 different group values.

-name of each report generated would be unique: group_datetime. example: group1_datetime....group6000_datetime

-i have to have this scheduled every night and it will go to a single/same windows folder via file system option. we are looking at close to 6000 report outputs.

-there is only one server with 64GB RAM with SAP BO BI 4.1 sp6

What is the best way to accomplish this? publication or individual schedules?

* If i do individual schedules, i have to do 6000 schedules on the same report. So the report would run 6000 times for different input group values (as there are 6000 of them) and I have to stack the schedules over 3-4 hours

* Would publication be a more efficient way to do this? How does publication process run the report - would it try to run the report in one go for 6000 different input values and then split the output and distribute? in that case, i suspect it would just fail since we are looking at a huge query.
So I am not clear on this part with regards to using publication for these many number of outputs.

Please advise. Any quick input appreciated if you have dealt with a similar requirement.

[Former Member]

Hi RK RK,

Publication is the best option for your scenario.

I had just one question. How much time report takes if run the report for all the Groups at one time?

If it takes small amount of time you can run the report at one time ans distribute the same with publication.

Let me know if any further query.

Regards,

Abhijit

[Former Member]

the 6000 reports are broken into 12 different groups. so about 500 per group. would this be feasible if i create a seperate publication job for each group and schedule each publication at different times? (in order to reduce processing load). so each publication job would need to generate about 500 outputs during its schedule (instead of 6000). thoughts?

[Former Member]

Hello Dennis,

The reports would be in pdf format. Each report is about 200 KB/0.2 MB, so not too big but it does take about 90seconds to complete execution and return data.

The reports go out to various groups for a county wide distribution.

Is there a known limit on what publication can handle in terms of the output? Does it try to generate all the 6000 outputs at the same time or is it queued and generated?

[denis_konovalov]

What is the business reason to generate 6000 reports every night ?
What format are you exporting reports in ?
How big is each report on the disk ?

Publication is probably a way to go, but I doubt your server will be able to handle this.