BO 4.X Webi从excel下载报告 [英] BO 4.X Webi download report from excel
问题描述
我想知道有没有办法让我在excel表单中单击一个按钮（带参数），并从服务器获取报告。
我一直在想使用restFUL网络服务，但似乎有一个性能问题。
我还考虑使用SDK中间使用JAVA应用程序，但是当我添加一层时，它并不令人满意。
你知道是否有其他方法下载
对于这种类型的需求，您通常会使用 OpenDocument 功能。有一件事，它不会做，至少不是Webi文档，而是以Excel格式提供输出（HTML和PDF是Webi的两种可能的格式）。总而言之，Excel导出选项只有大约两三点钟的距离，但我可以理解，这不是一个理想的解决方案。
另一个选项是作为ReNBAN SDK（您需要与Webi文档进行接口的Java SDK的一部分），我不推荐使用的 Java SDK 已被弃用并被REST SDK替代。
如果OpenDocument功能不够，则 REST SDK 将成为方式。请记住，这将涉及相当多的步骤，每次发送命令到WACS服务器，然后解码的答案。步骤如下：
- 验证并获取登录凭证
- 刷新文档（如有必要）传递提示值）
- 将文档导出到Excel
- 关闭文档
只能在您的BI4服务器上运行的WACS服务器上支持REST接口（除非您有自定义的风景）。如果速度很慢，我会建议研究这个性能问题的根本原因，而不是完全丢弃SDK。
如果要使用REST界面，我建议选择使用REST而不是XML进行JSON通信。更容易阅读和解析。
最后一个不推荐的选项是 LiveOffice 。这是一个单独的产品，允许您将Webi文档中的内容嵌入到Office文档（最显着的Excel）中。 LiveOffice一直都有自己的问题，并且SAP并没有收到很多需要更新的爱。
一个最后的想法：报告永远不会出现在同一张表中，至少不需要额外的编码量。无论你最终选择什么SDK，你总是会得到一个Excel文件。如果要显示从您开始的Excel文件中的结果，则需要编写打开生成的文件的步骤，获取内容，然后将其复制到工作表。
With newly released WEBI there's no way to manipulate reports with VBA like it used to be done with DESKI era.
I'd like to know if there's a way for me to click a button (with parameters) in excel sheet and get a report from the server.
I've been thinking of using the restFUL webservices but it seems that there is a performance problem.
I also considered using a JAVA app in the middle using the SDK but it's not really satisfying as I add one layer.
Do you know if there's an other way to download a webi report from and to excel.
For this type of requirement, you'd normally use the OpenDocument feature. There is one thing that it won't do however, at least not for Webi documents, and that is deliver the output in Excel format (HTML and PDF are the two possible formats for Webi). In all fairness, the export to Excel option is only about two or three clicks away, but I can understand that this wouldn't be an ideal solution.
Another option is the Java SDK, which I would not recommend, as the ReBEAN SDK (the part of the Java SDK you need to interface with Webi documents) is deprecated and replaced by the REST SDK.
The REST SDK would be the way to go if the OpenDocument feature is not sufficient. Keep in mind that this would involve quite a few steps, each time sending a command to the WACS server and then decoding the answer. The steps would be:
- Authenticate and get a logon token
- Refresh the document (if necessary pass prompt values)
- Export the document to Excel
- Close the document
The REST interface is only supported on the WACS server, which should run on your BI4 server (unless you have a customised landscape). If it's slow, I would suggest looking into the root cause of this performance issue, instead of discarding the SDK altogether.
If you're going to use the REST interface, I would recommend opting for JSON to communicate through REST instead of XML. It's easier to read and parse.
A last option, which I wouldn't recommend, is LiveOffice. This is a separate product which allows you to embed contents from Webi documents into Office documents (most notably Excel). LiveOffice has always had its share of problems and has not received much love from SAP regarding much needed updates.
One final thought: the report will never appear in the same sheet, at least not without an additional amount of coding. Whatever SDK you end up choosing, you will always end up with an Excel file. If you want to show the results in the Excel file you started from, you'll need to code the steps to open the generated file, grab the contents and then copy those to your worksheet.
这篇关于BO 4.X Webi从excel下载报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
