Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Optional Report Date Prompts - does CA12 do this any better?

    Posted Fri June 30, 2023 09:26 AM

    In a report an optional date prompt looks like this:  

    By default the tick box is checked and today's date is selected. The tick box is used to show if the prompt is/isnt used. As the prompt is optional, if the user wants no date filter they have to uncheck this tick box.  Contrast that with every other prompt - optional prompts can easily be left blank by the report author.

    For the user of such a report they will find most optional prompts blank, but they have to go through and uncheck the date prompts. If they don't, then the report will be filtered to today's data.

    Even the date range prompt does this better. When a date range prompt is optional then early and late date are selected by default - all data. 

    Questions:

    1. Does anyone know how to make an optional date range prompt unpopulated by default?
    2. Does CA 12 do this type of prompt any better?



    ------------------------------
    Marc Reed
    ------------------------------


  • 2.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Fri June 30, 2023 09:54 AM

    Hi Marc,

    just checked with my CA 12 installation: nope! The behaviour is still the same, unfortunately. Even when your try to trick the prompt by setting a faulty default value, it still selects the current date as default. Nerve wrecking. One of the reasons why I use cascading dropdown prompts for dates...



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 3.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Mon July 03, 2023 03:10 AM

    Hi Robert, Is this even the case if you make usage of the new prompt defaults?



    ------------------------------
    Philipp Hornung
    Business Intelligence Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------



  • 4.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Mon July 03, 2023 03:27 AM

    Hi Philipp,

    I explicitly tested the new prompt page as well. Of course, when you define a default value (static, by data) this value is selected and the check box next to the prompt is also activated. I don't see any way (except java script/custom controls) to deactivate the check box by default when the prompt is optional.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 5.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Mon July 03, 2023 03:48 AM

    I have submitted an enhancement request for this. Looking at the web it feels like it's been a thorn in our sides for far too long. Please vote for this one!

    Optional Date Prompt Check Box



    ------------------------------
    Marc Reed
    ------------------------------



  • 6.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Mon July 03, 2023 04:10 AM

    Thanks for adding the idea. I voted.



    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------



  • 7.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Tue July 04, 2023 04:50 AM

    Hi Marc,

    It is probably not the answer you are looking for but it could be a valid workaround for you.

    If you change the Select UI in Edit box, you can clear the default date just before you click on Finish button.

    I'm been trying to change the default value without any chance (using the new Defining default parameter values feature in v12.0.0).

    Best regards,



    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    IBM Champion
    ------------------------------



  • 8.  RE: Optional Report Date Prompts - does CA12 do this any better?

    Posted Tue July 04, 2023 05:08 AM

    Alas, I think thats more steps than trying to teach 2000 users they have to uncheck the tick box. I think there are a few work arounds about - I just end up using a Value prompt rather than a calendar prompt.

    All because one prompt acts differently to every other prompt.



    ------------------------------
    Marc Reed
    ------------------------------