Skip to Content
Technical Articles
Author's profile photo Abhishek Patel
Abhishek Patel
September 28, 2021 2 minute read

Cascading Filter Prompts in SAP HANA Modelling

Cascading filters are a group of prompts where the selection of one filter regulates the list of values accessible for selection in the successive filters. The key intention for this cascading is to make sure a better user experience by providing users with valid combinations of input parameter values. This feature is liked by many customers as it allows them to have a preview of their data through prompts before essentially seeing the information.

For Instance: We have two filter prompts for our HANA calculation view Country and State filter, So if we select India as country in our first prompt so we’ll automatically get only states of India in list of values like below:

In this blog post, let’s look how cascading filters can be accomplished in SAP HANA views through mapping of Input Parameters. Here we’ll try to get corresponding week ending dates for a selected Year Month value.

For achieving cascading effect in calculation view say “ZTEST_CASCADE” we need one more view say “ZVALHELP”. Let’s first create value help view with 2 input parameters (P_YearMonth, P_WeekEnding) and allocate them as filters in projection node’s expression.

Later in our main calculation view “ZTEST_CASCADE” create 2 IPs and map End Date parameter with value help view as below

Once proper mapping is done apply filter expression and activate to test it. You will able to see only valid Week Ending dates corresponding to selected year month.

Thank you for reading this blog post. Please leave a comment below in case you have any question or suggestion.

Regards,

Abhishek

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Arjun K T
      Arjun K T

      Hi Abhishek ,

      Thank You for taking time to write this blog.

      There are few confusions regarding the screen shots in both the views.

      1. In the "ZVALHELP" Hana view IP_YearMonth input parameter from which CV "the help value" you have taken.
      2. In the ZTEST_CASCADE HANA view  , IP_YEARMONTH  from which Hana view the value help field selected.
      3. Could you please elaborate the  logic ,"when the date is selected from the ZTEST_CASCADE Input parameter , how will the date be passed to ZVALHELP Hana view and showing  IP_WEEKEND with the filtered data ?"

      Regards

      Arjun