I'm trying to use alert monitor in web application designer to show two queries with red, green and yellow statuses. In my web template, I have inserted two queries in two tables (both queries have exceptions) and alert monitor as web item. In properties(context menu), I choose infocube on which these queries are build,marked the red, yellow, green status ,mentioned them in list of columns entry and checked the display toolbar entry.
When I execute , It shows the display of alert monitor drop down box with functions (from Info provider, info area, queries..etc) and alert boxes for red, yellow and green. If I check on red box and uncheck other boxes, still I'm seeing all records with other status as well. There is no change in the query result if I switch from red , green or yellow. And also I am not seeing how many rows of red , green or yellow alerts which i should as i have selected in the list of columns entry.
I've set the exceptions in Reporting Agent for these two queries also.
Any Idea why I'm not getting the functionality of alert monitor. Do I need to set up something for alert monitor to work in reporting agent or in alert management in order to use .Am i missing something in configuration
Any ideas and solutions..
Thanks in advance,