Creating Report Datasets from an SAP NetWeaver BI Data Source

Reporting Services provides a data processing extension that supports report data retrieval from an SAP NetWeaver® Business Intelligence data source. The Microsoft .NET Framework Data Provider 1.0 for SAP NetWeaver Business Intelligence retrieves multidimensional data from InfoCubes, MultiProviders (virtual InfoCubes), and Web-enabled queries defined on a SAP NetWeaver Business Intelligence data source. This data processing extension provides a graphical query designer to help you explore data on the underlying data source and select the data to use in your dataset.

After you have connected to a SAP NetWeaver Business Intelligence data source, you can define a dataset that specifies the report data to retrieve during report processing. For more information, see How to: Retrieve Data from a SAP NetWeaver BI Data Source.

You can use the graphical query designer in Design or Query mode to build a Multidimensional Expression (MDX) query by browsing the underlying data structures on the data source. At design time, you can interactively run a query from the query designer to see the results. The query you build defines fields in the dataset. At run time, the actual data is returned from the data source. Use the graphical query designer to perform the following actions:

  • In Design mode, drag dimensions, members, member properties, and key figures from the data source onto a Data pane to build a Multidimensional Expression (MDX) query. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using SAP NetWeaver BI MDX Query Designer in Design Mode.

  • In Query mode, drag dimensions, members, member properties, and key figures onto the Query pane or type MDX text directly into the Query pane. Drag calculated members from the Calculated Members pane to the Data pane to define additional dataset fields. For more information, see Using SAP NetWeaver BI MDX Query Designer in Query Mode.

As you build queries, the query designer automatically adds default properties to the MDX query. To include properties other than default properties, you must manually modify the MDX query. For more information, see Using Extended Field Properties for an SAP NetWeaver BI Data Source.

For more information, see SAP NetWeaver BI Query Designer User Interface.