Blog

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

Archive Results

Blog

Cognos Analytics and PowerPlay Interoperability

PowerPlay 11.0.0 now supports the following versions of Cognos Analytics: 11.0.7 11.0.8 11.0.9 11.0.10 As of version 11.0.8, Cognos Analytics re-introduced the ability to modify the default action of a report or report view.  This is also applicable to PowerPlay reports and PowerPlay report views.  In addition, the default action for a PowerPlay report in 11.0.8 is to open the report in PowerPlay Studio, as opposed to 11.0.7 which would run the report.  For PowerPlay report views, the default action is to run the report.

Blog

New Base Samples for IBM #Cognos Analytics 11.0.8

There are two types of samples that have been created exclusively for IBM Cognos Analytics. The Extended Samples require the use of a database and database connections to host the sample Great Outdoors data. They must be installed and configured. Here are the instructions for installing the Extended samples. We have also created a set of Base Samples in a deployment that can be easily imported in one step. These samples exclusively use Data Modules as their underlying data sources (no cubes, databases, or packages). Here is a video that explains how to find and import the Samples_for_Install_11_0_8.zip deployment file. After you import the deployment, you will see the following new Base Samples: Team content > Samples Version 11.0.8 base samples This new report is a table of contents for the base samples. It lists all the available samples in sections (dashboards, stories and reports) and provides a direct link to each sample. It identifies the core features that the sample is intended to demonstrate, and provides a description. Team content > Samples > Reports Corporate website visits We added a map that is generated from latitude and longitude coordinates. This sample report demonstrates the new client-side mapping functionality in reporting. Three maps display 2016 website visit data for the fictional Sample Outdoors Company website by Zip Code and Latitude/longitude in California. Team content > Samples > Stories Animated path scene transition This sample Story demonstrates the new animated paths feature for scene transitions, and timeline highlights. Like many other cities, Boston, MA logs hundreds of thousands of requests each year for services such as snow plowing, street cleaning, and pot hole repair. Source: City of Boston. Team content > Samples > Data California website visits We added data columns for Latitude and Longitude for use with the client-side mapping functionality in reporting. This sample data module contains 2016 website visit data for the fictional Sample Outdoors Company website by Zip Code and city in California. Source: IBM Note: Latitude and longitude must be in separate columns of decimal degrees coordinates, with latitude in the range of -90 to 90, and longitude in the range of -180 to 180. Extension Samples There are two new sample Extensions for IBM Cognos Analytics 11.0.8. These sample files are installed with the product in an Easy Installation, and are an option in a Custom Installation. After product installation, you can find them here: <cognos_analytics_installation_location>/samples/extensions/ SampleExtensionCustomMediaAll.zip This sample extension will add eight custom images to the Image Library tab in the Widgets panel in Dashboarding and Stories. It will also add the eight custom images to the Image Picker dialog in Reporting in the Image Gallery. Only JPG and PNG files are supported at this time. SampleExtensionMenuUrlLinks.zip This sample extension demonstrates how to add a menu to the AppBar that contains two menu items that open external URLs. The URLs are opened in a separate browser tab. Please note: Themes and Extensions are an incremental feature that changes with each product release. The samples included with each release have been verified with that release only, and may not support backward or forward compatibility. Related posts: Samples landing page Supplementary (Legacy) IBM Cognos Analytics 11 samples Guide to IBM Cognos Analytics sample data sets New Base Samples for IBM Cognos Analytics 11.0.7 Please visit our IBM Business Analytics Support channel on YouTube.

Blog

Introducing #Cognos Analytics 11.0.8

