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.
TM1 Perspectives Excel-based Report Methods
Here is another minor extract from TM1 Tutorials.com training material. We talk through the common sustainable reporting methodologies within TM1 Perspectives for Microsoft Excel. These being: Perspectives Reports This isn’t an exhaustive list, but we believe these are reporting styles TM1 Consultants should at the very least know of when doing Excel reporting with Perspectives.The common methodologies […]