Dynamic report generation

[Former Member]

We are migrating our client reports from crystal reports to business object reports and I need your help on how to achieve the below functionality in Business object reports.

Requirements

1. We need to generate and deliver around 30,000 statements to clients (mostly ftp and email) from 300 Webi report templates.

2. This has to be a complete automated process with no user intervention.

For example: Using Webi / Deski Report1, we need to run the report for each client account and then generate a statement and deliver it to client (only client specific data). Web1 reports are complex and some might take 30 to 60mins for generation.

Questions

1) Can it be done by just using BO tools with out coding ( using any .net sdk)?

2) Can a single BO server handle the load, If not How to load balance reports generation and delivery across multiple servers?

3) How to dynamically pass parameters to Webi report without coding?

Thanks for reading my post. Any help/ suggestion is appreciated.

[denis_konovalov]

1. You can still use CR reports with BO Entrprise and don't have to migrate reports.

2. It can be done using Webi reports and Publications

3. For Load/Sizing - you'll need to contact SAP Consulting and get proper review done.

Single server might be possible, but most likely you'll need more.

4. For report desing techniques - please review user guides on help.sap.com

[Former Member]

Thanks for your response. Please excuse me for multiple questions

1. What are the pros and cons of using CR reports with BO enterprise . Is BO enterprise you are referring is connecting to universe instead of a database?

2. We are new to publications; can you please let me where to find examples /documentation?

[denis_konovalov]

1. There are no pros and cons, BO Enterorise is a framework what supports reporting using either Crystal reports, Web Intelligence or Deskrop Intelligence. Webi and Deski use Universes as semantic layer, while CR can connect directly to DB or also use Universe or Business Views as semantic layer

2. Please go to help.sap.com and review all available Business Objects documentation. Admin guide and User guides for Webi and Publications will help you decide on best aproach.

[Former Member]

In our current architecture,

1) We use crystal report templates and pass dynamic datasets at runtime to generate multiple client statements.

2) For load balancing, we have 6 app servers with crystal runtime installed and we distribute load across the servers using custom code.

My question is if use BO enterprise will there be any performance enhancements?

[denis_konovalov]

Probably not. Your architecture looks very streamlined, BOE will add additional overhead , at least by default.

It's hard to say for sure. proper tuning and sizing has to be done. SAP Consulting is the best way to get this reviewed and sized.