One of the major challenges of promoting code to successive instances is packaging the code for promotion and finding a slot for downtime. Not to mention the sequence of steps required to carry out the procedures and to communicate to one and all about the impending downtime. Adding to this difficulty is finding downtime when users are accessing the application from across the globe.So irrespective of deployment size, either major or minor, the deployment process is never going to be easy. However you can potentially overcome this using one of the TM1 Suite tools.
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.
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.
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.