Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Here is the summary of what is covered in this article:

This article covers the various ways to create analytic model, creation of analytic model from analytic dataset with input parameters for customization of data result, how to pass Input parameters from analytic dataset to analytic model, deletion of input variables in analytic model in SAP Datasphere.

Before we start with the article, here is some basic information about Input parameters and analytic models in SAP Datasphere.

Input parameters in SAP Datasphere

Input parameter is a run time parameter to generalize a model and customize the result of the model. For more details on how to create a analytic dataset with input parameters, please go through this.

What is analytic model in SAP Datasphere?

Analytic model in SAP Datasphere allows multi-dimensional and semantically rich analytical modelling to answer business questions easier, faster and more efficiently. For more details, please go through this.

How to pass Input parameters from analytic dataset to analytic model

Assuming that we have our analytic dataset with input parameters ready, lets proceed with creation of new analytic model with this analytic dataset.

Two ways to create analytic model

In the data builder, let’s start with creation of a new analytic model. A new analytic model can be created by using the new tile icon Analytic model.

Create Analytic Model from Data builder landing page

An alternative option is to open the analytic dataset and click on create analytic model from the properties panel.

Create Analytic Model from Analytic dataset

On creation of a new analytic model from a analytic dataset with input parameters, you are prompted with the option to choose the properties to be copied to the analytic model.

Import options for Input parameters from analytic dataset

For input parameters, you need to choose one of the options:

  • Map the input parameter to a new variable in analytic model. This is the default option. In this case, a new variable with same name gets automatically added in the analytic model. This newly added variable is of type input variable. You can go to model properties and check these input variables under variables section.


Input Variables in Analytic model properties

  • Set the value to input parameter. In this case, you need to enter a value for the input parameter. In case you need to change this default value of the input parameter, you can change it any time from fact model properties. In fact model properties, go to input parameters and choose the set value option for the required input parameter.


Editing Input Parameters in Fact model properties

If you create analytic model from analytic dataset properties, the above prompt for selection of input parameters would not be available. All input parameters are added to analytic model as input variables. If you do not need all these variables, you can keep only the variables required and delete the variables which are not needed. Deletion of variables is discussed in detail later.

Once you have chosen the required options for your input parameters, click on Preview to check the input variables and set the dynamic value for these variables.

Input Variables in Analytic model Preview

In the data preview of analytic model, use 'Set Variables' option to change the value of input variables. Please note that the value of input variable set using 'Set Variables' in data preview is only for checking the impact of variables in data Preview. It doesn't change the actual default value of input variable of the analytic model.

Deletion of Input Variables

As Input variables are mapped to input parameter, direct deletion of input variable is not possible. To delete the input variable, we need to remove the mapping between input parameter and input variable. To delete a input variable:

  • Go to fact model properties. Change the setting of the input parameter to from ‘Map to’ to ‘Set Value’ and enter a default value for input parameter.

  • As we have removed the mapping between input parameter and input variable, go to analytic model properties and delete the input variable.

Once satisfied with the analytic model, save and deploy the model. This deployed analytic model can be used to start building stories with Optimized Design Experience in SAC.

Now that you know about input variables in analytic model and using it in SAP Analytics Cloud Story, how about discovering more about SAP Datasphere? Explore our community topic page to learn more.

Hi prathibha.vadugu ,

Thank you for sharing. The reference date & filter variable are definitely my favorites. Here is also a link to the documentation. I was wondering if you have any plans to include the possibility of passing variables with multiple single values to the analytic dataset in future releases? It would be interesting to see how can it improve the efficiency of the model and have a direct impact on the logic. Are you planning to add the possibility to choose the variable order?

Kind regards,

0 Kudos

@wounky @prathibha_vadugu 

Have you found a way to edit the variable order?

Or is there a trick to manipulate the order (eg: last one added/last one edited/alphabetical on technical name)?

Have not found the logic behind the order up until now.

KR Simon

SAP Datasphere SAP Analytics Cloud