E019 – Tech Spec – Cognos Analytics (11.0.6)

Join me as I chat with my colleague and Cognos guru John Frazier about the latest release of Cognos, leading up to the anticipated release of the next version, 11.0.7, near the end of Q3. The latest version of Cognos (11.0.6) debuted on March 21, 2017. You can sign up for a perpetually free trial […]

Join me as I chat with my colleague and Cognos guru John Frazier about the latest release of Cognos, leading up to the anticipated release of the next version, 11.0.7, near the end of Q3.

The latest version of Cognos (11.0.6) debuted on March 21, 2017. You can sign up for a perpetually free trial (like Tableau Online) here.

Version 11 was originally released in December 2015 and was mainly a UI redesign on top of Cognos 10 features. Analysis and Query Studios will eventually be deprecated.

New Features in 11 vs. 10

New UI – responsive web design on UI, but not on reports
Better self-service capabilities and collaboration for teams
Upload data files – upload delimited text or Excel files to be stored in a columnar format (Parquet) on the file system (not in memory or in the DB). These are immediately usable in dashboards and don’t require entry into FM.
Data modules (intent based modeling based on Watson) similar to FM packages

Note: Dashboards only use uploaded files and data modules

Available on cloud
Mobile and desktop from a single report
Active reports as prompts
Free cloud trial
Admin console is unchanged

New Features in 11.0.6

Mapping enhancements

Multiple admin boundaries, add’l postal code support

Dashboarding enhancements

Direct access to OLAP packages (Framework packages accessible since 11.0.5)
Widgets using data from the same source are connected by default
New grid widget
Color gradient by measure
Date filters can include blanks

Portal enhancements

Share/embed through overflow menu
Folder customizations can be done directly through the UI more easily (without uploading JSON configs)
Create shortcuts and report views

Storytelling enhancements

New guided journey templates
New animations (side fade, slide, scale, zoom, pivot)
Better pins (smart named, better search and filter)
Timelines – smart names
Change scene template while working on your story/dashboard

Reporting enhancements

Better lineage support for FM packages
Business glossary (w/IBM InfoSphere Information Governance Catalog integration)
Better freeze list column heading control
Better query support when editing data modules
Report templates – can save for your team or save as style reference reports

Support for Planning Analytics

Dashboard support for TM1 / Planning cubes
REST connectivity to planning analytics
Support for attribute hierarchies
Support for localized Planning Analytics cubes

Data server enhancements

Support for Google BigQuery and Google Cloud SQL via the BigQuery JDBC and MySQL JDBC drivers, respectively.
JDBC URL for Data Server Connections
Test connection feedback (this is not just in admin console now)

John’s Likes/Dislikes with v11:

For those who are “used” to ReportStudio there is a pretty “steep” learning curve to locate where particular tools or components have been moved.
To be fair, ReportStudio had some counter-intuitive placements for some of these same tools (e.g. Hierarchy of design elements, etc.) that caused major headaches for new report designers.
Overall the new interface is more “intuitive” and the novice report developers I’ve worked with have picked it up remarkably quickly.
There are some changes that are really “nice” – like being able to see which Lists/Graphs use a particular query right from the query tree without having to “search” for where it is used on the “right click” menu.

Music

Deep Sky Blue by Graphiqs Groove

Sources

https://www.ibm.com/analytics/us/en/technology/products/cognos-analytics/
https://www.ibm.com/communities/analytics/cognos-analytics-blog/the-latest-release-of-cognos-analytics-is-here/
http://newintelligence.ca/top-12-reasons-to-upgrade-to-cognos-analytics-a-k-a-cognos-11/
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_deprecated.html
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_11_0_x.html
https://www.slideshare.net/senturus/cognos-analytics-version-11-questions-answered