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 […]