Import Data Connection to SAP Business ByDesign Analytics

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

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. 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 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. If you want to create a model based on this connection, see Importing SAP Business ByDesign Analytics 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.

Related Information