Associate a report to a data provider object

[#1]

Hi,

I am trying to associate / link a report to a its dataprovider object, how can i do that? I am trying to display a report and also be able to get the sql statement for that object, but getSQL function only available from sqldataprovider.sqlcontainer.sqlselectstatement object, how do i associate a report to a particular SQL statement? I am using BO XI R2. In addition, i also would like to get the estimated time for a report to run, is it possible? Can i use dataprovider object to do so?

Thanks for any help that anyone can provide.

Thanks,

Sue

[ted_ueda]

Hello Sue,

Are you trying to display the SQL for a Query within a Web Intelligence document? If so, you would create a Cell with a formula like: =DataProviderSQL([Query 1]) where the argument is the Query object.

Are you trying to programmatically retrieve the SQL statement using ReportEngine Java (REBean) SDK? If so, it's as you suggest - you'd walk down the SQLContainer expression tree structure, to get the SQL Select and Where clauses.

To get the estimated time to retrieve data, you'd use the DataProvider.getDuration() method, that estimates the time using previous run times.

Sincerely,

Ted Ueda

[Former Member]

Hi, I try to display a report (a document can have multiple reports) and its SQL. I can get the DocumentInstance and the name of the document, but i need to go down to report and try to link a report to its SQL. But there isn't a link between Report Object and SQLDataProvider.

Any information is greatly appreciated.

[dan_cuevas]

Hi Sue,

There is no easy way to map the objects used within a report.

You will need to traverse the report structure and go through each block in the report.

The ReportStructure object can be retrieved through the DocumentInstance.

From the ReportStructure object you can access the ReportBlock object.

Then from the ReportBlock object you can get the BlockAxis object.

And finally, from the BlockAxis object you can get a ReportExpression object.

The ReportExpression object has a reference to the DataSourceObject object.

If this answers your question, please kindly mark this question as answered.

Regards,

Dan