ELCOMP TM1 Function: How to Use and Syntax
In TM1, ELCOMP returns the child element at a specified numeric position of a parent. Full syntax and explanation for use.
ELCOMPN TM1 Function: How to Use & Syntax
In TM1 and Planning Analytics, ELCOMPN returns the number of children an element has Full syntax and explanation for use.
Calculating “As At” Values in a TM1 Rule
Have you ever needed to calculate the value “as at” a point in time? For example, you have an inventory cube and want to show the volume of stock at the end of a quarter, or end of the year. You might have values in each month, but if you use a regular consolidation for […]
How to Unwind a Dimension in TM1
This is a case study of how to unwind a dimension without deleting all the elements. Includes simple TI code that you can use.