Hi Guys
I have a basic req. but somewhere i am doing wrong and trying to know where i missed out. I m using Oracle Business Intelligence Product Version 12.2.4.0.0
This is regarding iBots where i have to send the same report to users listed in that.
Let's say the above is the custom report i got and requirement is Amar has to see in excel only his record, Akbar has to see in excel only his record,Anthony has to see in excel only his record. They should not see other records.
Created an agent --> running as recipient --> In Condition tab, created a condition --> In Deliver content tab, selected content = Condition Analysis, format = Excel 2007+ -->
In the recipient tab, selected the check box "Get recipients from Analysis used in agent condition" and in settings, selected "Email Id" column for Column containing Receipients
also selected the check box "Only Return Rows relevant to the user running the agent". Saved the Agent and ran the agent but getting all rows to everybody.
Can someone advise where i was wrong