Blog

What's happening? What's new? What can I do? Find answers to these questions in the blog.

Archive Results

Blog

VIDEO: An Overview of Cognos Analytics

Welcome to our video that showcases the capabilities of Cognos Analytics.  In this video, we will introduce you to the newly re-imagined Cognos Analytics, and illustrate the improved user interface for each feature function. Related posts: Data Preparation and Modeling Data to Dashboard in Minutes (Coming Soon) Please visit our IBM Cognos Analytics channel on YouTube.

Blog

#Cognos Analytics 11.0.8: Updated Data Module Capabilities

In Cognos Analytics Release 11.0.8, data modules were augmented with some new capabilities. These improvements were delivered in the areas of ambiguous connection support, and diagram view changes. Ambiguous Connections: Ambiguous connections that were supported in earlier versions of Cognos products, were not well supported in Cognos Analytics. Each data source had to have an explicit connection and sign on assigned. If a data server had multiple connections that were not explicitly resolved, the data module user would encounter an error. In 11.0.8, Cognos Analytics will now prompt the user when ambiguous connections are encountered. This increases flexibility for clients, as well as provides an upgrade path for Cognos clients running previous versions. Diagram View improvements Prior to Cognos 11.0.8, many users did not leverage the diagram view within the data module experience because the user had to know to select the “eye” icon before they could control the diagram (as shown below)   As seen below, the default in 11.0.7 was cardinality off, and maximum degree of separation.   In Cognos 11.0.8, we improved the usability of the diagram view in data modules. The diagram display allows the user to focus on an area of the model, while providing a view of the complete model. Additionally, the cardinality is now ‘on’ or shown by default in this latest release. If a user wants to supress the display, they can simply un-check the cardinality check box.   In 11.0.8, when a user opens a data module the first table in the module is in focus. If the user accesses the diagram view, the degrees of separation is set to one. The diagram will show the tables related to the table in focus within 1 degree of separation. The remaining items are displayed in a translucent rendering. This ensures the user can understand the entire model, but remain focused on the current items that need investigation.   Release 11.0.8 After loading data module – grid view:

Blog

Data Modelling enhancements in #Cognos Analytics 11.0.7

The user experience of creating data modules has been revamped in Cognos Analytics 11.0.7. All aspects of preparing data have improved, including snappier response times with every interaction. This post will walk you through some highlights. The layout of the user interface has been streamlined with tabs at the top to toggle between the data grid, diagram, and validation views. Now you can sort the columns in the data grid to better enable the exploration of data while you’re shaping it. Invoking the Create calculation action on a numeric column will present a simple interface for common arithmetic operations just like in prior versions, but now there’s also a link to progress to the calculation editor if more advanced functions are needed. When applying a filter on a text column, you can now specify conditions like “starts with”, “contains”, or “does not end with”. These filter conditions make it easier to reduce your data to only what you need. If you define a data group on a numeric column, by default ranges of the groups will have equal distribution just like in prior versions, but now should the minimum or maximum values in your data change the groups will adjust dynamically. The ranges of the groups will not change dynamically if you explicitly set the ranges. There are a many user experience improvements for defining the relationships (joins) between tables. When browsing potential columns to match as keys for the relationship, you are presented with data from selected columns, separate from the table data view area, to make it easier to confirm whether there are matching values between the selected columns from each table – this also makes it easier to see whether either column has duplicate values which can help you set the cardinality accordingly. Simpler terms are used for the labels of settings like the cardinality options, but you can easily see more information about what each of the options mean by hovering over the associated “info i” . Here is a short video that demonstrates these new features:

Blog

Video: What’s New in Modeling for IBM #Cognos Analytics 11.0.5?

Welcome to our video about what’s new in modeling, where we’ll show you some of the latest features in IBM Cognos Analytics 11.0.5, including linked modules, navigation groups, Framework Manager relational package support, and loading metadata. We will also demonstrate the enhanced date filtering user interface. Related posts: Modeling Enhancements in Cognos Analytics 11.0.5 Library of Videos for IBM Cognos Analytics Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Overview: Navigation Groups (11.0.5+)

Starting in IBM Cognos Analytics 11.0.5, you can create and use navigation groups. Learn how to create and edit navigation groups in a data module, and use navigation groups in a dashboard. Related posts: Modeling Enhancements in Cognos Analytics 11.0.5 Library of Videos for IBM Cognos Analytics Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Create a data set from a data module (11.0.4+)

Learn about creating a new dataset from a data module, and how to schedule data refresh for your new data set. A data set contains a subset of tables and rows, stored as a single table in columnar format. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Validating a data module (11.0.4+)

Learn to use the validation tray to check your data module for errors. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Intent-driven modeling to infer relationships between tables (11.0.4+)

Use intent-driven modeling to build a data module so relationships between tables are automatically generated for you. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Clean NULL values (11.0.4+)

Learn to clean NULL values in your data. Please visit our IBM Cognos Analytics channel on YouTube.

Blog

Video: Advanced sorting (11.0.4+)

Learn to sort a column by the values in another column by using advanced sorting in a data module. Please visit our IBM Cognos Analytics channel on YouTube.