DimensionElementDeleteDirect function for IBM Planning Analytics (TM1)  DimensionElementDeleteDirect deletes an element directly 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  DimensionElementDelete. In the video, the DimensionElementDeleteDirect will be used to delete the element Wales from the dimension, Sales Region. Where can the…

EnableBulkLoadMode function for IBM Planning Analytics (TM1)  EnableBulkLoadMode enables bulk load processing to improve process efficiency. Call EnableBulkLoadMode in the Prolog or Epilog. This function is enabled in one process and remains enabled until disabled with DisableBulkLoadMode or until a chore is completed. In the video, EnableBulkLoadMode will be used to enable bulk load and show how it affects locking on the TM1…

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

EnableMTQViewConstruct function for IBM Planning Analytics (TM1) EnableMTQViewConstruct enables multi-threaded query processing using a cube view as the data source. In the video, EnableMTQViewConstruct will be used to enable multi-threaded queries and show its impact. Where can the EnableMTQViewConstruct function be used? TurboIntegrator Which TM1 Server version is the EnableMTQViewConstruct function available for? Version 11…

ElementAttPutN function for IBM Planning Analytics (TM1) ElementAttPutN uploads data to a numeric attribute for an element. In the video, ElementAttPutN will be used to upload 5000 to the SupplierCode attribute for Mountain Bikes in the Product Type dimension. Where can the ElementAttPutN function be used? TurboIntegrator Which TM1 Server version is the ElementAttPutN function available for? Version 11 and 12 What is the…

ElementAttrSL function for IBM Planning Analytics (TM1) ElementAttrSL returns a string attribute for an element. In the video, ElementAttrSL will be used to retrieve data from the attribute, Active Status, for Bike Rakes in the Product Type dimension. Where can the ElementAttrSL function be used? TurboIntegrator Which TM1 Server version is the ElementAttrSL function available for? Version 11 and…

Expand function for IBM Planning Analytics (TM1) Expand expands variable names, enclosed in % signs. In this video, Expand is used to retrieve a variable using an index number. Where can the Expand function be used? TurboIntegrator Which TM1 Server version is the Expand function available for? Version 11 and 12 What is the syntax for Expand?…

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…

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