PMsquare

Services

Blogs

Ryan Dolley, September 29, 2018

Get the Best Solution for
Your Business Today!

PMsquare is excited to announce the launch of a new version of Cognos, Cognos Analytics 11.1. Since late 2014, IBM’s Cognos Analytics and Watson Analytics have vied for attention in a crowded analytics marketplace. While ostensibly serving separate audiences and use cases, clients often wanted enterprise reporting and advanced analytics in a single package. In Cognos 11.1, IBM brings long sought improvements to Cognos’ core features while adding advanced analytics and artificial intelligence driven by Watson. Best of all, this huge enhancement is free to all Cognos customers.

Table of Contents

Reporting

Reporting updates center on improving the user experience by redesigning navigation and automating the most common layout tasks with drag-and-drop formatting. These enhancements make report creation significantly easier for novice and advanced authors alike while retaining the pixel-perfect flexibility that Cognos professionals demand.

  • Dynamic Layout makes layout building, object resizing and styling into an easy drag-and-drop process
  • Redesigned breadcrumb-based navigation is much improved
  • Lock the dynamic toolbar to the top of the reporting screen for easier interaction
  • Style building allows you to easily create and re-use style properties across reports
  • Client-side visualizations improve performance, interactivity for report users
    • Data is retrieved from the database and stored client side – no more re-query for every filter change
    • Contextual data can be added to a visualization, which allows more advanced filters.

Dashboard Updates

Dashboards receive a ton of attention in Cognos Analytics 11.1, knocking off many of the most requested enhancements, greatly improving customizability and integrating new AI and advanced analytics capabilities. These changes turn what was already a very capable self-service data discovery and visualization suite into a powerful, easy to use AI enhanced insight engine that end users will love.

  • Custom color palettes!
  • New ‘insights’ capability automatically highlights outliers, shows average values and other interesting statistical information
  • Upgraded layout options, such as absolute or relative positioning and snap to grid or object.
  • New visualizations including:
    • Bullet chart
    • Decision Tree
    • Driver analysis
    • Marimekko
  • Enhanced visualization customization, including ability to change fonts and axis labels
  • Enhance integration with Stories & improved Stories features
  • Individual visualization data available in data tray
  • Share visualizations or whole dashboards directly to Slack
b.png

Data Modeling Updates

Cognos Analytics 11.1 significantly modernizes and enhances the Data Modules, Data Sets and uploaded file capabilities of Cognos, with a focus on making data management easier and more performant. Data Modules in particular receive a host of data modeling and blending features that meet or exceed the capabilities of Framework Manager in almost every respect.

  • Data Module enhancements:
    • New expression editor including comment formatting, type-ahead functions
    • Create table copies, views, joined views, unions, intersects and excepts
    • Create tables using SQL
    • Set data level security
    • Set table cache parameters to improve performance
    • Set ‘column dependency’ to handle multi-fact grain mismatch
    • Overwrite default column formats
    • Split columns
    • Create relative time calculations (see Relative Time for more info)
  • Data Set enhancements:
    • New data set query processing engine improves performance
  • Uploaded File enhancements:
    • New uploaded file query processing engine improves performance
    • Support for multi-tab spreadsheets
    • Ability to append or replace uploaded files
    • New upload interface

Admin and Architecture Changes

Admin changes for Cognos Analytics 11.1 focus on two areas: Migrating functionality from the Cognos 10 Administration screen to the Cognos 11 Manage menu, and adding new administration functionality. These enhancements make Cognos easier to govern and provide features like user and distribution list management that used to require outside software.

  • Ability to define palettes via Manage menu and use them in ANY Cognos studio
  • Create distribution lists directly within Cognos
  • Redesigned job interface
  • Simplified routing rule management

AI Assistant

The AI assistant is one of the major new features of Cognos 11.1. accessible from Dashboards and Explorations, the AI assistant provides a chat-based exploration experience designed to quickly uncover relationships and statistical anomalies within data and automatically build visualizations for use in Cognos.

  • Search Cognos for data related to specific topics
  • Receive descriptive and statistical information about columns within data sources
  • Uncover what drives the values of any individual column
  • Automatically visualize via text
c.png

Explore

Explore, the most exciting new feature of Cognos Analytics 11.1, brings the automatic insights, easy visualization and natural language query capabilities of the now deprecated Watson Analytics into Cognos. A new Exploration will automatically suggest starting points for analysis, visualize relationships in your data, provide key driver analysis and surface interesting visualizations.

  • Relationship model highlights connections between fields in the data
  • Suggested starting points make analysis easy
  • Key driver analysis uncovers the factors that influence important fields
  • System generated text describe underlying insights in the data
  • Related visualizations surfaced based on statistics and likely value
  • Comparison cards narrate the difference between any two visualizations
  • Export insight to Cognos Analytics Dashboards
d.png

Relative Dates

Cognos Analytics 11.1 now has out-of-the-box support for relative date attributes and measures, making it easy to turn a single date field into a date hierarchy for drill up/down and into calculations such as quarter-to-date, year-to-date, etc.

Slack Integration

Cognos Analytics 11.1 also integrates with Slack, allowing users to easily share visualizations or entire dashboards directly to slack channels from within the Cognos UI

More to Come

This is just a summary of the exciting features of Cognos 11.1. Check back with us for more in-depth blog updates on individual features written by our team of Cognos gurus, and be sure to attend our Cognos 11.1 webinar.

Conclusion

I hope you found this article reviewing the new version of Cognos 11.1 helpful.  You can get more analytics insights exploring our blog and e-newsletter. If you haven’t already, be sure to subscribe to the PMsquare Journal for more technical articles and updates delivered directly to your inbox.

Next Steps

If you have any questions or would like PMsquare to provide guidance and support for your analytics solution, contact us today.