Cognos Analytics Configure SSL Certificate
Enhance the security of Cognos Analytics with an SSL certificate. Follow step-by-step instructions to configure SSL and protect your data.
ViewConstruct TM1 Function: Syntax and Use
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.
Display TM1 Attributes in Cognos Analytics Crosstab
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.
Setting Dimension Order for a TM1 Cube
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.
Setting the Java Virtual Machine (JVM) in Cognos
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 […]
Tuning Cognos BI and TM1 for Maximum Performance
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 […]
Forcing Cognos BI to Use Native TM1 Engine
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 […]
TM1/Cognos Security Integration Gremlin
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 […]
How to Rename a TM1 Model
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 with Examples
The definitive guide to TM1 security. How to configure different ways of managing security in TM1 with examples and screenshots that you can follow.
How to Import the New Visualisation Charts into IBM Cognos BI
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 […]
TM1 Tutorials remodelled with added analytics
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 […]
How to use TM1 Attributes in Report Studio
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 […]
How to use SPSS Modeler and Time Series Algorithms to Forecast Revenues
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. […]
Free Trial of Cognos Insight – Big Data Analytics
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 and Daptech to Merge
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 […]