Show TOC

Creating a Local Connection for Financial Consolidation with NetWeaver BW CubesLocate this document in the navigation structure

Procedure

  1. Open Microsoft Office Excel or Microsoft Office PowerPoint.
  2. Select the EPM tab.
  3. Click Log On.
    The EPM - Logon dialog box opens.
  4. Click the browse button next to the Connection area.
    The EPM - Connection Manager opens.
  5. Click Create.
    The Create Connection dialog box opens.

  6. In the Connection Type list, select the Local option.
  7. In the Local Connection area, select one of the following provider:
    • the SAP BW OLEDB Provider.
    • or the BAPI provider for BW NW if you want to connect to a large volume data source. In that case, you can click the Use Navigation Attribute option if you want to retrieve navigation attributes from your SAP NetWeaver environment.
    The Create New OLEDB Data Source dialog box opens.

  8. Click Connect.
  9. In the Application Server field, enter the name of the BW server.
  10. Depending on the provider you selected at step 7, select the appropriate authentication method in the MDrmSap.2 Authentication Method or BAPI_Generic Authentication Method dropdown list.
  11. If you selected a BAPI provider, select one of the following authentication method:
    • SAP BW Authentication Basic
    • SAP Enterprise Authentication Basic: use this option if you have access to a dedicated SAP Portal.
      Note You must enter the address of the SAP Portal in the SAP Portal area of the EPM - User Options dialog box.
  12. In the System Number field, enter the system number of your SAP NetWeaver server.
  13. In the Client field, enter your client number.
  14. In the Language field, enter the language of your BW system.
  15. Click Next.
    The Logon dialog box opens.
  16. Enter the user name and password and click Log on.
  17. In the Create Connection dialog box, select the model you want to use.
  18. Enter a name for the connection.
    The name appears in the Connection Manager list of connections.
  19. Click OK.