Troubleshooting Crystal Reports off BW

SAP BW 故障排查与 Crystal Reports 数据验证

最新推荐文章于 2025-10-09 14:48:05 发布

原创最新推荐文章于 2025-10-09 14:48:05 发布 · 88 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#BO

Data Warehouse&BI 专栏收录该内容

79 篇文章

订阅专栏

本文提供了 SAP BW 连接故障排查过程中的一些实用技巧，包括使用 MDX TEST 检验 Crystal Reports 使用的 MDX 语句、通过 SE37 手动调用 OLAP BAPI 函数验证元数据、使用 RSFLAT 重现 Crystal Reports 查询的数据流、以及使用 RSRTRACE 创建 SAP BW 服务器的 OLAP 跟踪来辅助故障排查。

http://wiki.sdn.sap.com/wiki/display/BOBJ/Troubleshooting+Crystal+Reports+off+BW#TroubleshootingCrystalReportsoffBW-TracingBOE

Quite useful, especially this part:

SAP BW connectivity

For the SAP BW connectivity you can also look at the following items as part of the troubleshooting process:

Use transaction MDXTEST to verify the MDX statement used by Crystal Reports and to verify the data. You can find the MDX statement by selecting Show SQL query in the Database menu.
Please refer to the following documentation for more details:
http://www.sdn.sap.com/irj/scn/events?rid=/library/uuid/b0320722-741c-2c10-afab-93b5c0fc7e96
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0b98a32-f10d-2b10-7282-da9ee1a85b3f&overridelayout=true
With transaction RSFLAT you can emulate exactly the same query and verify the datastream you woulg get in Crystal Reports. This transaction is useful when you want to see what data a BEx query will return.
Use transaction SE37 to call the OLAP BAPI function manually so that you can verify the metadata retrieved by Crystal Reports. You can see OLAP BAPI calls in SAP integration trace.
Please refer to section 8.3.1 of [Web Intelligence on SAP implementation best practices]
Use transaction RSRTRACE to create an OLAP trace on the SAP BW server.
Please refer to section 8.3.2 of [Web Intelligence on SAP implementation best practices]