Skip to Content
author's profile photo Former Member
Former Member

export the same webi report several times with different prompt values using java report engine sdk


I just started using the Java Report Engine SDK for exporting Webi-Reports on BI4.x.

What I want to achieve is the following workflow:

Connect to the server, open a webi-document and export report-sets as pdfs.

Imagine a report that contains "sales revenue" for different "cities" in different "states" in several "years".

What actually works very fine for me is to get the full report with the entire dataset or to select for example some special cities or years using the setPrompts()-method.

But what I really want is to get a set of pdfs with for example all combinations of states and years (4 states, 3 years --> 12 pdfs).

I actually tested my code with to nested loops with the following code:

for .... {
     for ... {

Now the thing is, that I was wondering if this is the right way to call the refresh()-method every time or if there is a more simple way.

I suppose there is some sort of caching when the refresh-method is called for example severeal thousand times in a row?

By the way, I don't need the prompts if there is another way for filtering the data.

thanks for any advice.

best regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 30, 2014 at 03:38 PM

    First off, you need to call .refresh() AFTER setting the prompts - otherwise it won't have the correct prompt values before your export.

    Another way to do this might be to put the report into a Publication, which can burst it for you. You'll need to create a second report that will pull the information about where to burst the report into separate files. This can then be scheduled directly in BO and doesn't need to have any code written.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.