Tuesday, October 2, 2012

Sending Emails Directly In OBIEE




Sending Emails Directly from a Request in OBIEE


They had a dashboard request that displayed the Employee name and their corresponding revenue numbers. Now they wanted to be able to click on the name of an employee and send an email to him directly from the report. Basically, clicking on the name should open up an outlook window (or the default Email client) with the address field populated with the employees email id like AVI@SSS.com. 



Let us see how we can implement this.

First let me create a simple request consisting of two columns, the Employee name and the Revenue measure.
  

Now Edit the column formula for Employee Name column and enter the following:

CONCAT(“D5 Employee”.”E01  Employee Name”, ‘@company.com’)
  


This will concatenate the Employee name with the text @company.com

Now in the column properties for Employee Name column, go to the Data Format tab and select Mail-to address in the drop down list for Treat text as selection.
 




Now when you run the report it should look something like this:




Now when you click on any name in the Employee column it should open up an outlook window with the address of the corresponding employee in the To field.


 

1 comment:

  1. hi all,

    this is ramesh,i am new to obiee,i developed one report and when i click the result button i am getting an error. the error is
    Error Message :
    Odbc driver returned an error (SQLDriverConnectW).
    Error Codes: OPR4ONWY:U9IM8TAC
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller or the secondary Cluster Controller () specified for the clustered DSN. (HY000)

    please help me.

    My mail id:skandaya83@gmail.com

    Thanks & Regards
    Ramesh.G

    ReplyDelete