If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Automation ( running report using URL )

Started by jatin.popat, 27 Jul 2010 11:54:42 PM

Previous topic - Next topic

jatin.popat

Hi,

I have to write a batch file which would run a report using URL and then save it somwhere or to mail that report to the user so that the user can see the report output without running the report.

Its a weekly report so it would be run on sunday and the user should be able to see the report on the Monday without having to run the report.

I have implemented the first part, i.e, a batch file file is ready that would run the report using URL.
------------------------------------------------------
Approach :

I have 2 files IE.BAT and IE.VBS.

Contents of IE.BAT :
------------------

cscript.exe IE.VBS

Contents of IE.VBS :
-------------------

Option Explicit
Dim objIEA
Set objIEA = CreateObject("InternetExplorer.Application")
objIEA.Navigate "
http://snycd86m:80/cognos8/cgi-bin/cognosisapi.dll?b_action=cognosViewer&ui.action=run&ui.object=%2fcontent%2ffolder%5b%40name%3d%27Daily%20Snap%20Shot%27%5d%2ffolder%5b%40name%3d%27Sales%20Analysis%20Group%20-%20Monthly%20Reports%27%5d%2freport%5b%40name%3d%27Customer%20Investment%20-%20Historical%20Physical%20%26%20Digital%27%5d&ui.name=Customer%20Investment%20-%20Historical%20Physical%20%26%20Digital&p_StartPeriod=190&p_EndPeriod=190&p_Catalog=Catalog&p_LabelGroup=AS1&p_Label=&p_Artist=&p_Title=&run.prompt=false&run.outputFormat=PDF"
While objIEA.Busy
Wend
Set objIEA = Nothing

--------------------------------------------------------------

Now I need help to implement the second part ......

Even if some one idea for which I need to change the 1st part, plz let me know.......

It woudl really be of gr8 help to me........

twlarsen

Why not use event studio or schedule the report?  Am I missing something?

jatin.popat

#2
Actually we have a weekly report which my client used to run on every monday with different parameter values.

Now they want us to automate this process , i.e , to run the report using specified prompt values and save it some where or send an email to him.

And he dont want us to create 5 copies of the same report and then schedule each report.

Lynn

Try using a job in Cognos Connection. Include the same report 5 times and set the prompt values for each. Then schedule the job to run each week.