Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Cognos Analytics URL Run Report URL with parameter(s)

    Posted Thu November 23, 2023 11:22 AM
    Edited by Chris Bos Fri November 24, 2023 08:11 AM

    Hi,

    What am I doing wrong ?

    Trying to run a report from your browser with parameters what shouldn't show the prompt page, this should be possible.

    But when I try this, I still get the prompt page; how to run without the prompt page ?

    Report Name: Products

    Report Location: Team Folder/Samples/Reports

    Prompt Name: Product_Number

    Reading some documentation it should be like :

    https://[CA-Server]:[port]/bi?pathRef=.public_folders%2FSamples%2FReports%2FProductline&run.prompt=false&p_Product_Number=991&ui.action=run

    But when I try this, the report is running, but I get the prompt page with value 991 and I need to use the Finish button.

    Report has a prompt_page and the prompt is manatory.

    Tried different versions of CA

    How can I run the report without the prompt page ?

    Thanks in advanced.



    ------------------------------
    Chris Bos
    ------------------------------



  • 2.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Fri November 24, 2023 04:18 AM

    I guess you are using "old" parameter values (run.*).

    See https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=mc-creating-custom-urls-display-run-cognos-analytics-content for current options (11.1+), or https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=mc-creating-custom-urls-display-run-cognos-analytics-content for 11.0.

    I tried the following and this is working:

    http://cognos:9300/bi/?pathRef=.public_folders%2FSamples%2FTestreport&p_pPRDNR=101101&prompt=false&action=run



    ------------------------------
    Michael Haaß
    IBM
    Germany
    ------------------------------



  • 3.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Fri November 24, 2023 08:09 AM
    Edited by Chris Bos Fri November 24, 2023 08:09 AM

    Hi Michael,

    Ah, small different indeed.

    This was the solution, many thanks.



    ------------------------------
    Chris Bos
    ------------------------------



  • 4.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Fri November 24, 2023 04:20 AM

    Hi Chris,

    You need to clear the Report property: "Prompt for Values" and it will work, I did the test running CA 12.0.0:

    http://<server>/bi?pathRef=<path to report>&run.prompt=false&ui.action=run&ui.outputFormat=HTML&p_pYear=2013

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------



  • 5.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Sat November 25, 2023 02:48 AM

    Hi Patrick,

    Thank you for reply on my question.

    Allthough it working right now, what did you mean with "clear the prompt for Values" ?

    1. &prompt=false
    2. &prompt=true 

    are the only two I am aware of; are there more options ?

    Thanks in advanched.



    ------------------------------
    Chris Bos
    ------------------------------



  • 6.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Mon November 27, 2023 03:33 AM

    Hi Chris,

    This is a property in the report property page:

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------



  • 7.  RE: Cognos Analytics URL Run Report URL with parameter(s)

    Posted Wed November 29, 2023 06:11 AM

    Hi Patrick,

    I see; was thinking the option  &prompt=false would be doing that, but it's working.

    Do you know if it's also be posible to use the prompt value instead of using a static value ?

    static value:

    http://cognos:9300/bi/?pathRef=.public_folders%2FSamples%2FTestreport&p_pPRDNR=101101&prompt=false&action=run

    Selected prompt:

    http://cognos:9300/bi/?pathRef=.public_folders%2FSamples%2FTestreport&p_pPRDNR=?pPRDNR?&prompt=false&action=run

    or

    http://cognos:9300/bi/?pathRef=.public_folders%2FSamples%2FTestreport&p_pPRDNR=%ParamValue('pPRDNR')%&prompt=false&action=run

    or something like that ?

    Again thanks in advanced



    ------------------------------
    Chris Bos
    ------------------------------