Show TOC

Function documentationBusiness Intelligence Data Sources

 

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.

Prerequisites

You have created an RFC connection to your SAP BW system.

Activities

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.