Category Archives: TM1 Administration
Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName” Edit the value after the equals sign to reflect the new model name Save tm1s.cfg Open Cognos Configuration for TM1 Change the name of the TM1 Server Save Cognos Configuration Start the TM1 Server (right click, start) in Cognos Configuration … Continue Reading
How to delete a redundant TM1 service from Windows. Sometimes we need to delete a TM1 service. After changing the name for a TM1 model, for example, we may be left with a Windows Service still existing for the old model. This explains how to remove a redundant TM1 server.
This is a fabulous article from our friends at Ironside in the US. The original article is available here. There are various approaches available to enhance the performance of your TM1 application. One such approach is to leverage Stargate Views. Stargate Views are different from traditional view objects and represent cached subsections of cubes that get created through user experience. As users browse cubes via the Cube Viewer or consume cube … Continue Reading
Need to email your TM1 Admin upon a TI failure? TM1 models are usually updated from a third party data source. Sometimes those loads fail and TM1 does a great job in recording in its log files what caused the error. What it doesn’t do out of the box is email the TM1 administrator of the failure. We have a standard method that involves having a process that executes a Windows … Continue Reading
I was just updating the approval hierarchy on a TM1 Contributor model and could not see the changes through on the web app. Odd, I thought. So I did some digging around and found that the solution to that specific problem is to re-save the Rights in Performance Modeller even if you have no rights in there in the first place. Some what counter-intuitive I reckon! So the whole process … Continue Reading
TM1 migration isn’t the strongest point of this great tool. Pretty well all TM1 installations should have a Dev, Test and Production server or TM1 instance. This allows us to build and experiment in Dev, test our changes and then migrate what we want to Production – without breaking Production with an error during development! This will guide you through the important steps for migrating TM1 from development to production. … Continue Reading
Sometimes we will want to add a copy of an existing TM1 model (server) to our TM1 environment. We might want to do this if, for example, we want to have a Development and Production model that are separated, but on the same server, or we might have been sent a model by someone else and want to be able to use it. To do it is dead easy! How to Add an … Continue Reading
One of the things that is often overlooked in TM1 is to clean up the log files. There are a few different types of log files, one of which is created every time a SaveDataAll or a CubeSaveData is executed. These save the data in TM1 cubes out to disk, so that if the server crashes, TM1 will be loaded with the last saved data set. Thus you can end up with many of these log … Continue Reading