Cognos Analytics

 View Only
Expand all | Collapse all

Release 11.2.4 of Cognos Analytics Webinar

  • 1.  Release 11.2.4 of Cognos Analytics Webinar

    Posted Tue November 29, 2022 08:19 PM
    Edited by System Fri January 20, 2023 04:29 PM
    Summary
    Hello Everyone,

    The latest release of Cognos Analytics 11.2.4 is coming soon! Rachel Su, along with the rest of the product management team are excited to show what's new!
    Here are the highlights of what's in the new release:
    • Natural language generation in dashboards 
    • Additional datasource connections 
    • Rendering Maps in PDF and Excel 
    • Improved PDF output in dashboards 
    • Report rendering in Microsoft Teams
    Join our Cognos Release 11.2.4 technical overview webinar on Tuesday, January 10th at 11AM ET.

    Register here. Looking forward to sharing the latest on Cognos!

    Please join us in this on-demand recording. Share your questions below and register to watch here.


    ------------------------------
    RACHEL SU
    ------------------------------
    #CognosAnalyticswithWatson


  • 2.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Wed November 30, 2022 07:59 AM
    This registration and resulting calendar invite is for Tuesday January 10th 2023 at 11 am.  Why does the announcement reference Dec 15th in this case as well as the January date?  Very confusing!



    ------------------------------
    Shawn Lamson
    ------------------------------



  • 3.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Wed November 30, 2022 08:54 AM
    Edited by System Fri January 20, 2023 04:26 PM
    Hi Shawn,

    The official date for "Cognos Release 11.2.4 technical overview webinar" was announced during the started "Ask-Me-Anything: Cognos Analytics - Nov. Edition Webinar" is:
    Tuesday, January 10th, 2023 at 11AM EST.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 4.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Fri December 02, 2022 05:35 PM
    Rachel now edited her post to remove the reference to December 15th entirely... thanks for correcting that!

    Shawn

    ------------------------------
    Shawn Lamson
    ------------------------------



  • 5.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Mon December 05, 2022 11:43 AM
    Hello Rachel,

    Quick question. Is v11.2.4 is LTS? 

    Thanks!
    Vithal

    ------------------------------
    Vithal Madhira
    ------------------------------



  • 6.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Mon December 05, 2022 11:53 AM
    Edited by System Fri January 20, 2023 04:37 PM
    Hi Vithal,

    Obviously, I am not Rachel.

    Cognos Analytics v11.2.4 (expected in a couple of weeks) is going to be LTS (Long Term Support Release).

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 7.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Mon December 05, 2022 12:23 PM
    Patrick, Thank you for the inputs! Appreciate it.

    ------------------------------
    Vithal Madhira
    ------------------------------



  • 8.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Fri December 16, 2022 12:24 PM
    FYI: Cognos Analytics 11.2.4 4 is out and ready for download. A great new LTS version.

    Jens

    ------------------------------
    Jens Bäumler
    Senior Consultant and Trainer
    Apparo Group
    ------------------------------



  • 9.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Tue December 20, 2022 04:25 AM
    Hi,

    To complement Jens's thread, a new PowerPlay release is also available.

    Entitled Bundled Customers can use this link Cognos PowerPlay Server to get access to download Cognos PowerPlay Server 11.2.4-22100709

    IBM Cognos Analytics PowerPlay v11.2.4 is Long Term Support Releases (LTSR) and provides standard support for a minimum of two years with an available one-year extended support option to provide coverage for a total of three years minimum.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 10.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Tue January 10, 2023 10:57 AM
    Hello,
    With regards to Report Studio in 11.2.4, it appears that the function to export a report to a different format is now separate from the "Run As..." triangle icon. The ability to trigger output to another format is also active/selectable on report Prompt pages -- not sure I understand why that would be, but more importantly, if a user selects one of those report output options before making selections from the prompts on the prompt page, Cognos generates a default prompt page for the parameter values, and this gives the user the opportunity to enter ANY value(s), bypassing security (filters on the prompt queries) I've placed on the parameters on the prompt page.
    Is there a way to disable this feature (exporting to other formats) on the RS prompt pages?



    ------------------------------
    Mike Comiskey
    ------------------------------



  • 11.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Thu January 12, 2023 04:34 AM
      |   view attached
    CogBox has an "Export Report" control. You select it and it will create a button that you can use to export your report to any format. Stick it on the prompt page and you can set it to use the selected values of prompts on the page. 



    Clicking on the excel button will generate this output:



    And then changing the prompt:


    generates this:

    Best thing is that it's one of the free controls. (Really not trying to sell here, just happy to have a solution for you.) https://pmsquare.com/cogbox

    I've also attached the report xml from the screenshots above.

    Important note though! When you run the report from report studio it will error out if you try to use the export button, you have to run it from the portal. This is because report studio doesn't pass the search path information of the report when it runs.

    ------------------------------
    Paul Mendelson
    ------------------------------

    Attachment(s)

    txt
    export report example.txt   15 KB 1 version


  • 12.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Thu January 12, 2023 12:13 PM
    Hi Paul, I note in the first screenshot you shared that the "HTML" still appears to the right of the blue triangle/play icon, and I'd guess that if a user clicks on that from a prompt page not having made prompt selections, Cognos prompts the user to enter prompt values in a default prompt interface?  For me, that's the problem -- many of my reports have filters placed in prompt queries tying users' roles to available prompt selections; for example, depending on the user role, user X should only see 'Mountaineering Equipment' in the prompts and not see 'Personal Accessories.'  If the user clicks on the HTML link on the prompt page right away, they could enter/select 'Personal Accessories' in the default prompt interface, and then get those results. 
    (I'm surprised the 'Select a format' option is active/selectable on the RS prompt page.   The "Run" option isn't active, which is good IMO).
    I have opened a support ticket with IBM, and I'll see what happens there.  I think I could roll back to 11.2.3 but I'd been looking forward to the 11.2.4 release.
    Thank you for your time and your reply, sincerely appreciated.

    ------------------------------
    Mike Comiskey
    ------------------------------



  • 13.  RE: Release 11.2.4 of Cognos Analytics Webinar

    IBM Champion
    Posted Fri January 13, 2023 02:11 AM
    Can you set the default values of the prompt to match the user security? The queryValues macro may be very useful here. In general I always try to avoid prompt pages as I feel they are security risks.

    Also, you can force Cognos to load a value prompt instead of a text prompt if the user tried to bypass the prompt page like that.

    #prompt(
    ​'param name'
    , 'datatype'
    , queryValue expression
    , ''
    , 'source for generated prompt' )#

    ------------------------------
    Paul Mendelson
    ------------------------------



  • 14.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Fri January 13, 2023 11:49 AM
    In working with IBM on the support ticket, it seems that the problematic behavior I've noted (that a user hitting the 'HTML' function on the prompt page triggers a set of Cognos default prompts to appear) may have something to do with the version of the report spec, or an upgrade issue with the report spec.  I tried creating a brand new report in 11.2.4, and did not observe the issue.  I have other reports (dozens created in Cognos10, a couple created in 11.[don't remember]) that do display the issue.  As an test, I found I could take one of those reports, copy to clipboard, paste into a new report, and lo & behold the 'HTML' / output to other formats button no longer triggers a default prompting selection to appear (so, no problem).  I suppose I could do that for everyone of my reports (not great, but at least a path forward for me in 11.2.4).  
    I created a brief mp4 to show/record the issue for the IBM rep, who is working to replicate the issue, and it's probably best for me to pursue a solution in that channel.  I was curious if anyone else has run across this (but it appears not.
    I appreciate your suggestions, and will consider them as my org moves forward.  Our set of reports is due for some refreshing.

    ------------------------------
    Mike Comiskey
    ------------------------------



  • 15.  RE: Release 11.2.4 of Cognos Analytics Webinar

    Posted Tue January 10, 2023 12:16 PM

    Hi everyone,

    You can watch the on-demand recording here and download the slides here.

    Please share any of your questions below.



    ------------------------------
    RACHEL SU
    ------------------------------