scheduling the Web Intelligence report to Email
Here is the document which gives the step by step procedure to schedule the BO Report to specified Email address.
Some of the information users wanted to have the BO WEBI Report output in excel formats in their Email inbox for further analysis the below step by step procedure is very useful to Schedule WEBI report .xls format to EMAIL.
For scheduling the Web Intelligence report to Email:
1 Configuration on Adaptive Job Server (One time activity in CMC)
1.1. Log on to CMC.
1.2. Go to Servers -> Web Intelligence Services -> Adaptive Job Server
1.3. Right click on it and select Destination
1.4. From the Drop Down box, Add Email as destination, mention the domain name, Host, port of the EMAIL server. Give the admin EMAIL address to send the mails.
1.5. Optional Step: Specify the common message; check the delivery document as attachment. Select User specific name (title/owner/ ID/EMAIL address) using place holder (Eg:%SI_NAME%.xls) as per the requirement and add .XLS/.TXT.
1.6. Uncheck the option “Add file extension”.
1.7. Save and Close the Application, Restart the adaptive job server.
- 2. Schedule Web Intelligence Report ( One time schedule activity)
2.1. Log-in to BI Launch Pad
2.2. Go report which you want to schedule. Right click on it and Click on Schedule.
2.3. Select the format as “Microsoft Excel” in Format section.
2.4. Now in Destinations option, select the EMAIL destination, give admin user mail id in FROM and give the TO mail id (you can give multiple mal ID’s) give the subject f mail and message, check add as attachment option and select User specific name(title/owner/ ID/EMAIL address) using place holder ( Ex:%SI_NAME%.xls) as per the requirement and add .XLS/.TXT.
2.5. Schedule the report daily basis to automatically send the report output to specified folder location. Go to recurrence->mention daily and start time of schedule and end time (future year) and click on schedule.
2.6. Initially status will be running and later Schedule status must be success. Now you can check the destination folder for the report.
2.7. Go to the Inbox of given TO mail id to see the report output.
Finally we scheduled the WEBI report output to Email Inbox. We can schedule other type of BO Reports as well in same way.