Xtract RS – SAP and the MS Reporting Services

Xtract RS is a data provider for SAP that is optimized for Microsoft Reporting Services. As a so-called data extension, it integrates itself seamlessly in the Business Intelligence Studio and Reporting Services Server. Access is made in real-time and because it is direct, it is free of additional software layers and other middleware. When it comes to performance, this simple yet effective architecture can’t be topped.

 
  • Directly read SAP tables
  • SAP queries
  • RFC function modules and BAPIs
  • BW objects (cubes, query cubes and master data)
 
The following image shows the SAP query data source at the time of design. The input parameters can simply be linked with reporting parameters.
Report variants are naturally also supported.
 

[ Click on image to enlarge ]
 
The following screenshot shows a BW query being called. The necessary dimensions and key figures are simply dragged into the query output and are then available in the data set within the report designer.
Of course, query variables can also be linked with reporting parameters.
 
 
[ Click on image to enlarge ]
 
The preview shows how the reporting parameters are also filled from the cube and then directly transferred to the BW query.
 

[ Click on image to enlarge ]
 
 
Quicklinks and additional information
[ Downloads und Evaluierung ]