Calling a webi report chart into other applications

[boeuser4397]

Hello,

  Is it possible to call a webi report chart (not the whole report) from a external application. I know we can call a webi report from other applications but our requirement is to call only specific report parts like line graph or charts from a webi report.  Is this possible using Java SDk or RESTful SDK? If so can you please let me know how to achieve this? Thanks!

[daniel_paulsen · Accepted solution]

Hi Rakesh,

Yes, you can export the chart element and use it in another application.  To access the Element in a report tab of a webi document, use the following request:

GET    .../raylight/v1/documents/<docId>/reports/<reportId>/elements/<elementId>

See section 8.4.10 in the documentation: SAP BusinessObjects Business Intelligence platform 4.1 – SAP Help Portal Page

Select the latest (highest SP) document titled:

"SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer"

Dan

[boeuser4397 · Accepted solution]

Thanks Dan. I will look into it.

[boeuser4397 · Accepted solution]

Hi Daniel - I have looked at the document and tried to get the code using REST SDK but getting the below error. I tried to give user login details in Header but it didn't work. Any suggestions on this? Thanks.

<error>

<error_code>WSR 00001</error_code>

<message>No Session found in HTTP header X-SAP-LogonToken</message>

</error>

Thanks!

[daniel_paulsen · Accepted solution]

Hi Rakesh,

Its not the login details that you provide in the header, but rather the logontoken created after logging in with the REST APIs.  If you have logged in and created a token, you need to ensure it is surrounded in double quotes in the X-SAP-LogonToken header.

I have created a short video: "Rest Client Intro". You can have a look at to see what I mean if you have not done this yet.  The link also has a short video showing how to install and run the Java Samples (create a report, add charts, schedule, refresh, change datasource etc) for REST that ship with the product.

Dan

[boeuser4397 · Accepted solution]

Dan - Thanks for the videos , they definitely helps. I will look into them and implement in our environment.

Thanks!