How to read Data of a Webi Report

[Former Member]

Hello Friends,

I have a task where I need to read data of a Webi Report, how can it be done?

Basically I have a trigger report which runs every day and get the latest RACN number from the database. I am trying to get that RACN number from trigger report using BOBJ SDK.

I really appreciate your suggestions on this.

Regards,

Rakhy. 

[Former Member · Accepted solution]

Hi Rakhy,

Is the RACN Number a column or dimension in your webi report? Is it a universe object(webi based on universe)

Also what version of BusinessObjects you are using?

If you are using XI 3.1 and you need to retrieve objects from a webi report it can be done using the ReportEngine SDKs.

Please refer to the developers guide and API referrence guide available at

http://help.sap.com/businessobject/product_guides/boexir31/en/resdk_java_dg_12_en.zip
http://help.sap.com/businessobject/product_guides/boexir31/en/resdk_java_apiRef_12_en.zip

Also refer to the document at
http://scn.sap.com/docs/DOC-38618 for better understanding the workflow.

An example snippet of how to retrieve an object is below
=========================================
DocumentInstance wiDoc = widocRepEngine.openDocument(oInfoObject.getID());
ReportDictionary reportDictionary=wiDoc.getDictionary();
for(int a=0;a<reportDictionary.getChildCount() ;a++)
{
String name=reportDictionary.getChildAt(a).getName();
out.println(name);

}
=========================================

-Prithvi

[Former Member · Accepted solution]

Hi Prithvi,

Thanks for your reply.

RACN number is a dimension (universe object ) in the webi report and we are using XI 4.1 SP 1.7

Can you please provide me an example or external link?

with the above example snippet, I am getting the following error

(This feature is not implemented. (Error: RWI 00013))

Regards,

Rakhy.

[Former Member · Accepted solution]

Hi Rakhy,

As you mentioned you are using BI 4.1, I would like to bring to your notice that a lot of features have been removed from ReportEgine SDKs from BI 4.x onwards.

The sample snippet provided was for XI 3.1.

As theses features have been removed you are getting the above exception.

You would have to move towards the Webi Restful web services sdks as it is the future and is as an replacement for ReportEgine SDKs.

You can find the documentation at

http://help.sap.com/bobip?current=bobi&show_children=false#section7

Refer to 'SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer' as per your product version.

Specifically you would be interested in the section 'Managing DataProviders-->Getting the details of the dataprovider' from the above guide.

Also in case of any queries regarding the Restful webservices you can post your queries in the below forum

http://scn.sap.com/community/restful-sdk

-Prithvi

[Former Member · Accepted solution]

Thanks Prithvi, for your valuable input.

I will check on Webi Restful web services SDK's.

Regards,

Rakhy.