Sending OBIEE reports to non OBIEE users who are external to SMTP server
876778Oct 5 2011 — edited Dec 18 2011Hi All,
Hi Nazza,
Would you please help me how you diid send reports to non OBIEE users (external mails)?
I have configured the mail server and able to send reports to internal mails.
I have followed the following steps as mensioned in all blogs:
1. I created a d table called SA_SYSTEM_USER with default columns as mensioned.
2. Imported into Physical Layer
3. Created a view for Dummy table(Dual) with 'DUMMY' column.
4. Joined these tow tables DUMMY fact and SA_SYSTEM_USER as Dimension on DUMMY join Email.
5. Renamed columnsfor Presentaion table as mensioned in Bolgs.
6. Restarted the servers.
7. I noticed the system mail and system delivery profile created with only one email id(where are the other email ids from my SA_SYSTEM_USER table?)
8. But as written in blogs it never sends emails to external mails e.g. abc.123@gmail.com(this is existng mail in SA_SYSTEM_USER)
I am in need of urgent solution please some one help me out....
Thank you so much.....