Defining Report Datasets for Multidimensional Data from an SAP NetWeaver BI System

New: 14 April 2006

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. Reporting Services also provides information about how to define datasets for an SAP relational database. For more information, see Defining Report Datasets for Relational Data from an SAP Database.

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: Create a Dataset (Report Designer).

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.

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

To Create a Dataset
  1. On the Data tab, from the Dataset drop-down list, select <New Dataset>. On the Dataset dialog box, from the Data source drop-down list, select New Data Source. On the Data Source dialog box, from the Type drop-down list, select SAP NetWeaver BI.

    Note

    If you do not see SAP NetWeaver BI as choice for data source type, you may need to configure Reporting Services to recognize this data processing extension. For more information, see Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider 1.0 for SAP NetWeaver Business Intelligence.

  2. Specify a connection string that works with your SAP NetWeaver Business Intelligence data source. Contact your database administrator for connection information. The following connection string example specifies an SAP NetWeaver Business Intelligence data source on a server using port 8000 and XML for Analysis Services (XMLA) over the Internet using SOAP:

    DataSource=http://mySAPNetWeaverBIServer:8000/sap/bw/xml/soap/xmla
    
  3. Set the database credentials in the Data Source dialog box on the Credentials tab. For more information, see Connecting to a Data Source.

    Note

    Not all report delivery modes are supported by this data provider. Delivering reports through data-driven subscriptions is not supported for this data processing extension. For more information, see Using an External Data Source for Subscriber Data.

External Resources

Using SQL Server 2005 Reporting Services with SAP NetWeaver Business Intelligence

See Also

Concepts

Defining Report Datasets
Report Data How-to Topics (Report Designer)
Connecting to a Data Source
Defining Report Datasets for Multidimensional Data from an SAP NetWeaver BI System
Defining Report Datasets for Relational Data from an SAP Database

Help and Information

Getting SQL Server 2005 Assistance