How to export CSV from Business Object report?

business-objects business-objects-sdk
user2123288 picture user2123288 · May 19, 2015 · Viewed 7.5k times · Source

I understand that from Business Objects client I have an option to export to "CSV (data only)", but my understanding is that, such an export will not care about the report but just dump the raw universe data.

Isn't there any single way to be able to export the report "view" to CSV ?

Answer

ƘɌỈSƬƠƑ picture ƘɌỈSƬƠƑ · May 19, 2015

It depends on the version of BusinessObjects you're working on.

Originally, the CSV export only looked at the Web Intelligence (I assume you're referring to that particular client) microcube, meaning the raw data retrieved from the data provider(s), and disregards any formatting, filters, aggregations, … you may have specified on your report.

GUI

However, you know have the option to export a report (so not the whole document) as a CSV Archive, which results in a Zip file containing a CSV for the active report at the time of export.

I'm referring to BI 4.1 SP05, previous versions may have this option as I'm not sure when it was introduced.

Export to CSV archive

API

Using the RESTful API that is available in BI4, you can also export a report to CSV. In this case, the actual CSV file will be returned instead of an archive.

Remember that in order to use the RESTful API, you need to have a WACS server in your BusinessObjects environment, running the RESTful API service. You cannot deploy the REST API on an external Java application server.

For more information, have a look at the section Exporting a Report in Listing Mode (SDK information for BI 4.1 SP05).

Remarks

A report is a tab within a document; documents however are often (incorrectly) referred to as reports.

Related questions

Business Objects Enterprise reporting using SDK client gives exception

We have a client that is using the SDK for invoking reports on the Business Objects Embedded Report Server. We can login, but when calling the openDocument method, something goes wrong. code: //LOGON IEnterpriseSession session = sessionMgr.logon(username, password, clusterNode, …

Read More
How to find a list of all User Security principals (users/user groups) for each folder in a SAP BusinesObject 3.1 envirnoment

In BO 3.1 CMC, if you right click a folder then "User Security" you get a list of users and user groups with an associated access level. What is the simplest way to automate the extraction of these to a flat …

Read More
Business Objects 4.1 OpenDocument edit with Enterprise Login

This question comes from a complete Java newbie, so please don't hesitate to point out obvious or simple things in your answers! I am working on a migration from Business Objects' 3.1 to 4.1. Part of that migration involves moving existing reports …

Read More