This article describes how TM1 users can use Subsets in Excel based TM1 Reports (specifically referenced by DBRW and DBR formulae) and within cube views.
Organizations using IBM Cognos TM1 have many options for front-ends. There are a lot of good options out there, including some important new arrivals. This post discusses one of the newer front ends, Café, that has some useful new properties heretofore unavailable, most notably, the ability to utilize TM1 in Excel over a Wide Area Network (WAN.) Anyone that’s ever tried to use the Excel Perspectives add-in over the WAN will appreciate this new capability!
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.
*Note: Learn more about QueBit & IBM® Cognos Analytics here.
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.”
In this article we delve into the DBRW function in IBM Cognos TM1. Read on for our rundown of what it is, when to use it, and how to fix it when it's broken.
Topics: TM1, Cognos Analytics
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.
