Skip to Content
Technical Articles

SAP DWC Input Parameters & Story Filters

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%20a%20Story%20Filter

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%20Story%20Filter%20as%20Range

Configuring Story Filter as Range

Configuring%20Story%20Filter%20as%20Single

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%20window

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%20values%20from%20clipboard

Managing values from clipboard

 

Or a member selector:

Member%20selector

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%20with%20all%20values%20selected%20%28left%29%2C%20Chart%20with%20custom%20filter%20values%20%28right%29

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%20Parameters%20in%20View%20Properties

Input Parameters in View Properties

 

 

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

Creating%20an%20Input%20Parameter

Creating an Input Parameter

 

Using IPs

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

Using%20the%20IP%20for%20filtering

Using the IP for filtering

 

Using%20the%20IP%20in%20a%20calculated%20field

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%20window

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%20a%20view%20with%20IP%20in%20another%20SQL%20view%20%28setting%20a%20fixed%20value%29

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

 

2222

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%20at%20Business%20Layer%20Entity

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%20default%20value%20at%20Perspective

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%20window

Variable window

 

Some SAC charts using IPs in calculated fields:

Sample%20of%20calculated%20field%20using%20IP

Sample of calculated field using IP

 

 

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

 

Best regards,

Xavier Polo

 

Be the first to leave a comment
You must be Logged on to comment or reply to a post.