IBOTS are Intelligent Bursting and Output tool, used in OBIEE, They are triggered by a schedule or a condition to deliver reports to recipients.
Sometimes the business requirments are to deliver the Reports as an attachment, with Dynamic text and Subject/Header.
So here i am to discuss the solution to use Server Variables for fulfilling the request. Lets start with using a server variables in Ibot Subject/Header.
ABC @{NQ_SESSION.VariableName} and EFG @{NQ_SESSION. VariableName1}
Now to use a server variable in IBOT attachment note, is little different. Many places , many syntax are mentioned . But for me only this worked :
Sometimes the business requirments are to deliver the Reports as an attachment, with Dynamic text and Subject/Header.
So here i am to discuss the solution to use Server Variables for fulfilling the request. Lets start with using a server variables in Ibot Subject/Header.
ABC @{NQ_SESSION.VariableName} and EFG @{NQ_SESSION. VariableName1}
Now to use a server variable in IBOT attachment note, is little different. Many places , many syntax are mentioned . But for me only this worked :
ABC @{biServer.variables['NQ_SESSION. VariableName']} and
EFG @{biServer.variables['NQ_SESSION. VariableName1']}
So use it an provide more efficient solutions to your client !
Cheers :)