It is now possible to hide tables and columns in a data module. They are still visible in the modeling interface (a new grey icon) but they are completely hidden from the reporting and dashboard interfaces. The Undo / Redo options have also been added to Data Module design, it is also now possible to control how NULL values are displayed to business users. Data Module validation has been added plus there are now two new field types that are recognized, Geo Location values and also Date Time values.
This blog entry is an update to our blog posted on Sept 27, 2016 Titled How to Fix TM1’s Expiring SSL Certificates.
IBM released the latest version of Cognos Analytics (Cognos 11.0.4) on September 16, 2016. This newest version includes some exciting enhancements extending the broad capabilities of the product. It’s available for download from the normal locations. There is a new upgrade process for Cognos Analytics which is different from previous versions. You no longer have to go through a migration/upgrade path, it’s as easy as installing it over what you already have to quickly access all the new features and enhancements.
This is a follow up to our blog post titled, “QueBIT Blog - WARNING: TM1 may STOP WORKING on November 24, 2016.” This blog takes a critical look at all of the available solutions to solve the upcoming TM1 SSL expiration issue. It also provides a way to find the best solution for your TM1 system, as well as methods to test the solution was successful.
For more information on QueBit TM1 services see:
IBM Cognos TM1 is a great planning, forecasting and reporting system. One of its functionalities is to communicate meaningful results to different stakeholders. Many types of reports are used as a vehicle to achieve that goal. One of the common ways to drive most reports is with the DBRW function. While some users are familiar with it, most users only notice the function when they see the error message “*KEY_ERR.”
IBM Cognos TM1 ships with a digital certificate called an SSL (“secure Socket Layer”) certificate that is used to securely encrypt communication between the TM1 server and its web and non-web (TM1 Perspectives and TM1 Architect) clients. It’s basically a set of files that sit on the TM1 server. These certificates have expiration dates and it was recently realized that the one that ships with TM1 will expire on November 24, 2016 causing any TM1 server using the certificate to stop communicating with its clients. In other words: TM1 will STOP WORKING unless the certificate files are replaced.
The term ad-hoc report development has long been part of the analytics lexicon, dare I say a buzzword. The idea of self-service analytics has been a clarion call for many of the major analytics providers - create tools and environments that empower the business users to develop their own analytics, with little or no support from IT required. This self-fulfilling prophecy has never fully materialized, and has only been relevant on the report development side of the analytics functions spectrum.
As mentioned in the previous blog post, the new release of Cognos Analytics presents an entirely new experience across the IBM analytics professional spectrum from consumer, to report/dashboard developer, to data modeler. Perhaps the most exciting and compelling changes are experienced by individuals actively curating, developing, and sharing analytics in Cognos.
Topics: Cognos Analytics
The official release of IBM Cognos Analytics (aka Cognos 11) represents a major re-write of the Cognos business analytics tools (not to mention, a re-branding of a re-brand). I’ve recently attended a Cognos Analytics training session and spent some time working in a Cognos Analytics environment.