Monday, March 11, 2013

OBIEE 11g - Action link saving a report in local drive

Build a very simple report and an agent on it. As we are going to test it right away, make sure that the report returns TRUE value so that Agent will succeed for sure.
Here I have created an agent.













Open a notepad and add the javascript code and save the file with .js extension
ex- AB.js









In the above code , our aim is to save the output of the report inside the folder OBIEE in C drive.

Now put javascript AB.js inside - 

C:\OBIEE\instances\instance1\bifoundation\OracleBISchedulerComponent\coreapplication_obisch1\scripts\common










Now open the Actions tab of Agent and select "Invoke Server Script"















Language : JavaScript

Script path

C:\OBIEE\instances\instance1\bifoundation\OracleBISchedulerComponent\coreapplication_obisch1\scripts\common\AB.js

Define Parameters:

1> First Row:
     Name : 0
     Prompt : Parameter(0):
     Value : Delivery Content

2> Second Row:
     Name : 1
     Prompt : Parameter(1):
     Value : SAMPLE.pdf

Note : SAMPLE.pdf is the delivery content or the report; we are saving it in pdf format.You can change the format if you want to.

Now save the Agent and execute it manually.








Now let us go and search SAMPLE.pdf inside C:\OBIEE folder.This is delivery report in pdf format.