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…

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…

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…

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…