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.

Display TM1 Attributes in Cognos Analytics Crosstab

Posted on Dec 16, 2019 by John

We need to create a series of P&L reports in Cognos Analytics over a TM1 cube. We need Accounts to display with their ID and their current Description. Then when…

DimensionElementPrincipalName, How to Use and Syntax

Posted on Sep 19, 2019 by John

Today I needed to lookup an element ID from an alias in a TI process.  I found the DimensionElementPrincipalName function that looks up the TM1 element principal name from the…

TM1 Clear Attribute – an AttrClear Function

Posted on Jun 7, 2019 by John

We have a client where we need to update a Relative Time attribute on a time dimension each month so that the new month is referred to as “Current Month”…

How to Create Virtual Dimensions in TM1/Planning Analytics

Posted on Nov 1, 2018 by Boon Ong

Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability.  Here we briefly discuss what they are and then what you need to…

Days in Month – How to Easily Calculate in a TM1 Rule

Posted on Aug 25, 2018 by John

Calculating the number of days in a month is used for a number of financial calculations, such as inventory days and debtor days. Have you ever wondered though how to…

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Posted on May 31, 2018 by Boon Ong

We once did a project where we needed to create an excel report showing attributes from the same dimension as the rows and columns in a report. Traditionally in TM1,…

"Joining" Text Files in a TM1 Turbo Integrator Process

Posted on Jun 16, 2017 by John

I was faced with an interesting situation yesterday. I needed to load information from a header and a detail table into TM1. So, just do a join in the TI,…

AttrInsert TM1 Function: Use and Sytax

Posted on Oct 31, 2016 by John

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process. This function allows us to do that and create either a string,…

Picklists in TM1: How to Create and Use Them

Posted on Oct 27, 2016 by John

Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select from a validated list) a value from a standard dropdown…

ATTRN TM1 Function: How to Use and Syntax within TI and Rules

Posted on Dec 21, 2015 by John

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Note this is not AttrGetN! That function…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!