The Cognos Analytics team has been hard at work on new enhancements, and I am thrilled to announce that release 8 (11.0.8) is now generally available. This release tackles a lot of those small, but significant, enhancements that will help you and your users get the most out of this smart business intelligence and analytics solution. Our large installed base of customers will be happy to know that in this release we focused on addressing some of your top Requests for Enhancements (RFE), so rest assured that we appreciate (and are listening to) your feedback. We also addressed some items that will make it easier to administer and manage your BI and analytics environment. Finally, we continue to enhance existing capabilities, for example, we added latitude/longitude support in mapping for reporting. The enhancements touch all aspects of Cognos Analytics, but they are all focused on reducing the time it takes to get things done and making visualizations easier to understand. These enhancements mean Cognos Analytics 11.0.8 is: Faster and more precise for dashboard and report creation Addition of latitude and longitude layer in reporting More output options for reports with the ability to save and output a report as XML format Support the viewing experience your users want with the ability to select the Default run action per report (latest saved output, always run the report with the latest data, open in edit mode) Tailor-made to meet your needs – so you can customize your experience Upload custom images with Image library extension in reporting (on premise and on cloud) Designed to make your data work for you with faster data preparation Ability to select from multiple connections to a data source with support for ambiguous data connections (either mutliple connections to the same data source or multiple signons to the same data source) for data modules and dashboard Faster data set creation with support for Design mode in data set editor Better visibility and control of your BI and Analytics environment Easy tracking of dashboard usage with support for auditing Keep track of all of your scheduled reports with support for Manage my schedules and activities Want a quick overview of the cool new features in R8? Watch Kevin as he takes you through the highlights in the What’s new in R8 demo video.

Blog

Data server updates in #Cognos Analytics 11.0.8

Amazon Athena Cognos Analytics 11.0.8 introduces support for Amazon Athena, a SQL interface for data files stored in Amazon S3 storage.  Athena was built on Presto, an open source distributed SQL query engine which is also supported by Cognos Analytics as of version 11.0.7. Spark SQL Cognos Analytics 11.0.8 also adds support for Spark SQL via the Simba Technologies JDBC driver. Spark SQL (Thrift Server) is a service that can receive SQL queries via JDBC and in turn generates Spark requests which are executed by a cluster of Spark executors. Azure SQL Data Warehouse Even though many Cognos Analytics customers are already using Azure SQL Data Warehouse due it being a variant of Microsoft SQL Server and Azure SQL Database, it is now officially supported just like those others!

Blog

#Cognos Analytics 11.0.8: What’s new in storytelling

With the release of Cognos Analytics 11.0.8 we are pleased to bring new capabilities to help create compelling stories that communicate your message and findings with (or without) you being present. Highlight at point in time With 11.0.7, we introduced the Animated Path capability, allowing you to resize and move items on the canvas from one scene to another in order to keep it visible as a reference while focusing on another visualization. In 11.0.8 we introduce the ability to highlight a point in time so you can apply highlights at specific times. This capability follows the same method as if you were to select an item manually, meaning that if the item is present on a visualization it will be highlighted, if it is not present then it will act as a filter. As you can imagine this provides a lot of flexibility in how you tell your story Kiosk Mode With a story you may want to have the ability to set it and forget it -- whether this is in an office lobby or on a production floor. Now, with Kiosk mode you canhave the system play through all scenes and loop. Play through differs from the normal playback mechanism where a scene would play to the end and you would need to manually move to the next scene which would start playing. Now, with this latest release, you push play once and the story will unfold before you. If you have enabled looping it will continue to play through all the scenes until someone stops it. This does mean that if the data underlying the story is changing that the story will update to reflect this.

Blog

#Cognos Analytics 11.0.8: Adding Latitude/Longitude Maps in Reports

