Create a Model from a Live Data Connection

Prerequisites

A live data connection to another system is required. The system administrator will create live data connections using the Connections page in SAP Analytics Cloud. For a complete list of supported live data connections, see Data Connections.

If you want to perform geospatial analysis in your model, then you must manually prepare your data for geospatial analysis in the connected system using SAP HANA Studio.

Access to other systems is usually secured by user ID and password.

Context

Procedure

  1. From the Modeler start page, select Live Data Model.
  2. Choose a System Type.
    Note
    If you're creating a model from an SAP S/4HANA live data connection, choose the SAP BW system type.
  3. Select a live data connection.
    You will be prompted to enter the user ID and password to access the selected system. This makes a connection to the target system and reads the list of views that are available.
  4. Select a data source.
    If you know the name of the data source, you can type or paste it in. Or, you can select the icon to search for a data source or choose one from a list. The first 100 views are preloaded in the list.
    Note
    The model must be created based on a query or view that contains a measure.
  5. Drag data from the Available Data list to the Selected Data and Filters areas to build a query.

    Moving data to the Selected Data and Filters areas allows you to create new measures and dimensions to be imported to your model, and apply filters to them. For more information regarding query building and filters, see Building a Query.

  6. If the data from your data source comes in different versions (Actuals, Budget, Planning, Forecast, Rolling Forecast):
    1. Select the (Version Information) icon on the toolbar to specify the version information.
    2. Select the column from your data source that contains the version information, and then specify the relevant category for each version of your data, such as Actuals, Budget, Planning, Forecast, or Rolling Forecast.
    If you're using this model in a story, the data is automatically filtered on Actuals, and you can create variance charts with the different categories.
  7. Save the model.
    1. Select a location (for example, a private, public, or workspace folder).
    2. Provide a unique name for your model and an optional description.

Next Steps

If you have imported a model containing geographical data from an SAP HANA system, some geospatial analysis features such as map filters will be automatically disabled.

If you import a location-enabled model from a live HANA calculation view, you will need to add multiple location dimensions to the new model. For more information, see Creating Geo Spatial Models from HANA Calculation Views.

You can also create a model with coordinates and area data. For more information, see Creating a Model with Coordinate or Area Data for Geospatial Analysis.