Capturing mulitple values in BI session variable.

Saro

Hi friends,

I do want to capture a multiple name in my session variable, in which im using that session variable in my obiee alert agent email subject. Hence for that i created session variable(DISPLAY_NAME) and init-block like below

SELECT SA.DISPLAY_NAME FROM SA_SYSTEM SA, XXMP_HR_ANNIVERSARY_ALERT_V XXMP
WHERE SA.LOGON = XXMP.PERSON_ID OR SA.LOGON=XXMP.SUPERVISOR_ID 
AND SA.DISPLAY_NAME IS NOT NULL

And i have assigned the session variable DISPLAY_NAME to the above init-block and also made sure to check Row-wise initialization check box(to get multiple values)

Finally testing within the rpd, results in two names[within RPD]

Now im trying to refer this session variable DISPLAY_NAME  that carries two names to the email subject in my alert like below

Wishing @{NQ_SESSION.DISPLAY_NAME} Happy Anniversary

If i tried to fire the alert, im getting email without the mulitple name in the session variable along with the subject.

Suppose incase if my session variable is returning only one name, then there is no any problem as im getting that single name in my email subject that is getting fired through BI alert. Hence only for the multiple name im facing the issue.

What could be the missing factor?

Thanks in advance.

Regards,

Saro