如何从业务对象报表中导出CSV？ [英] How to export CSV from Business Object report?

问题描述

我了解从Business Objects客户端可以选择导出为 CSV（仅数据），但是我的理解是，这样的导出将不关心报告，而只是转储原始Universe数据。

没有任何一种方法可以将报告视图导出为CSV吗？

解决方案

这取决于您正在使用的BusinessObjects版本。

最初，CSV导出仅查看Web Intelligence（我假设您是指特定的客户端） microcube 从数据提供者获取的数据，而无视任何格式，过滤器，聚合……您可能已经在报表中指定了。

GUI

但是，您知道可以将报告（而不是整个文档）导出为 CSV存档，这会导致一个Zip文件包含用于

我指的是 BI 4.1 SP05 ，以前的版本可能有此选项，因为我没有确定何时引入。

API

使用BI4中提供的RESTful API，您还可以将报告导出为CSV 。在这种情况下，将返回实际的CSV文件而不是存档。

请记住，要使用RESTful API，您需要在服务器中安装WACS服务器运行RESTful API服务的BusinessObjects环境。您不能在外部Java应用程序服务器上部署REST API。

有关更多信息，请参见导出列表模式的报告（BI 4.1 SP05的SDK信息）。

注释

report 是文档中的选项卡；但是，文档通常（不正确地）称为报告。

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 ?

解决方案

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.

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.

这篇关于如何从业务对象报表中导出CSV？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！