Hi friends,
Im in the process of sending the dynamic emails to the users using alerts in bi 11g. The content that i need to send as a attachment is the dashboard page in which that page contains the employee name as a prompt in that page.
So my alert has to fire to the users with their particular record in the dashboard page. Assume like in a dashboard page i have simple report like two columns say
Emp no and Emp name
and in this page i have Emp name as a prompt.
So i need to send this report that is, in the dashboard page with their particular name as been prompted, so that the users will get only their particular record as a attachment in the email.
For this i have created a session variable called HOME_USER and the session initialization block like HOME_USER_INIT with the below query
SELECT PAPF.FULL_NAME
FROM PER_ALL_PEOPLE_F PAPF
PAPF.EMPLOYEE_NUM = ':USER'
And also in the dashboard page prompt for the employee name i referred the session variable like below
SELECT "New Fact1-Payroll"."Full Name" FROM "6-HR-Payroll" where "New Fact1-Payroll"."Full Name" = VALUEOF(NQ_SESSION.HOME_USER)
So now, if i logged in as a employee number say '1' in which i already has this '1' as a user in BI and if i navigate to my dashboard page then i can see the respective employee name is populated in the prompt according to the employee number '1' the user that is logged in and i can see the restricted rows in that report in dashboard page. So as for, now the session variable is working correctly as it is restricting the prompt according to the logged on user.
Now @ last i create alert in sending this attached dashboard page as email to that respective user like below
In condition i have given one report with rowcount > 0 and in that report i have taken the employee id and email and i have a filter for that employee id as '1'. so now this report has employee id '1' and his corresponding email address.
Then in the delivery contents i have attached the respective dashboard page and then in the recipient i have checked use Analysis and in the column containing recipient i have selected the employee id column. Now if i save and if i run the alert then im getting the below error like
Im getting the above issue. Im not sure what im missing. Also need to ensure whether the steps that i followed is right. Here in this case im not using any SA related subject Area.
What could be the reason for this issue friends.
Thanks in advance.
Regards,
Saro