I have a requirement where i need to highlight Instance_Number which is used in multiple tabs in the WebI report. Now there is a table in the universe which contains blacklisted Instance_Number and is joined with the table from where the Instance_Number is coming from.
I have created an object which is mapped to blacklisted Instance_Number in the universe. And I need to compare it to the Instance_Number present in the existing report and highlight it if there is match between the blacklisted and the one present in report.
As it's object and not a hard code value, i need to pull it in the report and then create an Alerter. but when i try to see results it says query has been changed and need to purge data. But after purging and executing the report, it's not displaying data.
Am i correct in the way i am implementing an Alerter functionality in the report? Is there a way i can create it without pulling in the report?