Show TOC

SAP BW (INA Provider) Connections Locate this document in the navigation structure

Using the SAP BW (INA Provider) connection, you can do the following:
  • Work with BW queries (with or without variables).
  • Retrieve data, using reports.
  • Enter and save data, using input forms.
  • Execute planning function for BW Integrated Planning.

To create the connection, refer to the SAP BusinessObjects Analysis, edition for Microsoft Office Administrator Guide.

Each time you connect to this connection, you will need to select a query. Once you have selected the query, the report that is automatically displayed is the query definition such as it is defined on the server side, that is: free characteristics, rows and columns.
Tip In the dialog box where you select a query, you can define a query as a favorite query by clicking the icon in the Favorite column.
Working with Planning and Consolidation 10.1

Applies to: SAP BW (INA Provider) connections with SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver or higher.

If you work with SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver or higher:
  • If you want to make the work status feature available, you must select an environment and model for the connection.
  • Each time you connect to this connection, you will need to select one of the following:
    • a query. Once you have selected the query, the report that is automatically displayed is the query definition such as it is defined on the server side, that is free characteristics, rows and columns.
      Tip In the dialog box where you select a query, you can define a query as a favorite query by clicking the icon in the Favorite column. The next time you connect with the same connection, the favorite is displayed by default in the dialog box.
    • a workbook. The workbook is opened, displaying the reports already defined. For information on the server folder structure, see Server Folder Structure.
  • The following features are available: Business Process Flows, Work Statuses and Open/Save.