BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Can WebI reports be batch scheduled w/o a custom solution?


 
Search this topic... | Search XI Scheduler... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Author Message
JSW
Senior Member
Senior Member



Joined: 15 Jan 2013

Posts: 81



PostPosted: Tue Jul 31, 2018 6:47 am 
Post subject: Can WebI reports be batch scheduled w/o a custom solution?

Hi,

We are running BO 4.2 SP2. This may be a very basic question, and this may not be the correct forum for it, but here goes.

I have done some basic report scheduling, but only for things like scheduling a report once a month. A recent project requires running a WebI report approximately 250 times on the first of the month. It needs to produce Excel reports for approximately 250 customers, based on a list of account numbers that could change monthly. The plan is to FTP these Excel files to a third party, who will handle the security and distribution to our customers.

This seems pretty straight forward to me, but I've done a lot of research over the past several weeks, and I can't find a good solution to batch schedule one report based on a list of account numbers. I'm really hoping to avoid having to create 250 individually scheduled reports!

I realize SAP provides a SDK that could provide a means of doing this, but we are trying to avoid a custom solution. At first the SAP Publisher Service seemed promising, but from everything I've seen, that is only for Crystal Reports. I've also looked at report bursting, but that seems to be designed to distribute a single report to a dynamic list of recipients.

Can anyone tell me if there is a way to schedule a single WebI report, that uses a dynamic list of accounts for input and produces individual reports, without using the SDK or another custom solution?

Thank you very much for your help!
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19318
Location: Bratislava


flag
PostPosted: Tue Jul 31, 2018 8:04 am 
Post subject: Re: Can WebI reports be batch scheduled w/o a custom solutio

Hi,

Check Publications.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
JSW
Senior Member
Senior Member



Joined: 15 Jan 2013

Posts: 81



PostPosted: Tue Jul 31, 2018 8:53 am 
Post subject: Re: Can WebI reports be batch scheduled w/o a custom solutio

Hi Marek,

Below is a screenshot of my WebI prompt for the report I need to schedule. It will require 250 individual Contract Account numbers (one report run per customer). The second prompt is calculated by the BEx Query, and defaults to the prior month, which is what we want to run it for.

I've also included a screenshot of the Prompt Summary from the Publication setup. For the Contract Account, it says "To be processed by database server". I'm not sure what that means, and I haven't been able to find an explanation of it. Is there a way to dynamically populate the prompt at runtime by using a BEx Query, list of accounts in Excel, csv file, etc?

Thanks for your help!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0021 Parse 0.0008 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo