Hi,
Here is the scenario:
I need to run few (nine) BW reports daily (actually, first 10 days of every month) and make it available for the users. Each report runs multiple times (for different entities). The reports need to be formatted nicely (not an excel download). The goal is, every morning any user will be able to get his/her data in nicely formatted way (with company logo, pdf etc.) so that they can just print their report and run into a meeting (if requires). They also need not run the reports, they can just open reports already run and get their data.
So we created COGNOS reports on top of BW. You have to enter parameters in those reports (which is a real pain, because every time you go back to the parameter screen you have to enter every single parameter) and schedule them overnight. In the morning all outputs will be available in a network folder.
Users adore the outputs. But I would like to get rid of this process, now that I am going to implement NW2004s.
So, my question is: how I can replace COGNOS tool by using NW2004s features without hurting my user base. The requirements are: a) outputs need to be formatted pdf (with logo, page number etc.); b) reports should be scheduled; c) outputs can be accessed from a common location d) not all outputs will be available to every user i.e. selective access of outputs.
I will wait for valuable suggestions from experts.
Regards,
SN