Exploring TM1

Great TM1 and Cognos content brought to you by Infocube

Discover More Here!

DBRA TM1 Excel Syntax and Use

DBRA is an Excel based function for use with TM1 that retrieves the value of an Attribute from a Dimension in TM1. It is roughly equivalent to using a ATTRS in a Rule or TI. Example For example if I have a dimension called Customer with an attribute called Channel. An element of this dimension is called “Fred Bloggs” (he’s a customer) and his Channel is “Retail”.  In this case “Retail” would … Continue Reading

Display TM1 Attributes in Excel

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA and refer to the control cube for the relevant dimension in the Excel formula. Example I have a dimension called Customer.  In this dimension there is an attribute called Channel. There is an element called “Fred Bloggs” (he’s a customer) and … Continue Reading

Installing TM1 Top

Have you ever wanted to use TM1 Top with Cognos Express?  Well as of 10.2 it is not available by default in CX.  You might even be wondering why you would want to use TM1Top?  Well, if like me, you have created a process that has then sent the server into a tail spin and need to kill it, then you will need TM1 Top. The trick for installing TM1 … Continue Reading

CubeSaveData TM1 Function: Syntax and Use

This is just like the SaveDataAll command, except it is cube specific, rather than saving the data for all cubes.  Thus if you have an environment where you have a bunch of cubes where data is being constantly entered (like a planning application) and you also have some analytic cubes that are refreshed from a data warehouse every day, you might like to consider saving the new data in each … Continue Reading

SaveDataAll TM1 Function: Syntax and Use

As you undoubtedly know, TM1 is an “in memory” application, in that the data resides completely in memory in much the same way as Microsoft Excel.  And just like Excel, where if you quit from Excel before saving, you loose your data, in TM1, if you shut down TM1 without saving the data, you loose it.  To get around this there is a command you can use in a Turbo Integrator … Continue Reading

TM1 SaveDataAll Data Locks

Recently I encountered a situation where we had a SaveDataAll process running every half hour that had started impacting the system performance.  The environment is largely for enterprise planning and we wanted the protection of having TM1 saved to disk regularly through the day to protect against any unforeseen outages. This was largely able to be executed in a couple of seconds and thus had no real impact. Then we added … Continue Reading

Changing TM1 Server Log Time Zone Stamp

Ever wondered how to set TM1 logging to use local time, rather than GMT (UTC)? Here’s how to set the logging of your TM1 Server to use your local time zone

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

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

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!