A complete guide to deploying and configuring the TM1 BI Interop files to Cognos, so that TM1 and Cognos can communicate properly.
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.
This is a comprehensive guide to configuring TM1 to use Cognos CAM security. It includes why you might connect Cognos security to TM1, TM1 environment changes and how to deploy and configure the BI Interop files to your BI application and gateway servers.
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 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
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
Here is the order to restart a combined Cognos Analytics and TM1 environment to ensure all connections are re-established correctly.
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
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
We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a
So I have my TM1 cube successfully published to Cognos BI. I have the sort order defined so that I have my elements of my PnL appearing in the right
This morning I have been working with Cognos BI over a TM1 cube. I was frustrated that I couldn’t work out how to sort a dimension the way I wanted
This is quite easy. Just go to Cognos Express Manager (https://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it
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
How to set the default member and set level names for a TM1 dimension to be used in Cognos Analytics. This means you don’t need every dimension defined in a Cognos report and gives useful names for levels in Cognos hierarchies.
You can use data published through Cognos BI as a data source for TM1. I had heaps of trouble trying to make this to work. It was very frustrating, but
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
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
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
