Guys,
Need expert advice on this.
I have a report in OBIEE as follows.
Name Country Type
----------------------------
A123 United States X
B456 United Kingdom X
C234 Russia Y
D234 India Y
E231 Japan Z
T786 Newzealand Z
Now I want to setup Agent (iBot) in such a way that Type = 'X' records will always go to Email-ID1, Type = 'Y' records will always go to Email-ID2 & Type = 'Z' records will always go to Email-ID3.
Please note that Email-IDs are also stored in one of the tables in database.
Please share your thoughts. Any pointer towards resolution will highly appreciated.
Thanks
Gaurav