Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Prompt Page - Copy Paste from Excel and Not Loading Everytime

    Posted Tue December 15, 2020 02:24 PM
    Hi,
    I have two issues with my COGNOS 11 report's prompt pages.

    1. When I copy from excel and paste into a prompt list box, it will copy everything plus a blank at the end. So I have to push the backspace everytime or else it will bring back items that are blank in that field. COGNOS 10 didn't use to have this issue. Is there something I can add to the prompt's Detail Filter code that would prevent this from happening?

    2. At random times, when I try to go to one of my reports with a prompt page, the prompt page will not load correctly. Boxes will not load (look crushed), radio buttons will not populate, etc. If I "refresh" the page, it will sometimes prompt it fix it, but I have to refresh it several times. I use Internet Explorer 11 and Firefox. Anyone else experience this? Any solutions?

    Thanks!
    #CognosAnalyticswithWatson


  • 2.  RE: Prompt Page - Copy Paste from Excel and Not Loading Everytime

    Posted Wed December 16, 2020 09:19 AM
    Hi Steven,

    For #1, this was logged as a defect, but unfortunately was rejected.

    "We have considered this request and it would mean changing functionality that the customer base is already using and expecting to remain.
    We recommend the customer to use the new interactive viewer where the issue does not occur."

    As far as a workaround in the filter expression, I would have to try :)  If I figure it out, I'll let you know.

    Denise
    ​

    ------------------------------
    Denise Riou
    ------------------------------

    Original Message


  • 3.  RE: Prompt Page - Copy Paste from Excel and Not Loading Everytime

    Posted Thu December 17, 2020 02:46 PM

    Hi Steven,

    If the expression that you're using looks something like:

    [ISO_THREE_LETTER_CODE] in ?iso_3_prompt?

    then you could change it to:

    [ISO_THREE_LETTER_CODE]  <> ''   AND  [ISO_THREE_LETTER_CODE] in ?iso_3_prompt?
    However that would prevent you from ever finding the fields that have a blank in them.

    So the applicability of this may not be that great.

    // Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message