Cognos Analytics with Watson

 View Only
  • 1.  report->transformation program->cognos email link

    InnerCircle
    Posted Wed May 19, 2021 04:25 PM

    Is there a way to run a report-> then have a python program to transform the report to text/csv with different delimiters -> then have Cognos send an email through the Cognos server with a link to the report? 

    I have the report built and the transformation program. I am a little lost as how I can get the file to be sent through the Cognos email server with the addresses defined on the report properties. 



    ------------------------------
    Philip Copeland
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: report->transformation program->cognos email link

    Posted Thu May 20, 2021 02:12 AM
    Hi Philip,

    why don't you concat the data items to a single column, using your custom delimiter? The resulting element would include a long string with all fields and can be executed as csv. You'd just use built in functions and avoid any need for external processing. 

    Regards, Frederik


    ------------------------------
    Frederik Spang
    ------------------------------



  • 3.  RE: report->transformation program->cognos email link

    Posted Thu May 20, 2021 07:07 AM

    Philip Copeland – a couple of options:

    1.    Create a 1 column report with and concatenate in a custom delimiter, you can then schedule and email report from Cognos server, then you do  not need Python at all for post processing.

    2.    Use the Cognos SDK to run the report, then process with custom delimiter, then email from Cognos SDK

     

    .

     

    Peter Chan

    613-295--0428