Creating a Model Against OData Services in SAP Analytics Cloud

Prerequisites

You have configured a connection for OData Services in SAP Analytics Cloud.

Context

To create a story, you need to create a model. Proceed as described in the following steps:

Procedure

  1. To create a model, choose Start of the navigation pathCreate Next navigation step ModelEnd of the navigation path in the main menu.

    The options for bringing data into a model are displayed.

  2. To get data from an application, choose Get data from an app.
  3. To get data from an OData Service, choose OData Services.

    The Create Model from OData Services dialog box is displayed.

  4. Select the name of the configured connection.
  5. Choose Next.

    SAP Analytics Cloud retrieves data from the OData Service. Once the data is received, the New Query for OData Services dialog box is displayed.

  6. In the dialog box, select the business object that you want to add and choose Next.

    The available attributes for the selected business object are displayed.

  7. Drag and the drop the attributes that you want to use from the Available Data area to the Selected Data area.
  8. Choose Create.

    On the top bar of the application, the query for the business object is displayed.

  9. Choose the query.

    The Modeler / Data Integration screen is displayed, where you can modify the model before saving it.

  10. Save the model.

Results

You can use the data for the creation of stories on the retrieved data in SAP Analytics Cloud.