Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.
DimensionElementPrincipalName allows you to look up the primary ID of an alias in a dimension in TM1 in a TI process.
The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.
Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.
Here is a great way to create virtual dimensions in TM1 based on attributes. These allow you to intersect multiple virtual dimensions from the same physical dimensions in a PAW or PAX report. Here we discuss the CreateHierarchyByAttribute function and give an example on how to use it.
How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.
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,
Discover the Benefits of Using Picklists in TM1 for High-Quality Data! Learn about the Various Types of Picklists, How They Can Help You, and How to Create Them. Enjoy In-Cell Drop-Downs in TM1 with Ease!
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
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 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
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,
Syntax and use for AttrPutS for assigning a string to an attribute on an element in a TM1 dimension via a Turbo Integrator (TI) script for TM1 and Planning Analytics, with a warning about using it on the same TI tab as a DimensionElementInsert.
Attributes are one of the core components of TM1. They allow you to describe and categorise elements, use alternate descriptions or IDs and to build virtual hierarchies and dimensions.
ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to retrieve the value of a string attribute.
TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases. With TM1 it is also very common to work with various other attributes. But when
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
