Blog

Sasidaran MR

How to improve the performance of a Dynamic Subset?

Posted by Sasidaran MR on December 18, 2017

As a TM1 consultant, one of our challenging tasks is improving performance.

Often dynamic subsets cause memory leakage and in turn affect performance. Let’s discuss, how to convert dynamic subset to static subset with an example.

Read More

Topics: Technical, Business Intelligence, PlanningAnalytics, TM1

It's important to know how to handle null values in TM1

Posted by Sasidaran MR on October 10, 2017

By default a numeric value in TM1 is 0. If an attempt is made to store a zero in a cell of the cube, that storage request is ignored. If we input 0 for an intersection, TM1 treat it as NO value instead of 0 value. Instead we can use the UNDEFVALS function. This is to be defined in the Rules file which will enable the end user to input 0 value.

Read More

Dimension Element Security

Posted by Sasidaran MR on June 25, 2017

Element Security is to set security at dimension element level. Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object.  Element security will be defined in} ElementSecurity_<DimensionName>.cub. By default element security is set to WRITE access to all the members

 

Different type of Access Privileges

Admin: Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object

Lock: Members of the group can view and edit an element and can permanently lock objects to prevent other users from updating them.

Read More

Topics: Technical