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
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
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
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
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
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
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
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
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
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
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
Variance Analysis and Commentary using TM1