Alerter using object

[Former Member]

Hi All,

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?

Regards,

Manish Amin

[Former Member]

Hi

Not knowing your data that well, I can only suggest the following:

Create a variable "Checker":

=If([Instance Number] = [Blacklist Instance Number];1;0)

Then create an alerter based on Checker and the value 1.

Regards,

Mark