DimensionHierarchyCreate function for IBM Planning Analytics (TM1)  DimensionHierarchyCreate creates a hierarchy in a dimension. No elements will be inserted in the hierarchy. In the video, the DimensionHierarchyCreate will be used to create the hierarchy, United Kingdom, in the Sales Region dimension. Where can the DimensionHierarchyCreate function be used? TurboIntegrator Which TM1 Server version is the DimensionHierarchyCreate function available…

DimensionSortOrder function for IBM Planning Analytics (TM1)  DimensionSortOrder sorts the elements and components of consolidations within a dimension. In the video, the DimensionSortOrder will be used to sort the components by name and elements by level in ascending order. Where can the DimensionSortOrder function be used? TurboIntegrator Which TM1 Server version is the DimensionSortOrder function available for? Version 11 and 12 What is…

DimensionTimeLastUpdated function for IBM Planning Analytics (TM1)  DimensionTimeLastUpdated returns a serial value indicating the date and time when a dimension was last updated. Use TIMST to convert the value to a date/time format. In the video, the DimensionTimeLastUpdated will be used to get the serial date/time value on when the Sales Region dimension was updated. Where can the…

DeleteClient function for IBM Planning Analytics (TM1) DeleteClient deletes an existing client from the server. In the video, DeleteClient will be used to delete the client, Steve, from the server.  Where can the DeleteClient function be used? TurboIntegrator Which TM1 Server version is the DeleteClient function available for? Version 11 and 12 What is the syntax for…

DimensionDeleteAllElements function for IBM Planning Analytics (TM1)  DimensionDeleteAllElements deletes all elements in a dimension. In the video, the DimensionDeleteAllElements will be used to delete all elements in the dimension, ‘A New Dimension’. Where can the DimensionDeleteAllElements function be used? TurboIntegrator Which TM1 Server version is the DimensionDeleteAllElements function available for? Version 11 and 12 What is…

CubeSetLogChanges function for IBM Planning Analytics (TM1) CubeSetLogChanges sets the logging property for a cube. In this video, CubeSetLogChanges is used to show the impact of turning logging on and off for the Product Scorecard cube. Where can the CubeSetLogChanges function be used? TurboIntegrator Which TM1 Server version is the CubeSetLogChanges function available for? Version 11 What…

DimensionElementComponentDeleteDirect function for IBM Planning Analytics (TM1)  DimensionElementComponentDeleteDirect deletes an element from a consolidated element. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementComponentDelete.​ In the video, the DimensionElementComponentDeleteDirect will be used to delete the element Denmark from the consolidated element Scandinavia…

ElementSecurityGet function for IBM Planning Analytics (TM1) ElementSecurityGet retrieves the security level assigned to a specified group for a dimension element. In the video, ElementSecurityGet will be used to retrieve the security level assigned for the ‘Finance’ group against ‘Net Income’ in the ‘Account’ dimension. Where can the ElementSecurityGet function be used? TurboIntegrator Which TM1 Server version is the ElementSecurityGet function available…

DimensionElementDelete function for IBM Planning Analytics (TM1)  DimensionElementDelete deletes an element in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementDeleteDirect. In the video, the DimensionElementDelete will be used to delete the element Wales from the dimension, Sales Region. Where can the DimensionElementDelete function…

ElementSecurityPut function for IBM Planning Analytics (TM1) ElementSecurityPut assigns a security level to a specified group for an element. In the video, ElementSecurityPut will be used to assign a security level to the Finance group, for the Net Income in the Account dimension. Where can the ElementSecurityPut function be used? TurboIntegrator Which TM1 Server version is the ElementSecurityPut function available for? Version…