Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor
In the latest DWC update (2021.11.7) some new features have been added, such as Input Parameters.

We can use Input Parameters to filter views in a similar way as we do with Story Filters. But what are the differences? First let's review the Story Filters.


Story Filters


Defining Story Filters from View Editor

In an analytical view we can identify any attribute as a Story Filter, so that in SAP Analytics Cloud the user will see a window to filter values.

Creating a Story Filter from Attribute


In the configuration we can set:

  • If it is a range of values, or if it is an independent value or values.

  • If it has a default value

  • If it accepts multiple entries (ranges or values).

  • If it is mandatory for the user to fill it in


Configuring Story Filter as Range

Configuring Story Filter as Single


Opening a SAC Story with a view with Story Filters

If a view has Story Filters and/or Input Parameters, the user will be prompted to fill them using the variables window.


Variable window


The NameCountry is the Story Filter set previously.

Story Filters have helpers to fill them, like clipboard icon to allow us to paste values

Managing values from clipboard


Or a member selector:

Member selector


After making the selection, we will be able to see that the data in our Story is filtered. We can configure these filters to be applied in the same way in the whole story or leave some graphs to have their own values in the variables (customized with {} button)


Chart with Story Filter (left), Chart with custom Story Filter values (right) in the same SAC Story



Input Parameters (IP)

In the analytical view (SQL and Graphical) we can create Input Parameters, which like the Story Filters will also be requested to the user in SAC, but the difference is that we can use the IPs not only to filter data, but also to perform operations with them.

Creating an IP

From View Properties there are a new section called "Input Parameters", from where we can manage them.

Input Parameters in View Properties



From here we can create, modify or delete the IPs:

Creating an Input Parameter


Using IPs

After creating the IPs, we can use them in our view:

Using the IP for filtering


Using the IP in a calculated field


Another difference between IPs and Story Filter is that when we use a view with IPs inside another view we can map the IPs to a fixed value or to an IPs from the "caller" view (this is not possible with "Story Filters")

In the case of graphical views, when we drag and drop a view with IPs it asks us if we want to associate an IP from "caller" view or if we want to assign it a fixed value.

Map IPs window

This option allows us to pass values from view to view as we would pass parameters from method to method if we were programming

In the case of SQL views, when dragging the view with IPs, the name and IPs will appear in HANA SQL notation.

Using a view with "BP_CAT" IP in another SQL view and setting a fixed value "2"


Using a view with "BP_CAT" IP in another SQL view and setting "PARAM_1" IP from caller view


IPs - Business Builder

Input Parameters has also support at Business Builder, and they are referenced in several places.

First at Entity and Fact Models, we can decide whether to expose IPs to users in the Business layer. If the dimension or analytical dataset is based on a view with IPs, we can indicate which ones we want to expose and which ones we do not.

IPs at Business Layer Entity


After that in Consumption Models and Perspectives, allowing us to set a default values for each IP and Perspective:

Set default value at Perspective



IPs in SAC Story

Unlike the Story Filters, the IPs are shown to the user as a text box to be filled in, without any help.

Business Partner Category is the IP

Variable window


Some SAC charts using IPs in calculated fields:

Sample of calculated field using IP



We have been looking forward to this IPs feature, so enjoy it!


Best regards,

Xavier Polo

Labels in this area