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.  report->transformation program->cognos email link

    Posted 05/19/21 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 05/20/21 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 05/20/21 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

     






Related Content