Question:
Does anyone know of a way or have any suggestions or how to kick off a bex analyzer report in batch mode, attach the workbook to an e-mail, then route it to a list of users automatically. Even if I have to do it using abap - I am just looking for some direction. Thanks We are bw 2.1c
Answer:
Check out the Reporting Agent Feature. One problem we have encountered in doing what you are trying to do is custom filter values on reports run in batch. Assigning them for each user for all desired reports has to be done by the developer at present. Also, depending on the delivery desired, you may actually have to link up exchange/outlook with the SAP Inbox. This would lay the framework for a push environment. You can also set up reports to print to remote location after refresh.
Answer:
I use the background printing function in the Reporting Agent. This does not update excel workbooks however. I get the reporting agent to run and send the results to users as an email. This requires a gateway from BW to exchange and the email comes through as a unformatted text file. Not very pretty reports but it works.
Another option would be to use javascript to retrieve static web templates and email those to users.
Answer:
Customer filter values and variable values can be set using value sets which is part of the reporting agent.. unless there is no predetrmined way of establishing the values..
another way is to actually define a precalculated web template and then then run the ouput as Excel.. with 30B frontend you can have the download scheduler (part of the frontend) extract these files to a specific network location..
Sorry i read the workbooks part later..
Just some more options..
Hope it helps
Satish Chalasani