Configuring SSL Certificate to Cognos Analytics server provides an extra layer of security that verify the website’s identity. Pre-requisite The following conditions must be met before you proceeding to configuring Cognos Analytics. Import SSL Certificate in Cognos Analytics Do the following step to be able to retrieve the individual files of the certificate chain ( […]
The ViewConstruct function allows you to regenerate a view via a TI so it is then saved in memory on the server. Here we explain the syntax and how to use it.
Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. The next setting that we need […]
Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and can significantly enhance both the speed and usability of both tools. How can BI and TM1 be Integrated When used together we can use Framework […]
There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. Bluenose is the default and it […]
Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have the integration working perfectly with TM1 cubes performing brilliantly in BI, TM1 cubes able to have data entered into them from Cognos Workspace and security […]
Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName” Edit the value after the equals sign to reflect the new model name Save tm1s.cfg Open Cognos Configuration for TM1 Change the name of the […]
The definitive guide to TM1 security. How to configure different ways of managing security in TM1 with examples and screenshots that you can follow.
The new visualisation engine from IBM (RAVE) looks amazing and within this article we will show you how to access the charts and use them within report studio. Note that they can be used in traditional reporting and active reports. First step is to go to Analytics Zone. This is an IBM site where you can […]
I’m pleased to announce that TM1 Tutorials.com has had a complete rebuild and today we have launched the new site, just in time for IBM Information On Demand (IOD). Please head on over to the new and improved TM1 Tutorials.com and see for yourself what all the fuss is about! You can also track our […]
TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases. With TM1 it is also very common to work with various other attributes. But when you create a package with framework manager you can choose what alias you want to show in reports. So you normally use the name as […]
A planning exercise typically involves a batch of spreadsheets, which probably look chaotic and consumes a lot of time to maintain. A much better, more efficient and optimised option is to use specialised software for this work, like TM1. Using TM1, speeds up the process considerably and the planning process is a lot more efficient. […]
A free trial of Cognos Insight is available for download on Analytics Zone – Download Now. What is Analytics Zone? Analytics Zone is a community portal focusing on Big Data Analytics. Its a great place for connecting with other analysts and data scientists, downloading modelling (Not “Project Runway”) resources, tutorials and catching up with the latest Big Data […]
InfoCube, a Sydney-based management accounting and business analytics specialist, and enterprise planning software experts Daptech will merge their businesses to create InfoCube Consulting (Australia) Pty Ltd. Commencing trading on July 9, the new entity will continue to provide clients such as Woolworths, Goodman Fielder, News Limited, Schneider and Hunter Douglas with superior Cognos service and […]