How to: Retrieve Data from a SAP NetWeaver BI Data Source (Report Builder 2.0)
To use data from an SAP NetWeaver® Business Intelligence database in your report, you must define a data source with the type SAP NetWeaver Business Intelligence and one or more report datasets. When you define the data source, you must specify a connection string and credentials so that you can access the data source from your client computer.
You can create an embedded data source definition for use by a single report or a shared data source definition that can be used by multiple reports. The procedures in this topic describe how to create an embedded data source. For more information about shared data sources, see Embedded and Shared Data Sources (Report Builder 2.0) and Creating, Modifying, and Deleting Embedded Data Sources (Report Builder 2.0).
After you create a SAP NetWeaver Business Intelligence data source definition, you can create one or more datasets. After you create a dataset, the name of the dataset appears in the Report Data pane as a node under its data source.
After you publish your report, you might need to change the credentials for the data source so that when the report runs on the report server, the permissions to retrieve the data are valid.
To create an embedded SAP NetWeaver BI data source
On the toolbar in the Report Data pane, click New, and then Data Source. The Data Source Properties dialog box opens.
In the Name text box, type a name or accept the default name.
Verify that Embedded connection is selected.
From the Type drop-down list, select SAP NetWeaver BI.
Specify a connection string that works with your SAP NetWeaver Business Intelligence data source.
Contact the database administrator for connection information and for the credentials to use to connect to the data source. 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:
Click Credentials. Set the credentials to use for this data source. For more information, see Specifying Credentials for a Report Data Source (Report Builder 2.0).
To test the data source connection, click Edit. in the Connection Properties dialog box, click Test Connection. If the test is successful, you will see the informational message "Test connection succeeded." If the test fails, you will see a warning message with more information about why the test was not successful.
The data source appears in the Report Data pane.
To create a dataset for an SAP NetWeaver BI data source
In the Report Data pane, right-click the SAP NetWeaver Business Intelligence data source, and then click Add Dataset. The Dataset Properties dialog box opens.
In the Data source text box, verify that the name of the data source you right-clicked appears.
Under the Query text box, click Query Designer. The query designer for Hyperion Essbase opens in Design mode.
Select the appropriate database and create a query by dragging items from the metadata pane to the Data pane. For more information about working with this query designer, see SAP NetWeaver BI Query Designer User Interface (Report Builder 2.0).
The dataset and its field collection appears in the Report Data pane under the data source node.
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" in the Reporting Services documentation in SQL Server Books Online.