SATYA RANKI REDDY OBIEE SOLUTIONS

Oracle BI EE 11g – Calling JS Scripts

 

How to save the reports scheduled via Agents to a local directory using a simple JS Script:

 

JS Script Method:

 

var FSO = new ActiveXObject("Scripting.FileSystemObject");

var foldername = 'D:\IBOT'

if (FSO.FolderExists(foldername))
{
var fileName = foldername + "\\" +Parameter(1);
var fooFile = FSO.CopyFile(Parameter(0), fileName, true);
}
else
{
FSO.CreateFolder(foldername);
var fileName = foldername + "D:\IBOT"  + Parameter(1);
var fooFile = FSO.CopyFile(Parameter(0), fileName, true);
}

 

Or

 

We can convert vb script to Js script. Your wish !!!!

 

 

Please copy the above script in notepad then save as satyaexport_report.js then move to this file as mention below path.

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

 

Follow the steps.

 

 

 

 

 

 

Good Luck!!!!!!

 

 

Thanks,

Satya Ranki Reddy