TM1 Admin

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

TM1/Cognos Security Integration Gremlin

Posted on Feb 16, 2017 by John

Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have…

TI Connection Error to Cognos BI Report

Posted on Aug 8, 2016 by John

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a…

Connecting to Alternative TM1 Server

Posted on Aug 1, 2016 by John

If you’re like most of our clients you’ll have both a production and non-production environment for Planning Analytics or TM1. It is not real obvious though how you switch servers…

ViewZeroOut TM1 Function: Syntax and Use

Posted on Jul 1, 2016 by John

I came across this extremely simple method of just zapping the data from a view in a TM1 cube today, ViewZeroOut literally removes all data from a view. . Syntax The…

Refresh TM1 Contributor Approval Hierarchy

Posted on May 2, 2016 by John

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…

How to Add an Existing TM1 Server (Model)

Posted on Apr 13, 2016 by John

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…

TM1 Log File Cleanup

Posted on Apr 1, 2016 by John

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…

Installing TM1 Top

Posted on Oct 22, 2015 by John

Have you ever wanted to use TM1 Top with Planning Analytics?  Well as of 10.2 it is not available by default in CX.  You might even be wondering why you…

CubeSaveData TM1 Function: Syntax and Use

Posted on Oct 21, 2015 by John

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…

SaveDataAll TM1 Function: Syntax and Use

Posted on Oct 21, 2015 by John

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

Need help with TM1?
We're here for you



Keen to chat? Book a discovery call!