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.
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.
Thank you for reading this blog post. Please leave a comment below in case you have any question or suggestion.