SAP Knowledge Base Article - Preview

2394905 - How to compare data between BW and BO when querying data with BW relational connection(BW JCO)

Symptom

  • Compare data between BW and BO when querying data with BW relational connection(BW JCO)
  • When using BW relation connection, it uses Data Federation service to connection to BW, we can get sql query in Data Federation Administration Tool,
    but this SQL script can't be executed in BW. In this KBA, it's introduced that how to get and execute SQL script at BW side when using BW relational connection.
  • Then users can compare the result set of query between BW and BI tools.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform (BI) 4.x
  • SAP BusinessObject Data Federation Administration Tool

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

Data Store Object, multiprovider, debug report, debugreport, trace, JCO connection, Data Federation Administration, SQL query , KBA , BI-BIP-DF , Data Federation Service , BI-BIP-SL , Semantic Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.