Cognos Analytics Release 8 adds support for Latitude/Longitude based maps in reports allowing geocoded data to be displayed on the maps shown in reports as seen below: In our example, businesses in Hawaii are shown as points located by latitude and longitude with revenue driving the size, and Profit driving the color of the points. As with the Regions and Points layers, the Latitude/Longitude layer is available on the layer selector:   The Latitude/Longitude layer requires two data numeric data items for the latitude and longitude: The label field is used to provide a meaningful tooltip for the points. That’s because, generally speaking users will know the name of the store “ABC Retail,” but not necessarily the latitude and longitude of the store. For this reason, the label, but not the latitude/longitude location is displayed in the tooltip:   Much like the Points layer, Size and Color require a measure data item to style the circular points displayed at each unique latitude/longitude location. Of course, you can define all three layer types, or any combination thereof, at the same time. In fact, in our example, there is a region layer on “State,” which resulted in the green color used to style Hawaii. Latitude/Longitude Encoding While there are several ways to store latitude/longitude , Cognos Analytics requires using a WGS 84 / World Geodetic System (WGS) encoding stored as numeric data items. WGS 84 simply means latitudes between -90 and +90 degrees, and longitudes between -180 and +180 degrees suitable for use on a Web Mercator map. An example would be the White House in Washington DC located at latitude 38.897957, and longitude -77.036560. Other formats such as degrees, minutes, second and decimal seconds for example 38° 53' 52.6452'' N, 77° 2' 11.6160'' W are not supported, nor are other X, Y coordinates systems. In such cases, the data would need to be converted to WGS 84 for use in Cognos Analytics. Errors and Null Island As part of our error checking, we determine if the latitude values in the data fall between -90 and +90 and longitudes between -180 and +180. Any values outside of these ranges cannot be mapped as they fall outside of the coordinate system. Rather than not mapping that data, we replace the query values with latitude 0 and longitude 0 which allows those data points to map so you can detect the error. For instance, the 0, 0 location is found just off the coast of Africa in the Gulf of Guinea as shown below: As there is no actual land mass there, this location is somewhat humorously referred to as “Null Island,” and is commonly used by mapping systems to display out of bounds data. If you ever see data mapped here, it’s probably in error. The likeliest cause of such an error is putting the latitude and longitude data items into the opposite data slots when defining the map. Geocoding As odd as it sounds, mapping systems, generally speaking, cannot use addresses for locations. Rather, the mapping systems need to have the address converted to an latitude/longitude which can be mapped. The process of converting an address to a latitude/longitude location is referred to as “geocoding.” Companies provide geocoding as a paid service. For example, the address of the White House “1600 Pennsylvania Ave NW, Washington, DC 20500” would be passed to a geocode service which would return the latitude 38.897957, and longitude -77.036560. These values are then stored into the RDBMS for use with Cognos Analytics. Although, it is important to note that Cognos Analytics does not provide geocoding; your data must be geocoded before being used within Cognos Analytics. Conclusion Latitude/longitude support extends the report map support nicely and give us a further foundation to build on.

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

#Cognos Analytics 11.0.8: What’s new in dashboards

We focused this release on a few key enhancements around ease of use and flexibility of the dashboard. Ease of use Higher data points cap for visualizations The goal of the dashboard is to provide a fast, interactive experience to allow the user to find the results they need with minimal spinners. For some visualizations, however, there is an advantage to show more data points simultaneously. To meet that need, we have bumped up the data points cap to 10k on tables and crosstabs, and to 30k for maps. Of course, keep in mind that the more data points you pass to a viz, the longer the spinner may be depending on your browser and computer. Filter indicators on visualizations To better help the user understand which filters are currently being applied to a viz, we now list the filters individually in the tooltip. This comes in handy when the user needs to exclude several data points consecutively, and then wants to add a few back. Now, they can simply remove the exclusions one at a time by using the tooltip. In the example below, I was looking at Product Types and I excluded one data point at a time. Each action then created a new entry in the filter pop-up, allowing me to clearly see which ones were excluded.   Administration of dashboards Support for ambiguous connections To better serve users who have access to multiple connections to the same data source, we now prompt the user to select which one they wish to connect to. This applies to ambiguous connections and sign-ons. In the example below, I am using a data module that points to a data source where I have access to multiple connections. The dashboard now prompts me to select which one I want.   Once I select the connection, it is set for the remainder of this current session, it will only prompt me a single time. If I want to switch connections, I have two options: close and re-open the dashboard or use the re-link option and select the same source again. The pop-up will prompt again. Auditing of dashboard This is for the administrators who want to track the usage of the dashboards. Once Auditing is enabled at a system level, any time a dashboard is opened, it will add an entry to the audit logs in the same way as other Cognos assets such as reports. Upon a dashboard action, the system will log the name of the user, dashboard name, timestamp, sources used as well as execution time. To make it easier for the admin to see the new data, we have updated the Audit sample deployment archive to include dashboards as an output type. See example below: To close things out, I’d like to mention two more smaller improvements we have also made: The widget titles now remain a fixed size, regardless of the size of the widget. This will provide a consistent look across all widgets. The button to change visualization when in focus mode is now in a more visible location above the viz, and it also indicates the name of the current selected chart type.

Blog

#Cognos Analytics 11.0.8: What’s new in Reporting

