DimensionElementComponentAddDirect function for IBM Planning Analytics (TM1)  DimensionElementComponentAddDirect adds an element to a consolidated element in a rollup according to a specific weight in a dimension. 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 DimensionElementComponentAdd. In the video, the DimensionElementComponentAddDirect will be…

DataMinorErrorCount function for IBM Planning Analytics (TM1) DataMinorErrorCount counts minor errors that occur in the Data tab. In this video, DataMinorErrorCount is used to count minor errors when exporting data from the Finance cube. Where can the DataMinorErrorCount function be used? TurboIntegrator Which TM1 Server version is the DataMinorErrorCount function available for? Version 11 and 12 What is…

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

DimensionElementPrincipalName function for IBM Planning Analytics (TM1)  DimensionElementPrincipalName returns the principal name of an element or element alias. In the video, the DimensionElementPrincipalName will be used to get the principal name of the Australian Dollar in the Currency dimension. Where can the DimensionElementPrincipalName function be used? TurboIntegrator Which TM1 Server version is the DimensionElementPrincipalName function available for? Version 11…

DimensionExists function for IBM Planning Analytics (TM1)  DimensionExists checks whether a dimension exists. If the dimension exists, the result is 1; if it does not, the result is 0. In the video, the DimensionExists will be used to check if the dimension, A New Dimension, exist. Where can the DimensionExists function be used? TurboIntegrator Which TM1 Server version…

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…