Import Data Connection to an SAP BPC System

You can create a connection that allows you to import data and models from an SAP Business Planning and Consolidation (BPC) system.

Prerequisites

To connect to the standard configuration of SAP BPC for BW/4HANA, version 11.0 SP01 or higher or version 11.1 SP00 or higher, you have completed ONE of the following setup options:
To connect to SAP BPC for SAP NetWeaver, version 10.0 SP12 or higher, or the standard configuration of 10.1 SP2 or higher, you have completed ONE of the following setup options:
To connect to SAP BPC for Microsoft Platform, version 10.0 SP12 or higher, or 10.1 SP2 or higher, you have completed ONE of the following setup options:
Note
The BPC connection is available only with a planning license.

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path

    The Select a data source dialog will appear.

  2. Expand Acquire Data and select SAP BPC.
  3. Select the type of SAP BPC system you will connect to.
  4. In the New BPC Connection dialog, enter the following information:
    1. A name and a description for the connection.
    2. In the Datasource Configuration section, select the Location of your cloud connector from the list.
    3. Enter your SAP BPC Host Name and Port.
    4. In the Credentials section, select the authentication method you want to use.

      There are two types of authentication methods: Basic Authentication and OAuth Authentication.

    5. If you choose the Basic Authentication, enter the User ID and Password for your BPC system.
    6. If you choose to use OAuth Authentication, you need to create your OAuth client in BPC system following the prerequisites and detailed steps described in Creating an OAuth Client for BPC Data Acquisition with SAP Analytics Cloud.
    7. Then go back to SAP Analytics Cloud, enter the OAuth Client ID, Secret and Authentication URL you defined in BPC.
    8. Choose the button Go Authenticate, then a dialog will pop up for you to enter your BPC user and password. If you’ve configured SAML SSO, then you can directly single sign on to your BPC authorization page.
      Note

      To configure SSO, the following prerequisites should be met:

      • You are using same Identity Provider (IdP) for SAP Analytics Cloud and SAP NetWeaver. For more information on setting up your identity provider in SAP Analytics Cloud, see Enabling a Custom SAML Identity Provider.

      • Ensure that SAML authentication related settings have been configured for BPC in SAP NetWeaver. For more information on enabling SAML on SAP NetWeaver, see Enabling the SAML Service Provider.

    9. In the next dialog, choose Allow to confirm to assign the OAuth scope to SAP Analytics Cloud user.
  5. After you are authenticated successfully, choose OK.
    The new connection is added to the list of connections on the Connections screen.
  6. In a case when you use an OAuth connection and the OAuth token expires, you need to re-authenticate again.
  7. If you want to create a model based on this connection, see Importing SAP BPC Data to a New or Existing Model.
    Note

    Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories. For details on scheduling, see Schedule a Publication.

Related Information