Using TM1 Log Files

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

This entry was posted in Administration, TM1 Admin, TM1 Administration, TM1Top. Bookmark the permalink. | Leave a comment

Cognos Express 10.2.1 Fix Pack 3 Installation Issues

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

This entry was posted in Administration, Fix Packs, Installation. Bookmark the permalink. | Leave a comment

How to Restart TM1 Server Safely

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!

This entry was posted in Administration, TM1 Administration, TM1Top and tagged restart, Server Restart. Bookmark the permalink. | Tagged restart, Server Restart | Leave a comment

Exporting Data from TM1 to an External Database

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

This entry was posted in TI Processes, TM1 Administration. Bookmark the permalink. | Leave a comment

CellIsUpdateable

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

This entry was posted in TI Functions and tagged CellIsUpdateable. Bookmark the permalink. | Tagged CellIsUpdateable | Leave a comment

Change Cognos Express Backup Location

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

This entry was posted in Backups. Bookmark the permalink. | Leave a comment

Automatically Add Formatting to a Cognos Report on a TM1 Cube

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 entry was posted in Cognos BI. Bookmark the permalink. | Leave a comment

Sort Order of a TM1 Dimension in Cognos BI

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 entry was posted in Cognos BI. Bookmark the permalink. | Leave a comment

Add a TM1 cube to BI in Cognos Express

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”).    

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

Using TM1 Aliases in Cognos BI

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

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment