Importing SAP Business ByDesign Analytics Data to a New or Existing Model

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

Context

For more information about extending SAP Business ByDesign using SAP Analytics Cloud, see Extending SAP ByDesign Analytics using SAP Analytics CloudInformation published on SAP site. Information about available data sources in SAP Business ByDesign can be found here.

Procedure

  1. Select the appropriate option:
    • If you're creating a new model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Start of the navigation pathGet data from a datasource Next navigation step SAP Business ByDesign AnalyticsEnd of the navigation path.
        Note
        From the acquire data panel, select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.

    • If you're importing into an existing model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step DatasourceEnd of the navigation path.
      5. Select SAP Business ByDesign Analytics.
        Note
        You can select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.
  2. Select an existing connection, or select Create New Connection to create a new connection.
    Note
    Advanced features of customized OData data sources, such as SAP Hybris Cloud for Customer and SAP Business ByDesign Analytics, are only available using customized data source types. These features are not available using generic OData services. It is highly recommended to use the relevant customized data source types, if available, for your data service to leverage full capability of the data connector. It is possible to request a customized OData data source solution.

    For more information, see:

  3. Copy a query from an existing model (which you can edit before saving), or create a new query.
  4. If you're using an existing query, select it from the list.
    1. If you want to make changes to the query, select Modify existing query.
    2. Make your changes, and then select OK.
  5. If you're creating a new query, enter a name for your query.
    1. Select a table, and then select Next.

      Build your query by moving data elements into the Selected Data and Filters areas. For more information see, Building a Query.

  6. Select OK.
    The data appears in the data integration view, where you can complete the mapping of your new data to the model's dimensions.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.