Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Save Excel\PDF in local drive

    Posted 12/19/24 08:48 AM

    Hello Everyone.

    I have created a job that has 2 reports and have scheduled the job.

    I want to save the reports in Excel and PDF Format in D drive once the job has successfully executed.

    Is there any setting that I can do that it happens automatically and I dont need to download the reports manually and save it?

    Is this possible?

    Regards,

    Andila

    Regards,

    Andila



    ------------------------------
    Andila Haque
    ------------------------------


  • 2.  RE: Save Excel\PDF in local drive

    Posted 12/20/24 01:39 AM

    Hello,

    Yes, it's possible 😊

    https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=archival-creating-file-location-file-system-repository

    Have a nice day



    ------------------------------
    Cedric Waras
    ------------------------------



  • 3.  RE: Save Excel\PDF in local drive

    Posted 12/20/24 04:55 AM

    Thank you so much for your reply. I will look into this.

    Regards,

    Andila



    ------------------------------
    Andila Haque
    ------------------------------



  • 4.  RE: Save Excel\PDF in local drive

    Posted 12/20/24 02:12 AM
    Yes, this is possible. Your administrator needs to enable the "Save to Filesystem" option in Cognos Analytics. Once activated, file paths can be configured for different user groups. For example, a network drive can be set up where individual departments have subfolders to store their files directly.
     
    This feature becomes available as a new option in the scheduling or job settings. If you need the files locally (e.g., on your D-drive), you might need an additional copy job to retrieve the files from the network location. However, using the network drive can achieve the same outcome.
     
    This setup is managed through the Cognos Analytics Administration console.
    Jens


    ------------------------------
    Jens Bäumler
    Cognos Analytics, Planning Analytics and watsonx
    Apparo Group
    Germay
    www.apparo.de
    ------------------------------



  • 5.  RE: Save Excel\PDF in local drive

    Posted 12/20/24 04:55 AM

    Thank you so much for your reply.

    Regards,

    Andila



    ------------------------------
    Andila Haque
    ------------------------------



  • 6.  RE: Save Excel\PDF in local drive

    Posted 12/26/24 08:33 PM

    Additionally, saving report outputs and you can create/run a script after the output been saved. In this script you may create a FTP transfer for your computer, for example.

    CM.OutputScript: https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=output-saving-report-files-in-cognos-software



    ------------------------------
    JEAM COELHO
    Cognos Solution Architect

    LinkedIn: https://www.linkedin.com/in/jeamcoelho/
    ------------------------------