Below Crosstab shows the result set of Regulatory Compliance Days until expired at a Summary level for each Qualification Code. This data comes through a Summary Query.
Days until expired are segregated into range buckets i.e Over 90, 90-61, 60-31, 30-16, 15-6, 5-1 and Expired, which are all defined as keyfigures in the backend.
So now, when the business wants to get into the details from the summary level, we have enabled them to click on the desried days range and it takes them to a details crosstab with a filter on Qualification Code.
I have developed two separate detail queries in the backend which have the deatail level information of the days until expired from Over 90 bucket through 5-1 bucket and for the expired bucket we have a sperate detail query.
The application will jump the user to the respective detail screen based on the selection made i.e click on respective bucket.
Inorder to achieve this interaction, I have created two querys Q1 and Q2 and for Q1, I have set a condtition in the query based on the Key Figure ZFORDAYS. The condition is defined as ZFORDAYS between ZVAR_DAYS_LOW and ZVAR_DAYS_HIGH which are nothing but manual entry formula variables created to serve the purpose.
Now, in the design studio for the Summary Crosstab’s “on click” event, we have to write the script as shown below
Query 1 and Query 2 are set up as Pages of a PageBook component in design studio.