How to use Server Variable in IBOTs/Delivers/Agents to show Dynamic text in OBIEE 11g/12c

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 :

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 🙂

OBIEE : Go Nav/ Go URL structure

The Go URL or Go nav is functionality of OBIEE, where summary reports  navigate to detail reports passing filters/options.

For example:

1) Basic structure:

http:///analytics/saw.dll?Go&path=

2) To pass username and Password

http:///analytics/saw.dll?Go&path= &NQUser=&NQPassword=

 3) To include Report links

Actual way to include the report links in drill/detail reports is to mention “&Options=x” in  GO URL path. The x can be one or more of the following letters:

• m = Modify Request
• f = Printer Friendly
• d = Download to Excel
• r = Refresh Results

 Like:  http:///analytics/saw.dll?Go&path= &Options=md

or

http:///analytics/saw.dll?Go&path= &Options=mfdr

4)  Printer Friendly. Results are in a printer-friendly format, without the paging controls, hot links, and so on.This is the format, “&Action=print” to be added in GO URL path

Like: ttp:///analytics/saw.dll?Go&path= &Action=Print

5) Specific View. If your Detail report has more than 1 view of results (like Pivot/Chart/Bar graph etc) . This option shows an individual result view rather than the default compound view.
This is the format, where A is the name of the view:

http:///analytics/saw.dll?Go&path= &ViewName=A

 6) To pass report filters:

Sometimes we get requirement in OBIEE summary report to drill to detail report passing few column filters, like: here we are passing 2 column values as filter in detail report. P0 defines the number of parameter passed including the type (equal/ >=  etc.)

http:///analytics/saw.dll?Go&path= &Action=Navigate&P0=5&P1=eq&P2=&P3=&P4=&P5=

Note: Remove symbols. I have used them to highlight.