HierarchyElementInsert function for IBM Planning Analytics (TM1) HierarchyElementInsert adds an element to a hierarchy. 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 HierarchyElementInsertDirect. In the video, HierarchyElementInsert will be used to add Scotland as a numeric element, positioned before Wales, an element in the United Kingdom hierarchy from…

FileExists function for IBM Planning Analytics (TM1) FileExists searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned.  In this video, FileExists is used to check if the file, Product Scorecard.txt and ProductScorecard.txt, exists in a folder. Where can the FileExists function be used? TurboIntegrator Which TM1 Server version is…

HierarchyElementComponentDeleteDirect function for IBM Planning Analytics (TM1) HierarchyElementComponentDeleteDirect deletes a component (child) from a consolidated element in a specific hierarchy 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 HierarchyElementComponentDelete. In the video, HierarchyElementComponentDeleteDirect will be used to delete Netherlands as a…

ExecuteCommand function for IBM Planning Analytics (TM1) ExecuteCommand executes a command line. In this video, ExecuteCommand is used to archive a file and rename it with the current timestamp.  Where can the ExecuteCommand function be used? TurboIntegrator Which TM1 Server version is the ExecuteCommand function available for? Version 11 What is the syntax for ExecuteCommand? ExecuteCommand(CommandLine, Wait)…

HierarchyElementDelete function for IBM Planning Analytics (TM1) HierarchyElementDelete deletes a member element of a specific hierarchy. 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 HierarchyElementDeleteDirect. In the video, HierarchyElementDelete will be used to delete Netherlands from Benelux consolidation in Western Europe hierarchy from the Sales Region dimension. Where can the…

ExecuteProcess function for IBM Planning Analytics (TM1) ExecuteProcess executes a process.  In this video, ExecuteProcess is used to run a Bedrock process that exports data from the General Ledger cube. Where can the ExecuteProcess function be used? TurboIntegrator Which TM1 Server version is the ExecuteProcess function available for? Version 11 and 12 What is the syntax for…

HierarchyElementDeleteDirect function for IBM Planning Analytics (TM1) HierarchyElementDeleteDirect deletes a member element of a specific hierarchy 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 HierarchyElementDelete. In the video, HierarchyElementDeleteDirect will be used to delete Netherlands from Benelux consolidation in Western Europe hierarchy from the Sales…

ProcessAttrN function for IBM Planning Analytics (TM1) ProcessAttrN retrieves data from a numeric attribute for a process.  In this video, ProcessAttrN will be used to retrieve the Reference Number from the TrainingProcess process. Where can the ProcessAttrN function be used? TurboIntegrator Which TM1 Server version is the ProcessAttrN function available for? Version 11 and 12 What is the syntax for…

HierarchyExists function for IBM Planning Analytics (TM1) HierarchyExists checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1, and if it does not exist, the result is 0. In the video, HierarchyExists will be used to check whether the United Kingdom hierarchy exists in the Sales Region dimension. Where can the HierarchyExists function be…

HierarchySortOrder function for IBM Planning Analytics (TM1) HierarchySortOrder sets the order in which elements in a dimension are organized and displayed. In the video, HierarchySortOrder will be used to sort the dimension, Region, not Sorted. Where can the HierarchySortOrder function be used? TurboIntegrator Which TM1 Server version is the HierarchySortOrder function available for? Version 11 and…