John
How to Restart TM1 Server Safely
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
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
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
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
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
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
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
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
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
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!