TM1 Cell Security: How To Do It and Best Practices

TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the specific, to the cell if required. TM1 cell security places an overhead for your administrator to manage as it can get complex, not only within…

Read More

TM1 RoundUp Function: Method, Syntax and Use

The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method to achieve in TM1 what is available in Excel via the RoundUp function uses the INT function and some clever usage of negatives. Here it…

Read More

How to Limit PAX for Specific Remote Desktop Users

We have a client who operate remote desktop centrally for all their users – so most people don’t have, say, Microsoft Office installed directly on their local desktop. The exception is some laptops, but even then when they need to access shared resources, they need to connect to remote desktop to gain access to shared…

Read More