Importing SAP HANA Data to a New or Existing Model

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

Prerequisites

  • 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. 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 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.

    • 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 HANA.
      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. 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. Copy a query from an existing model (which you can edit before saving), or create a new query.

    • To copy and edit an existing query, follow these steps:

      1. Select Copy a query from a model.
      2. Select a query from the list, and then select Next.
      3. Make your changes, and then select Create.

    • Or, to create a new query, follow these steps:

      1. Select Create a new query and select Next.
      2. Type a name for your query.
      3. If you want to type in a query manually:
        1. Select Freehand Query.
        2. Type in your query.
        3. Select Next.
      4. 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.

    You can continue to work on other tasks while the data is being uploaded in the background.

  4. When the draft data is finished uploading, open it from the Draft Data list (for a new model or dataset), or the Draft Sources list (for an existing model or dataset).

    The data appears in the data integration view.

Next Steps

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

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