How to Create a User Defined Consolidation in TM1 Architect & Perspectives
Sometimes we want to create a rollup of elements from a dimension that does not exist in the dimension structure itself. We have a choice. We can either go back to the developers and have them add a new rollup, or in Architect and Perspectives, we can create what is called a User Defined Consolidation. […]
TM1USER TM1 Excel Syntax and Use
TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: Where: Example and Usage To provide an example of how this function is used, let’s consider a simple scenario. Suppose there is a server named “NebulaFit” and a user named Tom […]