Attributes

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.

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 have recently done 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…

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

The Pick List – How to Create and Use Picklists in TM1

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) a value from a standard dropdown list of options. For…

ATTRN TM1 Function: 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. Syntax of ATTRN The syntax is ATTRN…

Display TM1 Attributes in Excel

Posted on Oct 26, 2015 by John

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA…

AttrPutN TM1 Function: Use and Syntax

Posted on Mar 19, 2015 by John

AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current element in a specified dimension. Note that this function does not insert…

AttrPutS and AttrPutN Doesn’t Work!

Posted on Mar 19, 2015 by John

Attribute Definition Problem I just had an instance where I was adding new elements to a dimension in TM1 and then wanted to define an attribute for those new elements.  Easy,…

AttrPutS TM1 Function: Use and Syntax

Posted on Mar 18, 2015 by John

AttrPutS is a TM1 Turbo Integrator function that inserts a string onto a specific attribute for the current element in a specified dimension. Note this does not insert a value…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles