How to get BO 3.1 WEBI report structure details

[Former Member]

Could you please suggest me SDK classes/functions that can be used to extract report metadata including layout, visualizations, order of the columns including hierarchies defined in the report. Is it possible to get output in xml format? COGNOS allow to export report metadata in xml formation. Is BO report can be extracted in similar fashion using BO SDK 3.1?

[DellSC]

You should be able to get most, if not all, of the info you're looking for using the ReportEngine part of the SDK.  You would then have to build the xml based on that information.

-Dell

[Former Member]

Thanks Dell fo rquick response. I have explore ReportEngine SDK and started with DocumentInstance to get the report details. But I could able to get only output of the report but not metadata. I believe I might not be using correct API. Could you please point to me to any sample code or advise me SDK classes / functions I should be looking to get correct metadata of WEBI report.

Thanks in advance.

--Kalyana

[DellSC]

I have attached the code that I built to do some of this - it gets the objects that are used in a Webi.  Be aware that this code has memory issues that I have not yet addressed, so it doesn't yet work well when processing large numbers of reports.

-Dell

BOListObjectsUsedWebI.java.txt.zip

[Former Member]

Thaks for sharing the code. I will check it out... Appreciate your help.

[Former Member]

Hi Dell, I am able to run your program and I could able to get report / Universeses / Data Sources and other information from your program. This is really useful.

I am looking to get additional information related to Report Element / Report Block / Representaion / Graph / Cross Table along with these details... Are there any examples that can provide overview of this set of APIs from DocumentInstance class.

Thanks,

Kalyana

[DellSC]

I'm not sure because I haven't really worked with it for that.  However, looking at the help for the ReportEngine SDK, it looks like you might be able to get to some of that info through DocumentInstance.getReportParts().

If you don't have it already, you can get the documentation from here:  SAP BusinessObjects Enterprise XI 3.1 Service Pack 5 – SAP Help Portal Page.  Click on "Development Information" which will take you down to where the ReportEngine SDK documentation can be downloaded.

-Dell