The reporting capability in the latest release of Cognos Analytics 11.0.8 is filled with popular RFEs from our customers around the world. Latitude and Longitude support Mapbox integration in reporting has a new layer – latitude and longitude. Report authors can use up to two measures to represent bubble size and color when mapping lat/long. An additional label slot has been added to the interface to provide meaningful tooltips. For detailed information on this feature, please visit the blog here. Design mode in Data Set editor When creating a data set with large number of records, the results may take a long time to return. Design mode allows users to create a data set with metadata only. Live data only becomes available when switched to preview mode.   Export a report to XML format This feature has been brought back into the product due to popular demand. XML format is available as an output option from within report editing environment, Cognos 11 interactive viewer, Cognos 10 classic viewer, scheduling, run in background and subscription. Hyperlink to open in a new tab By default, a hyperlink opens in the current browser tab. This replaces the entire Cognos Analytics environment. This approach no longer works well in Cognos Analytics 11 because reports are running under the Cognos Analytics portal, under the switcher. Replacing Cognos Analytics content within the browser tab means losing navigations. A new property has been added for the hyperlink object allowing it to open in a new browser tab. We did not change the default setting for upgrade purposes. All reports created prior to R8 continue to open in the current browser tab. Image picker Administrators can upload custom images through extensions in Cognos Analytics. This option is available under Manage-> Customization->Extensions tab.   There are sample extensions available with the Cognos Analytics install to help you understand how to write extensions. You can use the Sample_Custom_Media_All json file as a test and import it using the above method. Once this extension has been imported, images are available in dashboarding, storytelling and reporting interface. The way to access them within reporting is to use an ‘image’ object and double click on the object to launch the image picker dialog. This dialog continues to support images hosted on your webservers.  

Blog

#Cognos Analytics - New Features by Release

