Cognos Analytics

 View Only
Expand all | Collapse all

See Cognos 11.1.7 in action

  • 1.  See Cognos 11.1.7 in action

    IBM Champion
    Posted Wed July 29, 2020 11:31 AM
    Thought you all would enjoy this livestream I did yesterday on the PMsquare youtube channel. I go over all the new features of 11.1.7. It's a great release overall!

    Meet Cognos 11.1.7
    YouTube remove preview
    Meet Cognos 11.1.7
    Join PMsquare Director of Technology, Ryan Dolley, to explore the new Cognos 11.1.7 release. Cognos 11.1.7 brings very significant enhancements to IBM Cognos...
    View this on YouTube >

    Cheers!
    Ryan

    ------------------------------
    Ryan Dolley
    2020 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: See Cognos 11.1.7 in action

    Posted Thu July 30, 2020 01:49 AM
    Thank you for your stream, Ryan! It was great introduction to the CA 11.1.7. Just for information, IBM just released Release Notes to the CA 11.1.7 -  https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_11_1_7_container.html

    ------------------------------
    Jiri Smrz
    ------------------------------

    Original Message


  • 3.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Thu July 30, 2020 04:45 AM
    Hi Ryan,

    As always, a brilliant job done by you and your team.
    Say hi to Paul Mendleson for me, ages since I last met up with him at a conference.

    Regards
    Andy

    ------------------------------
    Andrew Copeland
    ------------------------------

    Original Message


  • 4.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Thu July 30, 2020 01:36 PM
    Thanks for tuning in Andrew. I passed your well wishes along to Paul.

    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message


  • 5.  RE: See Cognos 11.1.7 in action

    Posted Thu July 30, 2020 11:06 AM
    Thanks Ryan for very good and interactive session yesterday. 

    Some of the questions I have to see if there are better ways in CA 11.1.7 on Cloud:- 
    • Is Incremental datasets load  supported natively?
    • Is Bursting option available in  Scheduling Interface?
    • Can we change file name dyrnamically from Scheduling/Email Interface?
    • On Cloud, Do we need to have Watson Studio to get access to Jupyter Notebook to read and write to CA?


    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 6.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Thu July 30, 2020 01:42 PM

    Buddhi,

    Thank you for tuning in! I'll do my best to answer your questions here:

    1. Data sets don't have native incremental load as far as I can tell. May be possible to accomplish something with the API but I haven't had time to test it yet.
    2. It appears that bursting works just fine via the new interface provided you've configured the report to be a burst report
    3. There's no option to dynamically change the file name from the scheduling interface. The burst process can accomplish this though.
    4. I can't actually test this so what I can tell you is that my understanding is that you are correct, access to Jupyter for cloud customers is via Watson Studio.

    Cheers!
    Ryan



    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message


  • 7.  RE: See Cognos 11.1.7 in action

    Posted Thu July 30, 2020 04:31 PM

    Re  "Data sets don't have native incremental load as far as I can tell...."

    Is the question, can you append vs straight replace?



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------

    Original Message


  • 8.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Thu July 30, 2020 04:37 PM
    That's how I interpreted it. I know you can with excel files but I haven't seen that ability with data sets. lmk if I'm wrong.

    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message


  • 9.  RE: See Cognos 11.1.7 in action

    Posted Thu July 30, 2020 05:17 PM
    Hi @NIGEL CAMPBELL,

    We don't want to reload all previous dates data as it increases Load time. Only data for new dates (or any other criteria) to be added to same Dataset. 

    Question is whether it's addressed in CA 11.1.7 or planned to be added as FP for LTS release.​ Most of other BI tools give that option for Extract.

    Can it be done via reporting interface now available in CA 11.1.7?

    Thank you for any inputs!

    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 10.  RE: See Cognos 11.1.7 in action

    Posted Fri July 31, 2020 05:09 PM
    Thanks @Ryan Dolley!

    You mentioned to use all SQL​​s in single Data module.  I see below additional observations:-
    • If we have more objects in data module, it seems DM and reports performance is impacted
    • We don't have search of column available for SQL Based Objects using search button
    • SQL Objects don't seem to have sorting option enabled.
    • If I change data source link in source, it doesn't get updated in SQL source.
    • Naming of data items for SQL based objects is different compared to when using Data Server Objects. i.e. I have to qualify names within SQL to set desired names.




    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 11.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Mon August 03, 2020 11:19 AM
    Buddhi,

    Yes, that's correct. There are limitations to the method I advocate, unfortunately nothing is perfect. However you should follow PMsquare to see some of the enhancements we've been working on - sorting and searching in data modules is something we're developing an extension to solve which will be made public soon.

    Cheers!
    Ryan

    ------------------------------
    Ryan Dolley
    2019 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message


  • 12.  RE: See Cognos 11.1.7 in action

    Posted Sat August 01, 2020 09:07 AM
    Hi , which link can I get the new cognos 11.1.7 to test the new functions and the API

    ------------------------------
    João Galdino
    ------------------------------

    Original Message


  • 13.  RE: See Cognos 11.1.7 in action

    Posted Thu August 20, 2020 06:19 AM
    Just signup for the trial and you have 30 days to test the latest release ;-) 

    https://www.ibm.com/dk-en/products/cognos-analytics

    Torben

    ------------------------------
    Torben Noer
    Offering Manager, Cognos Analytics and Planning Analytics
    IBM
    ------------------------------

    Original Message


  • 14.  RE: See Cognos 11.1.7 in action

    Posted Tue August 04, 2020 09:17 AM
    Thanks Ryan, great record collection! :)

    ------------------------------
    Mark Peterson
    ------------------------------

    Original Message


  • 15.  RE: See Cognos 11.1.7 in action

    IBM Champion
    Posted Tue August 04, 2020 09:58 AM
    Thank's Mark, glad you enjoyed it. And glad you enjoyed the record collection!

    ------------------------------
    Ryan Dolley
    2020 IBM Champion
    www.ibmblueview.com
    www.pmsquare.com
    Connect with me on LinkedIn: linkedin.com/in/ryandolley
    ------------------------------

    Original Message