Creating a YTD Calculation in Planning Analytics (TM1)
In this post, we walk you through the steps to create a YTD calculation in Planning Analytics (TM1) to give users the values they need!
Relative Time Prompt Token Macro Technique
Prompt token macros are used to pass the definition of a data item rather than a value. They are very efficient and useful for both relational and dimensional data sources and prove to be a friendly administrative and end user experience. You can use the relative time token for scheduling purposes as well as a […]
Use a Variable in a TM1 TI Process SQL Statement to Filter on Input from a User
Variables can be used in a variety of ways in Turbo Integrator processes. The use of variables can increase efficiency by making the administration of your TM1 model easier. Variables can also play a role in providing an end-user with the ability to perform administrative tasks similar to typical user input. Many times SQL statements […]
TM1 Best Practices: The Power of Using Global Parameter Flags
TM1 is a completely customizable solution for budgeting and forecasting. It is extremely robust and flexible, but with that comes complexity. Two of the biggest challenges my customers face are the amount of time it takes to prepare their budgets and forecasts, especially if they are responsible for rolling monthly forecasts, and how difficult it […]