Exporting a Report as a Series of Pages

Exports a report of a Web Intelligence document as a series of pages in one of the following formats:

  • XML
  • PDF
  • Microsoft Excel 2003
  • Microsoft Excel 2007
Request

GET <webiURL>/documents/{documentId}/reports/{reportId}/pages

Where:
  • {documentId} is the document identifier retrieved from the list of documents
  • {reportId} is the report identifier retrieved from the list of reports
Table 1: Optional Parameters
Parameter Description Supported Formats
dpi

Resolution in dots per inch (dpi) for generated charts. Value between 75 and 9600. Default is 300 for PDF format, 96 for all other formats.

All

mode

normal (default) or quickDisplay.

All

unit

A string that defines the unit that sizes will be reported in. Values are "metric", "millimeter", "point", and "pixel" (default).

XML
rawValues Boolean. Default is false. If true, the raw values and their types are exported with the formatted values. XML
optimized

Boolean. Default is false. If true, the generated output is optimized for calculations inside Microsoft Excel.

Microsoft Excel 2003 and Microsoft Excel 2007
orientation

Page orientation. Use to force a specific page orientation. Values are portrait and landscape.

If mode=normal
widthScaling

Number of pages per report displaying in width. The document setting applies by default.

If mode=normal
heightScaling

Number of pages per report displaying in height. The document setting applies by default.

If mode=normal
Response
Response type:
  • text/xml
  • application/pdf
  • application/vnd.ms-excel for Microsoft Excel 2003
  • application/vnd.openxmlformats-officedocument.spreadsheetml.sheet for Microsoft Excel 2007

Response body: the report in the expected format.

Example

XML
curl -G -s -H "accept:text/xml" -H X-SAP-LogonToken:"""<tokenValue>"""
 "<webiURL>/documents/9227/reports/1/pages" > xmlreport.xml

Example

PDF
curl -G -s -H "accept:application/pdf" -H X-SAP-LogonToken:"""<tokenValue>"""
 "<webiURL>/documents/9227/reports/1/pages?mode=normal&widthScaling=1" > pdfreport.pdf

Example

Microsoft Excel 2003
curl -G -s -H "accept:application/vnd.ms-excel" -H "X-SAP-LogonToken:""<tokenValue>"""
 "<webiURL>/documents/9227/reports/1/pages" > excel2003.xls

Example

Microsoft Excel 2007
curl -G -s -H "accept:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
 -H X-SAP-LogonToken:"""<tokenValue>""" "<webiURL>/documents/9227/reports/1/pages" > excel2007.xlsx