Category Archives: BI Admin
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 to configure is the Java Virtual Machine, or JVM. Wikipedia defines a Java Virtual Machine … Continue Reading
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 Manager to prepare data from a database before it is loaded into TM1, we can … Continue Reading
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 is extremely slow on large queries. Anecdotally it appears to want TM1 to return the … Continue Reading
What order do I use to restart Cognos BI and TM1 servers in a distributed environment? We are currently doing a project where there is a TM1 server, two Cognos BI application servers and a gateway server. The fundamental approach is to stop people from accessing the environment and then stop the applications themselves. The order to stop and start them is the exact reverse of each other. To stop the … Continue Reading
One of the really cool features of the integration between TM1 and Cognos is the ability to import views of Perspectives worksheets from TM1 into Cognos BI where they can then be used for both analyses and for write-back. Imagine you had a simple variance analysis TM1 Perspectives form. GL accounts, Actuals for this month and last month, variance calculations for both value and percentage and an explanation column for … Continue Reading
This is quite easy. Just go to Cognos Express Manager (http://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it in BI, the servername as the Administration Host, the TM1 server name (“CXMD”), the TM1 cube name you want to add to BI and finally the namespace (“CognosExpress”).
Often we build a TM1 dimension using codes or ID’s from another system. For example Product ID’s or Customer Codes. These are not particularly usable to most people, so we then usually create Aliases in TM1 as well. Those aliases are visible through in Cognos BI. Therefore when defining a dimension in TM1 when it is likely that it will be used in Cognos BI, also add an alias with … Continue Reading
I am in the middle of setting TM1 up for use with Cognos BI. One of the things I like in BI is being able to present levels with business names rather than just level numbers. To define these level names, open the control cube }HierarchyProperties and then orient it so that dimensions are listed as rows and HierarchyProperties are columns. Then enter the default Member and the names to describe … Continue Reading
One of the new features with IBM Cognos Express (CX) 10.2.1 is that it supports Microsoft Analysis Services (MSAS) cubes. So we are going to demonstrate how you can import MSAS cubes in Cognos Express. Of course the process is the same for IBM Cognos Enterprise.
For those who don’t know, The new visualization engine (RAVE) underpinning most of the IBM business analytics products is capable of some stunning visualisations. There is a gallery of sample visualisations on Analytics Zone (.com).