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.
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.
In our first post introducing this series on the TM1 SDK, we provided some background on what is the TM1 SDK and why we think it’s worth learning about, even if you aren’t sure if you’d ever need to use it. Since it’s officially summer here, we thought for the second article in our series on the TM1 SDK we’d throw you into the deep end of the pool with one of the most significant TM1 SDK components: the TM1 REST API. If you think you won’t be able to swim, don’t worry: we’ll make sure you stay afloat with a handy, free application called Postman. We’ll show you how to use Postman to do the same kinds of things you might do today with TM1TOP or Operations Console, but using the TM1 REST API with NO programming.
Gary Quirke and I had the pleasure of organizing and presenting “A Power Users' Guide to the TM1 SDK and Planning Analytics” at the 2016 IBM Vision conference on Orlando, Florida. Our goal for the presentation was to provide attendees with a picture of the possible with the TM1 SDK, targeted toward both non-programmers and programmers who simply want to understand the alternative ways in which we can solve real business problems, new and old, using the powerful TM1 SDK tools that IBM has provided, which include the REST API, Java Extensions and TM1 Web APIs. We received very positive feedback, so thank you to everyone who was able to attend!
Effective dashboards form the backbone of a powerful business intelligence strategy, as well as the essential entry point in becoming an analytics-driven organization. Dashboards support fast and effective decision-making, provide valuable insight into key performance indicators, and make reporting simple and fast.