Import Data Connection to SAP Business ByDesign Analytics

You can create a connection that allows you to import data from SAP Business ByDesign Analytics.

Prerequisites

SAP Analytics Cloud needs a Data Service URL to create a connection to SAP Analytics Business ByDesign. Before creating a new connection, check that the Data Service URL uses the right format in SAP Analytics Business ByDesign. For more information, check SAP Note 2913312 Information published on SAP site.
  1. Login to SAP Analytics Business ByDesign system.
  2. Navigate to Business Analytics, and select Design Data Sources.
  3. Search for your data source and click Build OData Queries.
  4. Click Generate Metadata Query.

    You should get the following URL: <system URL>/sap/c4c/odata/analytics/ds/<madav_ID>.svc/$metadata

    This query will run in the browser with technical user ID and credentials.

  5. Remove $metadata from URL.

    The URL should now be: <system URL>/sap/c4c/odata/analytics/ds/<madav_ID>.svc. Save that URL for step 5 in the procedure below.

Context

Note
While OData exposes one-to-many navigation, SAP Analytics Cloud cannot follow these relationships because doing so would distort the measures at the parent level. OData v4.0 supports Lambda operators “any” and “all”, which can reduce the collection of children to a single Boolean value. For this to work, both the server and SAP Analytics Cloud must support OData v4.0.

Procedure

  1. From the side navigation, choose Start of the navigation path 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 Business ByDesign Analytics.
  3. In the New SAP Business ByDesign Analytics Connection dialog, do the following:
  4. Enter a name and description for the connection.
  5. Enter the Data Service URL published during your configuration.
    Note
    All the parameters entered in the Data Service URL field are ignored in both authentication and data queries.
  6. Select the authentication type.
  7. Enter the User Name and Password of the user you want to import data from.
  8. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
  9. Repeat these steps for all the SAP Analytics Business ByDesign data sources you would like to leverage in SAP Analytics Cloud. Each data source must have its dedicated connection.
  10. If you want to create a model based on this connection, see Import Data to Your Model.
    Note

    Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories.

Related Information