Create a Model

Objective

After completing this lesson, you will be able to create a model and set the model preferences.

In SAP Analytics Cloud, models are the backbone of Stories. A model is the clean and defined version of your raw data used to create the visualizations contained in your stories.

Note: SAP Analytics Cloud models support several different scenarios for dynamically working with monetary data from different currencies.

  1. A currency table has already been created for use in this workshop. You can locate it in the Files repository.

  2. To access the table, expand the Main Menu by selecting the Expand Navigation Bar icon.

  1. Select Files.

  1. Navigate to My Files > Public > Currency Conversions. Then select PnL100_CCT.

  1. The Currency Table contains currency details for 20 currencies.

Create Model

  1. We will now create our own model. From the main menu, select Modeler.

  2. Under the Models tab select the Model tile.

  1. Choose Start with an empty model and select Create.

Set Initial Model Preferences

  1. Under General select Model Preferences.

  1. Under General Settings:

    • Name the model PnL_AdminXXX (replacing XXX with your user ID)

    • Set Description to Profit and Loss AdminXXX

  1. Select Access and Privacy.

    • Select the Data Audit checkbox.

  1. Select Planning.

    • Check and ensure Date Dimension used for Planning is set to Date.

  1. Select Conversion.
  • Select the Currency Conversion checkbox.

Note

: This will highlight a missing Currency Dimension - we will add this later once created.
  • In the Currency Rates Table drop-down menu, select PnL100_CCT.

Note

: If the Currency table
  1. Select OK to close the settings dialog.

In SAP Analytics Cloud, models are the backbone of Stories. A model is the clean and defined version of your raw data used to create the visualizations contained in your stories.

Note: SAP Analytics Cloud models support several different scenarios for dynamically working with monetary data from different currencies.

  1. A currency table has already been created for use in this workshop. You can locate it in the Files repository.

  2. To access the table, expand the Main Menu by selecting the Expand Navigation Bar icon.

  1. Select Files.

  1. Navigate to My Files > Public > Currency Conversions. Then select PnL100_CCT.

  1. The Currency Table contains currency details for 20 currencies.

Create Model

  1. We will now create our own model. From the main menu, select Modeler.

  2. Under the Models tab select the Model tile.

  1. Choose Start with an empty model and select Create.

Set Initial Model Preferences

  1. Under General select Model Preferences.

  1. Under General Settings:

    • Name the model PnL_AdminXXX (replacing XXX with your user ID)

    • Set Description to Profit and Loss AdminXXX

  1. Select Access and Privacy.

    • Select the Data Audit checkbox.

  1. Select Planning.

    • Check and ensure Date Dimension used for Planning is set to Date.

  1. Select Conversion.
  • Select the Currency Conversion checkbox.

Note

: This will highlight a missing Currency Dimension - we will add this later once created.
  • In the Currency Rates Table drop-down menu, select PnL100_CCT.

Note

: If the Currency table
  1. Select OK to close the settings dialog.

Learning
SAP FacebookSAP YoutubeSAP LinkedIn