Hello
I am trying to schedule an agent for a report so that each recipient receives a copy of scheduled report based on their authority which is based on one specific column. ( department ID). Department Id is present as a column in the report.
Authority is already configured in RPD using session variables (based on department ID). Authority comes into play when a user belonging to any Department logs into OBIEE. They only see the rows relevant for their department (based on this session variable).
Now instead of users logging in and running these reports , I am trying to schedule this report so that a single agent is able to send out this report and each user receives a copy of the reports but with rows only for their department. Also I can only use recipients external email and not OBIEE user as recipients. So now RPD based authority can not be used for making sure that each user receives report with only their relevant rows (because its based on session variable whose value depends on the user who logs in to run the report)
I created a separate report "Agent Recipients" with username, useremail and userdepartment and added this as Agent->Condition.
Then I am trying to use "Get Recipients from the Analysis Used in the Agent Condition" and selecting "useremail" column to specify recipients.
Now how do I establish the relationship between userdepartment present in the condition report "Agent Recipients" and the department ID which is present in main report to be scheduled?
Thanks