Extract objects in reports (from query builder?)

[Former Member]

Hello,

We are using WEBI XI 3.1 SP 6.4

We are currently re-factoring our data-warehouse and we need to find a way to extract the objects used in a report for specific universe.

I found this topic on Query Builder.

We may extract the Reports linked to a universe from here BUT not the content (Objects used) of the Report.

Does anyone know how to do this from Query Builder?

Is there a solution in JAVA?

PS: we are not admin on our computers, on highly secured environment, so link to an exec file is not a solution as we can not copy them on the computer and run them

Many Thanks,

[Former Member]

of course it is BO XI but what I meant is that we use only WEBI no Desktop Reports.

[DellSC]

To do this in code, you would write a java program using a combination of the java SDK (to find the reports) and the ReportEngine SDK (to get the objects in each report).  There are links to sample code for this here:  .

-Dell

[former_member198519]

Since you are on BO XI 3.1. This should be a great help to you:

SAP BI Repository Documentor - SAP BI BusObj 4

[Former Member]

I think you are referring to this one for BO XI 3.1 :

XI3.1 - Recurring Instance Detail List - Excel 2007 Macro

[Former Member]

Thanks Gosh,

but this solution is not giving the details IN a report.

What I need is the report and the objects used:

eg: Report 1 - Universe A - obj1, obj2, ...

[Former Member]

Thanks Bayerm,

but this solution is not giving the details IN a report.

What I need is the report and the objects used:

eg: Report 1 - Universe A - obj1, obj2, ...

[former_member198519]

Apart from the sample Audit report which is provided in the forums, there are no other reports.

You need to make those reports by yourself .