Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Hello,

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 ... {

          doc.refresh();

          ....

          doc.setPrompts();

          save(doc,filename);

     }

}

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,

peter

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question