I have Parameter with Logical SQL. I have filtered the ID attribute using the Parameter binding. It is working as expected. No issues.
But after some my Logical SQL returns no values. So there is nothing to filter in Binding. For this case, filter is showing all IDs instead of No Data.
For example, Logical SQL defines for some open Bugs targeted for specific release. This Parameter is binding with ID attribute to show only open bugs returned from Logical SQL. It is working as intended.
After few days, when we nearing the Release, there is no more open Bugs. So Logical Query results is null. Since Parameter is Binding with ID and there is no values to filter, It is showing all values instead of “No Data”.
Any suggestion or workaround to display No data instead of all values.
IN OBIEE , it is working fine. I used to do SQL Expression to filter the IDs. If there is no vlaues, it display No Data. But OAC is not working as expected.
