BUSINESS OBJECTS RESTFul SDK Webi Report Build Code base sample
This document contains the solution for BO 4.0 SP 6 SDK customization to build custom webi report without BI Launch pad. The approach demonstrates that we can web application and allow user to create on demand custom web intelligence report. There is no need offer all the user access to Business Object BI Launch pad web application. We need only security set up through CMC which will be taken care by BO Admin.
The need to create web application is avoid user access to BI Launch pad where other user can have access to predefined report which has been published to use by user. User is no allowed to create there on defined webi report. We can offer to user all available Universes to select and create their own custom reports.
In old version BO XIR 3.1 we used to do through BO SDK only but most of the API has been deprecated and few are not supported at all. The next step to go with BO 4.0 SP06 which offers RESTFul SDK to build custom webi report and schedule also.
This document outlines the approach for custom webi report through web service call which helps to get the entire existing flavor of Business Objects but without its UI access. There won’t be any issue with direct access user for user into Business Object BI Launch pad, all the available features available if we go through RESTFul SDK approach. It helps to create webi report, schedule to Inbox, file system and even we can add prompt to it if those prompts available into Universe. While running custom reports, we can pass all the required parameters and location where do we need to the report to be schedule. We can run the report on demand too without accessing BI Launch pad.
Please find the steps as follow
1) Get Log On tokens:
<attr name=”userName” type=”string” >XXXXXX</attr>
<attr name=”password” type=”string” >XXXX</attr>
<attr name=”auth” type=”string”
2) Get All webi docuements
http:// host:6405/biprws/raylight/v1/documents [GET]
3) Create webi blank doc
http:// host:6405/biprws/raylight/v1/documents/ [POST]
4) Add dataproviders:
http:// host:6405/biprws/raylight/v1/documents/490895/dataproviders [POST]
//datasource Id –475133 report webi doc id = 490957– POC –475411
Accept :: application/xml only
5) Get existing data provider report specifications
http:// host:6405/biprws/raylight/v1/documents/475411/dataproviders/DP0/specification [GET]
Accept == text/xml
6) Update data providers with existing dataproviders
Content-Type : text/xml only no accept needed
note :: need to update <queryspec:QuerySpec xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:queryspec=”http://com.sap.sl.queryspec” dataProviderId=”DP0″>
7) Save the document without content
Content-Type :: application/xml
8) refresh reports
Content-Type and Accept = application/xml
<parameters> <parameter> <id>1</id> <answer> <values> <value id=”0″>UK</value> </values> </answer> </parameter> </parameters>