Creating a Dataset from SAP HANA Data

You can connect to SAP HANA database views to create new datasets.

Prerequisites

Note
This help topic refers to acquiring SAP HANA data into an SAP Analytics Cloud dataset. For Smart Predict, you can create a live SAP HANA dataset (the data is not acquired; it remains in an SAP HANA table). For details, see: Connecting to Live Data in SAP HANA - Overview.
Note

Also for Smart Predict, you cannot consume the live dataset generated with predictions directly in a story. You need to create a calculation view and then create an SAP Analytics Cloud model on top of this calculation view. Then you can use this model in a story. For details, see Creating Calculation Views to Consume Live Output Datasets and Using Your Live Generated Dataset in an SAP Analytics Cloud Model.

  • The HANA database must first be set up by the system administrator. The HANA views in the database (analytic or calculation-type views) are available to create new models and datasets from.
  • You need to install the SAP Analytics Cloud agent, with location ID. This location ID is configured through the SAPCP Cloud Connector, and the agent needs to be allowlisted there. For more information, see:

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 HANA.
    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. Choose an existing connection, or create a new connection.
    For information on creating an SAP HANA connection, see Import Data Connection to SAP HANA.
  3. Type a name for your query.
  4. Choose whether you want to build a query, or type in a query manually.
    1. If you want to type in a query manually:
      1. Select Freehand Query.
      2. Type in your query.
      3. Select Next.
    2. Or, to build a query from scratch:
      1. Select Build a Query.
      2. Select a HANA view from the list, or search for a view by name, and then select Next.
        Restriction
        • Calculation views without a data category are not available.
        • Users need to have read access to the view (to execute a SELECT on the run-time object; for example, grant select on schema Schema123 to User123), and an appropriate analytic privilege (for example, _SYS_BI_CP_ALL).
      3. If the data source contains prompts, select values for them.
      4. Drag dimensions and measures into the Selected Data and Filters areas to build your query. Note that you can filter dimensions but not measures.

        See Building a Query for more information.

      5. Select Create when you're done.

Next Steps

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

If your HANA data contains location information, you will need to add location dimensions. For more information on live HANA data see Creating Geo Spatial Models from HANA Calculation Views. For information on acquired HANA data see Creating a Model with Coordinate or Area Data for Geospatial Analysis.

Related Information