John

Choose Your Favourite ExploringTM1 T-Shirt

Posted on Jul 31, 2018 by John

To celebrate almost 100,000 visitors to ExploringTM1.com and almost half a million page views, we have decided to create an ExploringTM1.com t-shirt to give away to the ExploringTM1 community and…

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…

Keen to chat? Book a discovery call!

pen