IBM Cognos Analytics is designed to empower business users, giving them the self-service tools they need to solve individual or workgroup challenges. Cognos Analytics uses a continuous delivery model to roll out new features on a regular basis. Here is a break down of new features introduced to Cognos Analytics in each release per component. Dashboarding 11.0.9 Informational link New features: Latitude and Longitude mapping support Label axis orientation Full screen mode and narrow side bar 11.0.8 Informational link New features: Higher data points cap for visualizations Filter indicators on visualizations Support for ambiguous connections Auditing of dashboard   11.0.7 Informational link This release is by far our biggest one in terms of new Dashboard features: New features: On-demand toolbar in charts New visualizations slots Multiple columns per slot Measures as categories Repeat slots Mapping refinement slot Values labels in the charts New visualizations Vizualization enhancements Filter enhancements Calculation enhancements Navigation paths Field defaults Data tray in consumption mode   11.0.6 Informational link Direct access to OLAP packages OLAP packages are supported as a datasource when creating dashboards. This includes support for sources such as PowerCubes, Dimensionally Modelled Relational (DMR), TM1, Dynamic Cubes, MSAS and all the other supported OLAP sources. For the DMR package, the same rule applies as for relational packages, meaning that it needs to be published as DQM, unless there is also a JDBC connection defined for it. Widget Connections By default, all widgets on a canvas from the same source are connected. This allows you to drag a few fields onto the canvas and quickly filter the information by simply clicking on the values inside the widgets. This is very useful when you need to find a value, but with the new widget connections, you can now do comparison-based analysis by disconnecting the widgets preventing them from being filtered by other widgets. New Grid widget We are introducing a new grid widget in R6 that provides improved performance when scrolling, it displays summaries per groups as well as stretches to fit the size of the widget. You can also decide to hide or show the summaries. Showing nav paths in metadata tree In the previous release (11.0.5), we introduced navigation paths to allow users to define a logical order in which to explore their data. What makes navigation paths fun to use is that they do not have to be the traditional Year > Quarter > Month type of hierarchy; it can be anything that makes sense for the user of the dashboard, perhaps start at Products then jump to Sales Reps and finally to Region, this provides a flexible and quick way to navigate through the data. In this release, navigation paths now appear under a new folder at the top of the metadata tree in the dashboard to make them more visible to the user. Colour slot on charts When viewing a chart, you can now drag in another measure to act as a colour gradient. Filtering on dates containing blanks When filtering on date fields that contain blanks, you will now be able to use the new filtering dialog with calendars. This is particularly useful when filtering on a field such as Shipped date for example, where a product may have been ordered, but hasn’t shipped quite yet.   11.0.5 Informational link Direct access to relational Framework Manager packages We are thrilled to now provide direct access to your relational Framework Manager (FM) packages in dashboards. Simply select your package and off you go, no need to create a data set if you do not want to. New visualization engine with pan and zoom As soon as you create a new chart and start interacting with it, you’ll notice a new look and feel. We’ve introduced our new visualization engine called RAVE2 as part of dashboards. Your existing dashboards will automatically be updated to use the new charts, giving you access to the new features immediately. Navigation paths Navigation paths allow the user to explore their data in a new and exciting way. The user can just as easily navigate in one direction or the other, passing context to each level. Clear filters from any visualization Here’s a small change with a large impact, the user now can clear any filters from the little pop up on the top right of any visualization. This becomes particularly useful when you have many widgets on the screen where the user has selected a few values. Pinned headers in crosstabs This one makes a big difference in the way you interact with your data. The column and row headers are now pinned automatically on crosstab, allowing you to freely scroll left, right, up and down without losing context of the values you are looking at. Extensions An admin can now import extensions into the dashboard that will appear as new widgets where the user can drag them onto the canvas.   11.0.4 Informational link  Conditional formatting We took a feature that has been around for years and completely turned it on its head to make it more visual, more dynamic and fun to use. The traditional idea behind conditional formatting is to highlight certain data points based on predefined thresholds. We not only wanted to do that, but also wanted to use it as a way to analyze your data to see trends, groups and outliers. Drag a measure into the color by slot of a grid or crosstab and you’ll immediately see two indicators on the visualization: the values get highlighted based on the thresholds a visual representation of the distribution of your data Crosstabs Ask any data analyst what type of visualizations they use most, and many of them will say the crosstab. These users will be happy to see that we now provide the ability to define them in the dashboard. Our goal was to provide a crosstab that was both easy to use and provide the right level of functionality. Check it out and play with them, you’ll notice that we provide two levels of nesting on both edges, unlimited number of measures and display summaries on the groups. Refresh widgets on a timer One of the traditional usage of a dashboard is to monitor data, but where it gets interesting is when the data continuously changes and you need to update the visualizations without manually clicking on refresh. We are introducing a refresh timer for all widgets. The delay can be set in seconds, minutes or hours, with a minimum of 5 seconds. Open up a widget’s properties to enable the timer, and watch your visualization automatically update based on the latest info. Of course, this is more visually interesting when the data actually changes. Top / Bottom count When I am faced with lots of information, I very often find myself filtering down what I’m looking at to only a subset. Maybe I’m interested in only my top performing products, or maybe I want to zero in on the stores that are struggling. To facilitate this, we’re introducing the ability to filter your data on the top, bottom five or 10 on any chart. Click on the axis label to expose the new icon in the on-demand toolbar and select the new double-arrow icon for the top/bottom feature. Time and geolocation fields in the dashboard
 After importing a file or creating a data module in 11.0.4, you’ll notice new icons next to the names of the fields in the dashboard. Cognos Analytics now recognizes dates and geolocation fields and use these to provide a better user experience in the dashboard.   11.0.3 Informational link Calculations When an end user looks at data, they often need to manipulate the data itself to show it in different ways and act on it. We have added the ability to create calculations directly in the dashboard to facilitate the discovery of insights or to simply show a value that normally would need to be done outside the tool. Hover-over tool tip
