Category Archives: TM1 Administration

Cascading Element Level Security in TM1

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.

This entry was posted in Security, TI Coding, TM1 Admin, TM1 Administration, Turbo Integrator and tagged CAM Security, element level security, Element Security, Security. Bookmark the permalink. | Tagged CAM Security, element level security, Element Security, Security | 1 Comment

Setting Dimension Order for a TM1 Cube

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.

This entry was posted in Cognos BI, Cubes, Dimensions, Performance and tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance. Bookmark the permalink. | Tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance | Leave a comment

How to Rename a TM1 Model

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

This entry was posted in Cognos BI, TM1 Administration and tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service. Bookmark the permalink. | Tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service | Leave a comment

How do Delete a TM1 Service

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 entry was posted in TM1 Administration and tagged NT Service, TM1 Server, Windows Service. Bookmark the permalink. | Tagged NT Service, TM1 Server, Windows Service | 1 Comment

TM1 Stargate Views Explained

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

This entry was posted in Administration, Performance and tagged Stargate. Bookmark the permalink. | Tagged Stargate | Leave a comment

Email TI Process and Chore Results

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

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

Refresh TM1 Contributor Approval Hierarchy

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

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

The Definitive Guide to Migrating TM1 from Development to Production

Migrating or Deploying TM1 from one environment to another is difficult. This best-practice guide presents two methods that can be used step-by-step to help ensure that your migration is successful. It also includes a downloadable checklist that you can modify to suit your specific TM1 servers and models.

This entry was posted in Migration, TM1 Administration and tagged Deployment, Dev to Test, Migration, Test to Prod. Bookmark the permalink. | Tagged Deployment, Dev to Test, Migration, Test to Prod | 1 Comment

How to Add an Existing TM1 Server (Model)

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

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

TM1 Log File Cleanup

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

This entry was posted in TM1 Admin, TM1 Administration. Bookmark the permalink. | 2 Comments