Webi reports through SDK

Friends
I have installed business objects portal integration kit for websphere 6.0 and i am able to access business objects portlets and get into my infoview. But now the requirement is that the user should not see the infoview and for that we are developing a portal. When a user logs into the portal he will have to put in some elements in there and fill in those elements like Age____ or Adrress____. Based on these inputs a report should be generated in webi in graphical format and dispayed on the same screen when a user hits submit button in the portal.
My question is that is it possible via sdk and if yes then could you all please help?


alexks (BOB member since 2008-03-25)

Yes, it is possible using the Report Engine SDK. This is not a trivial problem to solve though. At a high level you will need to
[list]Query for the report and get the IInfoObject
Get the prompts for the report and build your custom prompt screen
On submission you need to pass the prompt values to the report
Run the report
Request an output stream (PDF, Excel, etc.)
Handle the output stream in your portal
[/list]

A lot more to this than can be covered here. If you search on refreshing Webi reports in this forum you will find examples of how to get the report prompts, fill them and refresh the report.


jwhite9 :us: (BOB member since 2006-07-28)

Jwhite
Thank you so much fr the reply…
I need to clarify few things here. Firstly it makes a new report right ? It is not going to call for an existing report. Secondly how is report engine sdk different than web services sdk?
I really appreciate your help. We are actually stuck at the point where how the prtal will call for Business Objects to build these reports and show them as graphs. If you could just let me know how woould it fetch the data then it would be highly obliged…


alexks (BOB member since 2008-03-25)

My suggestion assumed that you would be running an existing report not creating a new one. The Report Engine SDK can be used to build a report from scratch and you can use it along with Web Services. If you review the docs for the two SDK’s you will see that they are very different, each having it’s own purpose.


jwhite9 :us: (BOB member since 2006-07-28)

SO you are basically suggesting that i can combine both the SDK"s achieve my results? Do you have a sample code which i can refer?


alexks (BOB member since 2008-03-25)

Unfortunately I do not. I do all of my stuff with the Enterprise SDK and ther Report Engine SDK. All you need to do is include the relevant jars in your build path and import the appropriate classes.


jwhite9 :us: (BOB member since 2006-07-28)

Thats fine. Thanks a lot for your help. I am going to do it today and if I have any errors I will post the code.


alexks (BOB member since 2008-03-25)