Create Analytic Applications in SAP Data Warehouse Cloud

As a user of both SAP Analytics Cloud and SAP Data Warehouse Cloud, you can create an analytic application starting in SAP Data Warehouse Cloud, either based on SAP Analytics Cloud space or SAP Data Warehouse Cloud space.

Integration to SAP Data Warehouse Cloud

There are several scenarios to work with SAP Analytics Cloud and SAP Data Warehouse Cloud. For further information, please see chapter Integration to SAP Analytics Cloud in the Integration Guide of SAP Data Warehouse Cloud.

Prerequisites

Please assure that the following conditions are made:
  • To use SAP Analytics Cloud within the context of a SAP Data Warehouse Cloud space (Space Aware Connectivity), SAP Data Warehouse Cloud and SAP Analytics Cloud need to be on the same tenant.
  • To use an SAP Data Warehouse Cloud analytical dataset, at least one live connection to a SAP Data Warehouse Cloud system needs to be configured in SAP Analytics Cloud.

Create an Analytic Application based on an SAP Data Warehouse Cloud Space

You can choose an SAP Data Warehouse Cloud space and navigate to SAP Analytics Cloud to create the application by selecting a dataset that is connected to the space and the space connection for a data-based widget such as table and chart.

Procedure

  1. Starting in SAP Data Warehouse Cloud, select the Files start page.
  2. Under Spaces select a SAP Data Warehouse space.
  3. In the menu bar select Start of the navigation path Create Next navigation step  Analytic ApplicationEnd of the navigation path.
  4. An upcoming dialog informs you that the application can't be created in SAP Data Warehouse Cloud and asks you whether you want to create it in SAP Analytics Cloud. Select Create.

    The analytics designer of SAP Analytics Cloud is displayed where you can start to create an application. In the URL header you can also see the space ID of the SAP Data Warehouse Cloud space you've selected in step 2.

  5. Insert a model-based widget like a table or chart.

    A dialog is displayed where you can select an analytical dataset that is connected to the space and the space connection.

  6. Select the dataset you would like to work with.
  7. Choose OK.
  8. Create the analytic application according to your needs.
  9. Save the analytic application.
  10. Select Run Analytic Application in the upper right corner.

    The application opens in another web browser window.

Creating an Analytic Application based on an SAP Analytics Cloud Space

You can choose the SAP Analytics Cloud space and navigate to SAP Analytics Cloud, where you can choose whether the table or chart in your application is based on an existing data model or on an analytical dataset. For the dataset option you're asked to select a configured connection, space and finally the dataset itself.

Procedure

  1. Starting in SAP Data Warehouse Cloud, select the Files start page.
  2. Under Spaces select the Analytics Cloud space.
  3. In the menu bar select Start of the navigation path Create Next navigation step  Analytic ApplicationEnd of the navigation path.
  4. An upcoming dialog informs you that the application can't be created in SAP Data Warehouse Cloud and asks you whether you want to create it in SAP Analytics Cloud. Select Create.

    The analytics designer of SAP Analytics Cloud is displayed where you can start to create an application. If an application is created in the SAP Analytics Cloud space, the space ID won't be shown in the URL.

  5. Insert a model-based widget like table or chart.

    An dialog is displayed where you have several options to select a model.

  6. In the Select Model dialog, select one of the options:
    • Existing Model

    • No Model (only displayed if you have selected a table widget)

    • SAP Data Warehouse Cloud Analytical Dataset

      If you decide to create your application from an analytical dataset, you first have to select a connection and a space.

  7. Choose OK.
  8. Create the analytic application according to your needs.
  9. Save the analytic application.
  10. Select Run Analytic Application in the upper right corner.

    The application opens in another web browser window.