Skip to Content

1.0     Introduction

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.

 

 

2.0     Scope

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.

3.0     Approach

Please find the steps as follow

1) Get Log On tokens:

http://host:6405/biprws/logon/long [POST]

<attrs>

<attr name=”userName” type=”string” >XXXXXX</attr>

<attr name=”password” type=”string” >XXXX</attr>

<attr name=”auth” type=”string”

possibilities=”secEnterprise,secLDAP,secWinAD,secSAPR3″>secEnterprise</attr>

</attrs>

 

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]

<document>

<name>demo_poc</name>

<folderId>490819</folderId>

</document>

 

4) Add dataproviders:

http:// host:6405/biprws/raylight/v1/documents/490895/dataproviders [POST]

<dataprovider>

<name>Query1</name>

<dataSourceId>475133</dataSourceId>

</dataprovider>

 

//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

http:// host:6405/biprws/raylight/v1/documents/490957/dataproviders/DP0/specification[PUT]

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

http://host:6405/biprws/raylight/v1/documents/490957 [PUT]

Content-Type :: application/xml

 

8) refresh reports

http://host:6405/biprws/raylight/v1/documents/508253/parameters

Content-Type and Accept = application/xml

<parameters> <parameter> <id>1</id> <answer> <values> <value id=”0″>UK</value> </values> </answer> </parameter> </parameters>

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply