Importing S/4HANA Data to a New or Existing Model

You can create a connection that lets you import data from S/4HANA using generic OData services.

Prerequisites

You are using a supported version of SAP S/4HANA. For more information, see System Requirements and Technical Prerequisites.

Context

Note

  • SAP Analytics Cloud supports OData Version 4.0. Logical Operators (such as Equal, Not Equal, Less or Equal, Greater than, Greater than or Equal, Less than, Less than or equal, Logical and, Logical or, Startswith, and substringof) are supported for S/4HANA. Not logical negation, arithmetic operators, or functions are not supported. The following table lists the minimum requirements for S/4HANA OData services:

    Data Type

    Operator

    Format
    String (Edm.String)

    "eq", "ne", "startswith", "toLower","substringof", "gt", "ge", "lt", "le", "eq", "ne"

    "eq", "ne", "startswith", "toLower","substringof", "gt", "ge", "lt", "le", "eq", "ne"
    Number (Edm.Decimal)

    "gt", "ge", "lt", "le", "eq", "ne", "M"

    [value] m
    Number (Edm.Double)

    "gt", "ge", "lt", "le", "eq", "ne", "d"

    [value] d
    Number (Edm.Single)

    "gt", "ge", "lt", "le", "eq", "ne", "f"

    [value] f
    Number (Edm.Int16)

    "gt", "ge", "lt", "le", "eq", "ne"

    Number (Edm.Int32)

    "gt", "ge", "lt", "le", "eq", "ne"

    Number (Edm.Int64)

    "gt", "ge", "lt", "le", "eq", "ne", "L"

    [value] L
    Datetime (Edm.DataTime)

    "gt", "ge", "lt", "le", "eq", "ne"

    Datetime (Edm. DataTimeOffset)

    "gt", "ge", "lt", "le", "eq", "ne"

    Boolean (Edm.Boolean)

    "eq", "ne"

    True|False
    Edm.Guid

    "eq", "ne"

    guid'[value]'
    Logical Operator

    "and", "or"

  • Embedded Complex types are not supported.

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 Get data from a data source.
      3. Select SAP S/4HANA.
      Note
      From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source 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 Data sourceEnd of the navigation path.
      5. Select SAP S/4HANA.
      Note
      You can select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Select your S/4HANA connection or select Create New Connection to create a new connection. For more information, see Import Data Connection to SAP S/4HANA.
  3. Copy a query from an existing model (which you can edit before saving), 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.
  5. If you're creating a new query, enter a name for your query.
    1. Select a table, and then select Next.
      Note
      You can connect to services in the discovery service without having to create connections to all of the individual services.

      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.