SAP Design Studio - Working with Filters

Filters are used to limit the data in visualization in SAP Design Studio. You can create different types of filters and use analytic components and basic components to set up filters.

Setting up an Analytic Component as a Filter

To set an analytic component as a filter, you need to enable the selection that allows the user to select the individual component.

Analytic Component

Select Analytic component → Properties Pane, under Events Enable → True. Go to Onset to add a script to this event. You can use the setFilter script method to set the filter.

In the script, you need to select the Data source, scripting method, dimension and value.

Enable Selection 

DS.setFilter(“00_Sold_To”, CROSSTAB.getSelectedMember(“00_Sold_To”).internalkey);
Value

Save the application and run it locally. Select the Sold to Party component.

Sold to Party

You can also set up a basic component as filter in the similar manner.

Adding a Dimension Filter

To add a dimension filter, select a filter from the analytic components and drag it to the canvas area.

Adding Dimensions

Go to the Properties tab of the Dimension filter → Data Binding. Then Under Data Binding, select a data source.

Go to dimension, and select the dimension on which you want to apply the filter.

Data Binding

Select the Data source and dimension as shown in the following screenshot and then save the application.

Dimension

Once the application is saved, then you can run the application locally.

Save and Run

Category

Click on the dimension Filter and you will be prompted to select a dimension value from the available list. You can also go to the range tab to put a start and end value.

Selection and Range

Once you select the dimension, data in component is filter accordingly. To apply the filter settings, click on the Apply button.

Apply Filter

Editing a Filter

To edit a filter in SAP Design Studio, go to the Outline tab and under the Layout folder. There you can see a list of all the filters that are applied in an application. To edit an application, select the filter you want to edit.

Editing Filter

Go to the Properties tab of the selected filter and make changes as required. Save the changes that you have made and run the application to reflect the changes.

Property Tab

Removing filter

To remove a filter in an analysis application, go to Outline View → Layout. Select the filter you want to remove. Right click and you will get all the following options.

Remove Filter

Click on Delete to delete the selected filter as shown in the above screenshot.

You can also Copy, rename or check reference of each filter in an analysis application from here.

Advertisements