Creating a Model from a Live Data Connection

Create a new analytic-type model from a data source in a connected system.

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.

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.

Procedure

  1. From the () Main Menu, select Start of the navigation path Create Next navigation step  ModelEnd of the navigation path.
  2. Select Start of the navigation pathGet data from a datasource Next navigation step Live Data connectionEnd of the navigation path.
  3. Choose a System Type.
  4. Then select a specific 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.
  5. Select the 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.
  6. Enter the Name and Description for the new model that will be created, and click OK.
  7. If you need to build a query, do so by dragging data from the Available Data list to the Selected Data and Filters areas.
    Select OK when you've finished building the query.
  8. If the data from your data source comes in different versions (Actuals, Budget, Planning, Forecast, Rolling Forecast), select the (Version Information) icon on the toolbar to specify the version information.

    Then, 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 will be automatically filtered on Actuals and you can create variance charts with the different categories.

  9. Save your model.

Results

Note

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.