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