This is a great explanation of the different types of logging within TM1 for setting the different logging options to DEBUG mode. This article was written for people to submit logs to support, however is a great explanation of logs in TM1. For most TM1 Logging, they can be modified so you are not recording at DEBUG level, but rather at a higher, less granular level. The source of this … Continue Reading
So a very frustrating day yesterday trying to install Cognos Express 10.2.1 Fix Pack 3 (FP3). Previously I had applied FP3 to the server in question, however was surprised to find that required java files were not present when I went to adjust the settings to display jpg files in BI. So I logged a call with IBM and it became apparent that Fix Pack 3 of CX 10.2.1 had … Continue Reading
Restarting a TM1 server is really easy. And really easy to do it badly. Here is our guide for how to restart a TM1 service safely. Enjoy!
I needed to create a rollup in a data warehouse the other day from elements that are stored in TM1. This process works just as well for SQL Server, Oracle, DB2 or any other database engine. Simple Method to get data out of TM1 and into a Database Simply, the easiest way to get data out of TM1 and into a database is to publish it out of TM1 using … Continue Reading
The CellIsUpdateable function allows us to test if a cell in a cube can be written to. If true, the function returns a 1, if false a 0. Syntax of CellIsUpdateable The syntax is CellIsUpdateable(Cube, element1, element2, elementn); where: Cube, is the cube you are testing, Element1, is an element from the first dimension of that cube that is at the intersection to be tested, Element2, is an element from the second dimension of that … Continue Reading
Cognos Express has an internal backup tool that collects almost everything into a single backup. It is run from the Cognos Express Manager screen manually. By default it stores the backups it creates inside the installation folders of CX. Saved here, they are easily lost and also easy to delete when upgrading Cognos Express (where you need to do a full uninstall). As you need to restore one of these … Continue Reading
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 order. All good. Now I look at the resulting report and there is no formatting of different elements. Simple formatting like a single line above subtotals and a double underline below the grand total. What accountants really want in a … Continue Reading
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 it. For example, in TM1 I have a PnL dimension and is viewed normally with Net Profit after Tax at the bottom, Tax Expense just up from it, Net Profit before Tax above that and then all the way up … 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