Creating a Dataset from SAP S/4HANA Data

You can import data into a dataset from SAP 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. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select 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.
  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. Type a name for your query.
  4. 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.

  5. Select Create.

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

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.