Limit data return in report using SAP BO 4.1's Java SDK

[Former Member]

I'm developing a tool that can export report to excel after refreshing it.

I also want to limit data to 100 records for each Dataprovider but i really have no idea.

I'm connecting SAP BO 4.1 server which many method of the SDK cannot use on SAP BO 4.1.

Does anyone know a way to achieve this?

[Former Member]

What if you set the limit on the webi report itself?

You can limit the rows a query would show in the report and then export the same to excel.

Thanks,

Prithvi

[Former Member]

My problem is I have to export several reports not just one report.

That why I develop this tool to export several reports (thousand of them).

[Former Member]

As you are using BI 4.1, you would need to use the Restful web services as it is the future especially in terms of webi reports as of now. Most of the features from standard report engine java sdks have been deprecated and are being re-introduced in the Rest sdks.

Refer to the document at

http://help.sap.com/saphelpiis_sbo41sp6wi-sdk/frameset.htm?ec5538766fdb101497906a7cb0e91070.html

You would need to refer to the section "Query Options". For setting the number of rows to be retrieved for the dataprovider, you need to set the  'maxRowsRetrieved' parameter.

For any queries related to Restful web services, post your questions to below forum link, which is a dedicated space for Rest SDKs.

Thanks,

Prithvi