Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Saving Report Output Outside of Cognos

    Posted Wed January 22, 2020 10:45 AM
    Hi,

    I am wondering if it is possible to specify more than one root directory for saving report output outside of Cognos?

    Based on the administration guide, I believe the answer is no.  I just want to be sure I am not missing some alternative.  :)

    TIA.

    #CognosAnalyticswithWatson


  • 2.  RE: Saving Report Output Outside of Cognos

    Posted Wed January 22, 2020 01:45 PM
    You can use Box.com to send reports outside Cognos. If you are using Microsoft Teams, you can also send outputs via email to it to save to a channel.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 02:56 AM
    Hi, 

    Do you have any link that you can share that shows how to configure saving report outputs to box.com? Is it possible to do the same to google drive or dropbox?

    Thanks

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------



  • 4.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 09:41 AM
    below is Youtube link for it:

    https://youtu.be/JkG2-VV-2zg

    Any Cloud storage Service which accept Email to store outputs should work with Cognos Email Feature. You can directly burst to Location Email Address.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 5.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 03:27 AM

    Solution: Use a Batch Command File on the Server.

    Users who wish to save reports directly in the file system must first have this functionality activated by an administrator.

    Yes, there is a restriction here: The administrator can only create a main directory in the Cognos configuration. Subfolders can then be defined via the Cognos administration interface.

    If it is now required that the reports are stored on different targets in the file system, we use classic batch files for this purpose. These are called up via the Windows Task Scheduler every 10 minutes and then copy the files into the final directories.

    The advantage: In the batch file, renaming can be done immediately or unwanted files (XML) can be ignored.


    ------------------------------
    Jens Bäumler
    Senior Consultant and Trainer
    Apparo Group
    ------------------------------



  • 6.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 02:55 PM
    Thanks Jens, exactly what I was looking for!

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------



  • 7.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 11:39 AM
    ​A simple solution would be to use symbolic links in the file system to direct the file and it's descriptor file to the proper location.

    ------------------------------
    Dax Lawless
    ------------------------------



  • 8.  RE: Saving Report Output Outside of Cognos

    Posted Thu January 23, 2020 12:56 PM
    This is very simple in 10.x. We haven't moved to Analytics, so I can't confirm the options are still available.
    https://www.ibm.com/support/pages/description-options-save-cognos-bi-report-output-filesystem. Look at option 1​ and maybe web search for "cm.OutputScript" I created a batch script which runs a Vbscript. Vbscript is easier to code than batch scripts. The code parses the xml and decides what to do. To make things easier for users, I created folders in cognos e.g. Location a,b and c. Users can create any folders they like in those locations e.g. location a\test\test2. The script parses the xml, retrieves the cognos folder location and then substitutes 'Location a' with for example a network drive e.g. h:. So the full path is now h:\test\test2.
    Note: The script runs for every report that runs, so you need to automatically clean up the output and xml's

    ------------------------------
    Trevor Fyfe
    ------------------------------



  • 9.  RE: Saving Report Output Outside of Cognos

    Posted Wed February 12, 2020 07:17 AM
    HI Jeremy ! if i correctly understand your query than
    --, you can save / schedule report outside Cognos via Administration Console.

    ------------------------------
    Hashim Raza
    ------------------------------