Importing SAP Integrated Business Planning Data to a New or Existing Model

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 Integrated Business PlanningEnd 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 Integrated Business Planning.
        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.

    If you create a new connection, you can select the following options:

    • Connect to an On-Premise OData service
      Note

      To connect to an On-Premise OData service, ensure that the following tasks are completed:

      1. The cloud connector is installed. For more information, see Installing the SAPCP Cloud Connector.
      2. The cloud connector is configured. For more information, see Configuring the SAPCP Cloud Connector.

      The SAP Analytics Cloud agent doesn't need to be installed during the configuration process.

    For more information, see: Import Data Connection to SAP Integrated Business Planning.

  3. Choose whether you want to copy an existing query, or create a new query.
  4. If you're copying an existing query, select it from the list, and then click OK.
    1. Make changes to the query, and then click Create.
    2. Skip to step 6.
  5. If you're creating a new query, enter a name for your query.
    1. Select Build a Query to build a query using the query builder, or Freehand Query to manually type a query using V2 OData query syntax.
    2. If you chose to use the query builder, select a table, and then select Next.

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

    3. If you selected the Freehand Query option, type a query in the box and select OK.

      For example, the following query lets you get the product by rating:

      Sample Code
      KeyPredicate:
      Categories(1)/Products?$format=json&$select=Name ,Category/Name,Supplier/Name,Supplier/Address&$expand=Category,Supplier&$filter=Supplier/ID eq 0
      FunctionImport:
      GetProductsByRating?rating=3&$format=json&$select=Name,Rating,Category/Name,Supplier/Name,Supplier/Address&$expand=Category,Supplier
      
      For more information on the OData query syntax, refer to the OData documentationInformation published on non-SAP site.
      Note

      SAP Analytics Cloud has the following validation rules for freehand queries:

      • Duplicated parameters ($select, $expand, $format, $top, $skip, $inlinecount, $filter) in the query are not allowed.
      • Only entity set and function import are supported.
      • For function import, entity set is only supported as a return type.
      • If $select contains the Nav property but without $expand property, the query is invalid.
  6. Select the appropriate option:
    • If creating a new model: In the Draft Data dialog, select the dataset that you just uploaded.
    • If importing to an existing model: In the Draft Sources list, select the dataset that you just uploaded.

Next Steps

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