Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BI Publisher report downloading through web service with data chunk

745658Sep 2 2010 — edited Sep 2 2010
Hi,

I am generating report with BI Publisher through BI Publisher web service (xmlpserver). The syntax is as follow (in C#):

--------------------------------------------------------
publisher.ReportRequest report = new publisher.ReportRequest();
report.reportAbsolutePath = ....xdo;
report.attributeTemplate = ....template name;
report.attributeFormat = .....type of generated document (excel,rtf,...);
report.attributeLocale = "sl-SI";
report.sizeOfDataChunkDownload = -1;
publisher.PublicReportServiceService publish = new publisher.PublicReportServiceService();

publish.Timeout = 86400000;
publisher.ReportResponse repResponse = new publisher.ReportResponse();

repResponse = publish.runReport(report, "Administrator", "Administrator");

Int64 length = repResponse.reportBytes.GetLongLength(0);
for (Int64 ii = 0; ii < length; ii++)

{

file.WriteByte(repResponse.reportBytes[ii]);

}
--------------------------------------------------------

But since some documents are very very big (like couple of hundreds of MB) I have memory problems. I tried to generate the report and download it in data chunks
but I don't have any idea how.

There is a method downloadReportDataChunk but this metod does not have any reportRequest parameters, so there must be some method before this one. Can anybody help?

Regards,
Tilen

Edited by: user613991 on 2.9.2010 6:07
Comments
Locked Post
New comments cannot be posted to this locked post.