Importing Entities with Semantics from SAP HANA Cloud

You can use the Import Entities wizard to import semantically-rich objects using your SAP HANA Cloud connection. The wizard creates Data Builder entities in SAP Datasphere.

Prerequisites

To import entities with semantics from SAP HANA, you must have a scoped role that grants you access to a space with the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Data Warehouse Connection (-R------) - To access remote objects.

  • Data Warehouse Data Builder (CRUD----) - To create, edit, and delete Data Builder objects.

  • Space Files (CRUD----) - To create, read, update, and delete objects in your spaces.

The DW Modeler role template, for example, grants these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Context

You can import entities from SAP HANA Cloud (see SAP HANA Connections). Calculation views and dimensions can only be imported as remote tables with the Import Entities wizard. Currently, you can import input parameters, currency and unit conversion, labels, and shared hierarchies. To ensure that your calculation view can be imported, deploy the calculation view in the source system with SAP Business Data Cloud Integration Mode set to Flat View or Construction Kit (see Preparing Calculation Views for SAP Business Data Cloud and Set the Business Data Cloud Integration Mode for a Calculation View in the SAP HANA Cloud, SAP HANA Database Modeling Guide for SAP Business Application Studio documentation).

Procedure

  1. Open the wizard from the Repository Explorer, Semantic Onboarding, or the Data Builder:
    • In the side navigation area, select (Repository Explorer), and select Start of the navigation pathImport Next navigation step Import EntitiesEnd of the navigation path.

    • In the side navigation area, select (Semantic Onboarding), and then select the appropriate tile.

    • In the side navigation area, select (Data Builder), select a space if necessary, and select Start of the navigation pathImport Next navigation step Import EntitiesEnd of the navigation path.

  2. Select your connection and target space:

    Semantic Onboarding

    Repository Explorer/ Data Builder

    Select the connection to the source you want to import from the list, and then click Next Step.

    You can use the Filter By pane on the left to filter the connections by space.

    1. Select the SAP HANA connection type, and then click Next Step.

    2. Select the connection/target space that you want to import the entities from/into, and click Next Step.

      If you opened the wizard from the (Data Builder), only connections in your current space can be selected.

  3. On the Select Entities page, select the entities that you want to import from the Results list, and click Next Step.
    Use the Search field to search by label. You can filter by:
    • View Type

    • Schema Name

  4. On the Review Entities page, review the entities that you will import.
    The left pane lists the entities you have selected for import and the right pane has two tabs listing all the entities that will be created in the SAP Datasphere Data Builder during the import of the selected entity.
    The following entities are created when you import entities with the most common modeling patterns:

    Source Modeling Pattern

    Data Builder Objects Created

    CUBE

    • Selected entity:

      • One view (Fact)

      • One remote table (Relational Dataset)

    Dimension

    • Selected entity:

      • One view (Dimension)

      • One remote table (Relational Dataset)

    Each object has the following read-only properties:

    Property

    Description

    Business Name

    Generated from the Label value.

    Technical Name

    Generated from the ID value as: remote.<connection_name>.<ID>.

    Import Status

    Specifies whether the object needs to be created in SAP Datasphere during the import:
    • Ready for Import - The object will be created.

    • Already Imported - The object has already been created during a previous import. If the structure or semantics of the object have subsequently changed in the source system, the object will be automatically updated and redeployed.

  5. Click Import and Deploy.
    A notification is sent immediately, and this notification will update as the import process continues. When the import is complete:
    • You have two notifications:

      • Click the first notification to see the imported entities listed in the (Repository Explorer).

      • Click the second notification to view the import log messages.

        If any entity could not be created, an error is given.

    • The imported entities are available for use in the (Data Builder).

  6. From the side navigation, choose Data Builder and create an analytic model from the Fact view (see Create an Analytic Model Directly From a View or Table).
  7. [optional] By default, data is only federated to your remote tables. To replicate the data, open the Data Integration Monitor (see Monitoring Remote Tables).