Cognos Analytics

 View Only
  • 1.  Generating Excel Report Driectly by Cognos Drill Through from Dashboard

    Posted Tue October 20, 2020 10:30 AM
    Hi,

    I want to call report from Cognos Dashboard through Drill Through and want to generate Excel Output directly. I have changed the format from report properties to Excel and when I run the report directly its generating the output in Excel. But when i am calling the same report from Dashboard Drill Through its opening in browser (as HTML) instead of Excel. I did not find any option at Dashboard level to set the property. Can you please suggest on it.

    Thanks,
    Danish

    ------------------------------
    Danish Iqbal
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Generating Excel Report Driectly by Cognos Drill Through from Dashboard

    Posted Tue October 20, 2020 02:13 PM
    Hi Danish - how about if you create a copy of this target report and set default output format as excel in report properties and try calling this copy report from your dashboard. 

    Thanks, 
    Sultan 





  • 3.  RE: Generating Excel Report Driectly by Cognos Drill Through from Dashboard

    Posted Thu October 22, 2020 01:39 AM

    Thank you Sultan for replying.

    I have tried this and when I am running report directly its generating Excel output but when I am calling same report in Drill Through from Dashboard its opening in browser instead of generating the Excel.

    Thanks,
    Danish



    ------------------------------
    Danish Iqbal
    ------------------------------



  • 4.  RE: Generating Excel Report Driectly by Cognos Drill Through from Dashboard

    Posted Fri February 10, 2023 05:44 PM

    Enhancement:
    Add output format option to drill through in dashboards

    https://ibm-data-and-ai.ideas.ibm.com/ideas/CA-I-3750

    Add your Vote.



    ------------------------------
    DEAN BLACK
    ------------------------------



  • 5.  RE: Generating Excel Report Driectly by Cognos Drill Through from Dashboard

    Posted Mon August 14, 2023 12:54 PM

    I voted - thank you!!  



    ------------------------------
    Darcy Stabile
    ------------------------------