Cross-database comparison provides support for native SAP Business Information Warehouse by enabling you to extract data directly from SAP BW.
To do so, you enter the RFC destination to your SAP BW system.
You have created an RFC connection to your SAP BW system.
If you select Business Intelligence (MDX Query)
as your source type, you must enter the RFC destination to your SAP BW system. You then create your data model by specifying the InfoCubes as the tables and dimensions or key figures as the fields. Dimensions are automatically marked as key fields in the data model.
On generation, an MDX query is created for this data model. When you run your comparison, the MDX query is sent to SAP BW over the RFC connection that you specified.