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

Output Report to PDF In File Structure?

Started by RobSil, 04 Feb 2010 04:11:13 PM

Previous topic - Next topic

RobSil

Is there no way to shedule a report to run (daily/weekly/monthly) and have that report sent to the file structure?  I'd like to have a shared folder into which my reports go vs. the COGNOS web interface.  I cannot find any reference to how to do this or any hints of how to do it by playing with the options under Report Center. 

My company uses a CMS where the reports are destined to go.

Thx,
Rob

MFGF

Hi,

See the Cognos 8 Administration and Security Guide, chapter 7, and the Cognos 8 Installation and Configuration Guide, chapter 11, for details of how to configure your Cognos 8 server to store saved outputs to the filesystem.

Also, do a search on this forum for CM.OUTPUTLOCATION - this should return a number of hits detailing the process.

Regards,

MF.
Meep!


RobSil

So after reading a few posts I did the following...

1. Ran the config program located at: <install dir>\crn\bin\cogconfigw.exe.
     - under this Config gui, I selected Local Configuration->Data Access -> Content Manager.  In this there was an option "Save report outputs to a file system?"  I set this value to be "true". 

2. I then opened up my WEB UI, logged in as Admin.
      - Tools -> Server Administration
         Type: Services, Chose Content Manager Service in dropdown list. 
       - Under actions, I chose More... then Set properties.
       - Clicked on the settings tab.
       - Edit under the Environment listing, and "Override the settings acquired from the parent entry"
        - A table then shows up.  I enter in the following values:
             CM.OutPutLocation => "R:\ReportCenterOutput\Reports"
             CM.OutputScript => "R:\ReportCenterOutput\PostoutputScript.bat"
     And hit OK.

I then run a report, choosing to "Save the report" but do not see a "save to file" option anywhere... should this be showing up somewhere?  I also double-check my output folder and do not see any new files.  Wondering if I havn't missed a step or something.

Also... if I reboot my server and double check my settings, the CM*** options are no longer visible.. is this the norm or a sign they are being wiped out?

Thx,
R.
       

MFGF

Quote from: RobSil on 08 Feb 2010 11:17:13 AMI then run a report, choosing to "Save the report" but do not see a "save to file" option anywhere... should this be showing up somewhere? 

Hi Rob,

No - the output should automatically be saved to the filesystem once you have completed these steps, restarted your Cognos8 service and you then run and save a report.

MF.
Meep!

RobSil

I solved my problem on this issue.  To share with others... I was hitting "ok" after entering CM.OUTPUTLOCATION/CM.OUTPUTSCRIPT, but you have to hit OK on the parent page also!!!!

I would hit OK, then click on other links to to return to the root.  You have to hit OK on TWO Pages for the settings to take effect. 

MFGF

Thanks for the update.  Glad you got it working!

MF.
Meep!