It’s a simple gesture to quickly see the value of a particular data point without affecting the visualization. Hover your mouse over to the data point and a little pop-up tool tip appears with its context. To interact with the data point, click on it and more options will appear. For touch screens on iPads, a single tap will now bring up the tooltip. Relink a dashboard to another source Once a dashboard has been created, it’s handy to be able to repoint it to a new source and keep going. For example, you’ve created a great dashboard based on your data, but now you’d like to repoint that same dashboard to a new source that contains more info that may or may not have the same field names. No problem, relink it and fix up the fields that don’t match. Change the formatting of your fields
The dashboard will always take the default formatting based on what was defined in the source. However, as a user, sometimes it’s handy to have more control over how the numbers get displayed. We now allow the user to select the number of decimal points or even to abbreviate the number completely. Reporting 11.0.8 Informational link Latitude and Longitude support in Maps Design mode in Data Set editor Export a report to XML format Hyperlink to open in a new tab Image picker   11.0.7 Informational link Interactively view report performance Interactive filtering panel Mapbox integration Navigation paths Interactive performance details Package based drill-through View tabular data in Excel and Excel grouping   11.0.6 Informational link Lineage support for FM packages Lineage information traces the metadata of an item back through the package and the data sources. This option is available in Cognos Analytics interactive viewer, as well as page preview mode in report editing mode. Business glossary Business glossaries help you manage and share your enterprise vocabulary and classification system. It is only available when IBM InfoSphere Information Governance Catalog is configured in Cognos Administration. Freeze List column heading A report author can specify the height of the scrollable area, in pixels using the ‘Scrollable area height’ property. This property is available for List objects. Formatting applied on the List is also maintained. Enhanced query support for data modules Starting in 11.0.6, report authors can access and modify queries when creating reports using data modules. This enables the ability to create parameterized filters, custom calculations, conditional styles and many more. Expression editor and authored drill through definition are also available for advanced report authoring.   11.0.5 Information link  New Visualizations Out-of-the-box Cognos Analytics users no longer have to download and upload visualizations starting this release. We have included the newest visualizations out-of-the-box and will maintain and enhance them in every release going forward. This includes but not limited to adding more properties and more visualization types. Brand New Visualization Window We are introducing a new visualization gallery window that combines all charts and visualizations in this release. The Chart toolbox object is deprecated. Interactive Viewer URL API You can use a URL to open a Cognos Analytics report in Interactive Viewer starting 11.0.5. This also gives you the ability to embed Cognos Interactive Viewer in an iframe inside of your own application or web page. Modernized Prompting UI All prompting controls’ UI have been updated to have a more modern and mobile friendly look and feel. To take the advantage of this, you can set ‘Report styles’ to use 11.0.4 styles under Report properties. Filter Window Redesign When creating a custom filter from reporting edit mode or from the interactive viewer, a newly designed filter window will be launched. It has improved searching capability and an infinite result panel instead of traditional paging. The new design makes it much easier to use for both report authors and report consumers. Improved Reporting Navigation Report pages and queries are two of the most frequently accessed areas within reporting. As part of our ongoing usability improvement work, pages and queries are now directly available on the side navigation bar.   11.0.4 Informational link New Authored drill through in Interactive Viewer Drill-through definition is now available when a report is set to run with full interactivity in 11.0.4. This allows you to benefit from the new capabilities in the interactive viewer, while continue to be able to drill through from report to report. Data List formatting The Data List control was introduced in Cognos Analytics 11.0.3. As of 11.0.4 you can style a Data List with the same properties as a regular List. Context toolbar allows you to change font properties, foreground and background color, horizontal alignment and conditional formatting. You can also change data format on measures stored in this Data List. JavaScript support in Interactive Viewer Informational link The interactive report viewer can render reports with JavaScript embedded starting Cognos Analytics 11.0.4. We’ve taken a different approach with the interactive viewer JavaScript support – the JavaScript that you want to add to a report must exist in a separate file that your web browser can access. This allows the same JavaScript to be shared and reused among many reports. For example, if you have a custom prompt control, you can code it once and reference it anywhere in any report by using a new object called Custom control.   11.0.3 Informational link Multi-package reporting Report authors can create a single report leveraging data from multiple packages. This new feature is only available for Framework Manager packages that use dynamic query mode. Data list Active report performance suffers when trying to render a report with large data volumes. The main use case of presenting large volume of data is in a list format. The Data List is a new control available for Active Reports. It provides better performance than a regular list as it is rendered on the client machine instead of the Cognos server. Filter text As a report author, you can add text that shows the filters that are applied to the report. The filter text object can be formatted like a regular text object and it is available as part of the report layout for printing. Mapping 11.0.9 Informational link Latitude and Longitude support in Dashboards Dashboard Hide/Show Layers Updated Map Support Files: Link New French Regions: Link 11.0.8 Informational link Latitude and Longitude support   11.0.6 Informational link Multiple admin boundary and postal code support with the integration of Pitney Bowes Polygons With 11.0.6, we have integrated Pitney Bowes polygons that enables users to visualize their geospatial data across multiple admin boundaries and postal codes. Users can now visualize data across multiple geospatial hierarchies from Countries, states, cities down to municipalities, precincts and cantons, etc.   11.0.5 Informational link Cognos 11.0.5 expands on existing RAVE 2 technology in the Cognos Analytics Dashboard. Users now can analyze measures (such as revenue) at a country and state level with bi-directional filtering. Additionally, Mapbox’s highly scalable and high performance vector maps will allow users to pan and zoom all the way down to street level with the click of a button. Modeling 11.0.8 Informational link Ambiguous Connections: Diagram View improvements   11.0.7 Informational link User Interface improvements Calculation editor Text filter conditions Dynamic Data Groups User experience improvements for relationships   11.0.5 Informational link Linked Data Modules Data modules are now more reusable and combinable than ever before. Saved data modules that have been previously created can be used as data sources for other data modules. No need to reinvent the wheel. No need to redefine the same KPI calculations over and over again. Reuse and recycle. As of version 11.0.5, by default a data module source will be a linked data module. Changes to a linked data module propagate to all other data modules that reference it. A linked data module is always in sync with all other data modules that depend on it. Navigation Groups A navigation group is a collection of non-measure columns that business users might associate for data exploration. When a data module contains navigation groups, dashboard users can drill down and back to change the focus of their analysis by moving between levels of information. The users can drill down from column to column in the navigation group by either following the order of columns in the navigation group, or by choosing the column to which they want to proceed. Framework Manager Packages in Data Modules Now you can use a Framework Manager package as a source to a data module. This enables line of business users to extend IT managed metadata models with their own sources of data. You can combine a package with tables from other data modules and data servers, uploaded files, and data sets. Improvements to Loading Database Schema Metadata After defining a connection to a data server, you can load metadata for one or more schemas in the data server. Only schemas that have metadata loaded can be used in data modules.   11.0.4 Informational link Hiding Tables / Columns You can now hide tables and columns in a data module. The hidden tables or columns remain fully functional and visible in the modeling interface, but they are not visible in the reporting and dashboarding interfaces. Undo / Redo While designing a data module, you can now undo and redo changes made during your session. Clean NULL values Business users can get confused by the difference between zeros and NULL values. In 11.0.4 we’ve extended data cleansing options with NULL-handling operations. You can replace NULL values with text, numbers, and date/time values that you specify, e.g., for a Discount Amount column you can specify 0.00 to replace the cells where the amount is unknown (NULL). Validate We’ve added a validation feature to give you heads up if there’s something in your data module that won’t work in reports and dashboards. Erroneous objects in the data module are identified by red exclamation marks. Descriptions of errors and corrective actions are shown in the validation tray when it is open. Recognizing Time and Locations Cognos Analytics 11.0.4 will look for columns within a data module that contain time or geographic location data and mark them accordingly using the Represents property. You can overwrite these properties if Cognos Analytics incorrectly infers that a column contains temporal or geospatial information (perhaps a misleading column header?) or if column that does contain such information was overlooked. Smarter Relationship Detection In all versions of Cognos Analytics, you can use intent-driven modeling to add tables into your data module. Intent-driven modeling proposes tables to include in the data module, based on matches between the terms you supply and information in the underlying sources. In 11.0.4 we’ve added new smarts to intent-driven modeling to infer relationships (joins) between tables. I want to tell you all about the algorithms behind these smarts, but that would be giving away important trade secrets to our competitors!   11.0.3 Informational link Visual Modeling with an Actionable Diagram In all versions of Cognos Analytics, a diagram of the table relationships within a data module has helped data modelers understand how their data sets are connected. Now the diagram is more than just a visual aid in that you can perform actions on the tables and joins directly from diagram (in prior versions such actions were exclusively supported from the data module tree). This is something that comes naturally to new users especially since the diagram tends to occupy most of the screen. Storytelling 11.0.8 Informational link Highlight at point in time Kiosk Mode   11.0.7 Informational link Playback Animated Path Image library   11.0.6 Informational link New Guided Journey Templates Guided journey now contains four new templates to allow users to tell their stories in more engaging ways. New Animations Along side fade and slide we have introduced scale, zoom and pivot. Pin Enhancements When you pin an item the system will detect the fields contained in and the type of visualization. Based on this the system provides a “smart name”. This smart name is searchable from the top of the pin panel. Timeline enhancements We have made changes to the timeline in order to make authoring easier for you. The first enhancement was much like pins where we include smart names making it much easier to determine which items you are working with. In addition to this you can also re-arrange the order of timeline items to group items together. Change scene template You can now update the template while authoring if you decide that the initial one you selected is not suitable as you start to build out your story. The same capability also exists in dashboards for each tab.   11.0.5 Informational link  Infographic Summary The infographic summary provides a mechanism to easily visualize your data utilizing the built-in shapes available in dashboards in lieu of a standard number. Animations With Cognos Analytics 11.0.5, in addition to fade in and out, users can now select to have items slide in from the top, bottom, left or right of a scene. Guided Journey With Cognos Analytics 11.0.5, we are adding additional story arcs in the form of Guided journey.  11.0.4 Informational link This is the first release for Storytelling. It leverages the underlying Dashboarding technology but provides additional capabilities on top of this. Pinning As you are looking at and exploring other dashboards you can now select any widget and utilize the pin icon on the on demand toolbar to add this to your pin panel. Timeline Users can leverage the timeline capability to have items appear or disappear at certain points over the course of the story. Portal 11.0.9 Informational link Support for Planning Analytics Subsets   11.0.7 Informational link My Parameters Planning Analytics integration New Welcome screen New Home Button   11.0.6 Informational link Share and Embed In this release, we enhanced this feature by adding the ability to share/embed dashboards, reports, report saved output, and story that is open, through overflow menu on Application Bar. Custom Folder Custom folder allows you to define starting points for a user and eliminates the need for the Navigator portlet. Shortcut and create report view You can now create a shortcut in Cognos Analytics. A shortcut is a pointer to another entry such as a report, report view, dashboard, module, or folder. Another feature that we introduce in this release is to create a report view from context menu. Prior to release 11.0.6, you need to run a report to create a report view. In this release, we add the option to create report view without running the report from context menu. Managing OpenID connect namespaces Use the OpenID Connect namespace type to implement BlueID authentication for IBM Cognos Analytics. BlueID is the IBM Identity Service, a cloud-based identity access and management solution that provides identity and single sign-on services for IBM applications. Informational link   11.0.5 Informational link Sharing and Embedding Content In IBM Cognos Analytics 11.0.5, you can easily share IBM Cognos Analytics content objects with other users. You can share content objects, such as report, dashboard, story, data set and module with a URL that opens the content object directly, instead of having to navigate to the content object from the Cognos Analytics welcome screen. You can also embed Cognos Analytics content objects, reports, dashboard and stories in web pages. An embedded content object will not display the application or navigation bars by default but will remain interactive (if applicable). Role Customization Informational link In IBM Cognos Analytics 11.0.5, system administrators can now define a theme and a landing page for specific group of users. You can either specify a customized home view, or a particular report or dashboard, to be displayed when a user with a particular role opens IBM Cognos Analytics. In addition to home view and theme, you can specify what User Interface (UI) elements are available to group of users. License Management You can use the new Licenses panel to review licenses in use, export user license information, and restrict user access to the Cognos namespace. Informational link   11.0.4 Customizing IBM Cognos Analytics in 11.0.4 Informational link The IBM Cognos Analytics user interface is built on an extensible model. In this model, the user interface screens are defined as views (such as home, authoring, dashboard, and modelling). You can customize these views by adding and removing user interface elements, such as buttons and menus as well as define new views to extend the Cognos Analytics user interface. You can replace the default home and sign-in views. You can substitute your own theme (colors, logos, and brand text) for the default theming on all views. Data server 11.0.8 Informational link Amazon Athena Spark SQL Azure SQL Data Warehouse   11.0.7 Informational link Support for Presto Support for MemSQL Dynamic connection parameters in JDBC connections   11.0.6 Informational link Cognos Analytics 11.0.6 introduces support for Google BigQuery and Google Cloud SQL via the BigQuery JDBC and MySQL JDBC drivers, respectively. JDBC URL entry for Data Server Connections Data server connections under the Manage area of Cognos Analytics now offer an entry to paste in a JDBC URL. Feedback information when testing a connection When you successfully Test a connection to a data server, you can now see useful information like the server and client software versions and the time to connect (lag). Previously this information was only exposed in the Cognos Administration console.   11.0.5 Informational link New Data Sources As of Cognos Analytics version 11.0.5, the following technologies are officially supported: Snowflake Pivotal HDB Amazon Aurora (using the MySQL connection option) IBM Cognos Analytics Lifecycle Manager   All Versions Informational link Lifecycle Manager is a stand-alone application that helps validate and compare report outputs within a single environment, between environments or between different versions of Cognos. It is included as part of the Cognos offering without added cost to our customers.