John

How to Restart TM1 Server Safely

Posted on Sep 2, 2015 by John

You might need to restart TM1 if it has become particularly non responsive or if memory consumption has ballooned or just because you want to restart it!. Restarting the TM1…

Exporting Data from TM1 to an External Database

Posted on Jun 18, 2015 by John

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,…

Exporting Data from TM1 to an External Database

Posted on Jun 18, 2015 by John

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,…

Exporting Data from TM1 to an External Database

Posted on Jun 18, 2015 by John

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,…

Exporting Data from TM1 to an External Database

Posted on Jun 18, 2015 by John

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,…

CellIsUpdateable

Posted on Jun 10, 2015 by John

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…

Change Cognos Express Backup Location

Posted on Jun 9, 2015 by John

Cognos Express has an internal backup tool that collects almost everything into a single backup.  It is run from the CX Manager screen manually.  By default it stores the backups…

Automatically Add Formatting to a Cognos Report on a TM1 Cube

Posted on Apr 21, 2015 by John

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…

Sort Order of a TM1 Dimension in Cognos BI

Posted on Apr 21, 2015 by John

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…

Sort Order of a TM1 Dimension in Cognos BI

Posted on Apr 21, 2015 by John

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…

Keen to chat? Book a discovery call!

pen