Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Value Prompt default value set up in report

    Posted Wed May 22, 2024 06:11 AM

    Hi Team -

    on Prompt page i selected a Branch ID, on the report page we have a list and a Value Prompt (Drop Down), on report page we have list and a value Drop down, i would like to set a default Branch Manger Name in the highlighted area, on Value Prompt at Report Run. as Example, i need the Value of Branch Manager Name in the Value Prompt, instead of "ParamManager". any guideline highly thankful.



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


  • 2.  RE: Value Prompt default value set up in report

    Posted Wed May 22, 2024 06:34 AM

    Hi Hashim,

    don't know exactly what you're looking for.
    a) if you want to change the default drop-down headline from "ParamManager" to another text, select the prompt and go to the PROMPT TEXT properties:

    b) if you want a default data selection its this setting:

    Click the three dots and a new window pops up. Click the + icon and type in the default value which has to be the parameter value (not display text).

    If you are on Cognos 12 and you want your default parameter to be dynamic then use the new Parameter page described here:

    https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=reporting-defining-default-parameter-values



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 3.  RE: Value Prompt default value set up in report

    Posted Wed May 22, 2024 08:58 AM

    Hi Robert - Thanks for your guide line,

    I need to remove the title and dotted line from a value prompt. I have the following Javascript in an HTML Item to do it, its not working for me, we are using Cognos 12.0.1

    <script language="javascript">
    var f = getFormWarpRequest();
    var list = f._oLstChoicesPrompt1;
    list.remove(1);
    list.remove(0);
    list.options[0].selected = true;
    </script>



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



  • 4.  RE: Value Prompt default value set up in report

    Posted Wed May 22, 2024 09:29 AM

    Hi Hashim,

    I cannot tell you how to remove the second line fro the drop-down menu. I'm aware that in the past you could use Java Script to do that, but with the new interactive mode it's advisable to use custom controls. HTML items may break the report. I'm not an Java Script expert and can't point you to a better solution than overwriting the text heading as I've stated in my initial reply.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 5.  RE: Value Prompt default value set up in report

    Posted Wed May 22, 2024 09:32 AM

    Thanks Robert  for your response, its highly appreciated.



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



  • 6.  RE: Value Prompt default value set up in report
    Best Answer

    Posted Wed May 22, 2024 09:36 AM

    Maybe this link helps:

    How to remove the title and dotted line from a Value Prompt (ibm.com)



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
    Ingelfingen
    ------------------------------



  • 7.  RE: Value Prompt default value set up in report

    Posted Wed May 22, 2024 10:42 AM

    Thanks Robert - This is the best Answer for the solution.



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