Uncategorized

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.

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…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LONG TM1 Function: Syntax and Use

Posted on Feb 25, 2016 by John

The LONG function in TM1 returns the length of a string as a value.  It is similar to the LEN functions available in both Excel and SQL Server. Syntax of…

LEFT TM1 Function: Use and Syntax

Posted on Feb 25, 2016 by John

The LEFT function from Excel does not exist in TM1. We need to use SUBST instead. Where you have a formula in Excel in A2 that is = LEFT (…

DBRA TM1 Excel Syntax and Use

Posted on Oct 27, 2015 by John

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…

Using TM1 Log Files

Posted on Sep 24, 2015 by John

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…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles