In Dashboard I need to filter a report with one interactive filter(cascading), both are using different tables, and no common fields between 2 tables.
I need to filter "Remediated Alerts" report where we are using "em_alert_management_execution" table.
for cascading filter Lob we are using custom table "u_per_lob" table.
In both the tables we don't have a common field to directly filter.
Somehow I need to filter based on one field from interactive filter (table used= "u_per_lob", based on u_lob field) with the report (table used= "em_alert_management_execution", based on action name field).
We have 13 Action names. We have around 10 u_lob, but we need only 3 u_lobs as for only 3 lobs we are using action names.
If u_lob field is A, it needs to filter/map to only 1 particular action name.
If If u_lob field is SR, it needs to filter/map to only 11 particular action name.
If If u_lob field is HX, it needs to filter/map to only 1 particular action name.
For other values from u_lob other than mentioned above three (A,HX or SR), the report count needs to be zero.
Does anyone has an idea how we can approach this.
