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…

ForceSkipCheck function for IBM Planning Analytics (TM1) ForceSkipCheck forces the view query to process only values in the cube, instead of going through every possible cell. Use in the Prolog tab. In this video, ForceSkipCheck is used to perform as if the cube view is using a SkipCheck. Where can the ForceSkipCheck function be used? TurboIntegrator Which TM1…

DimensionUpdateDirect function for IBM Planning Analytics (TM1)  DimensionUpdateDirect rewrites a dimension that has been edited with Dimension*Direct function(s) (e.g. DimensionElementInsertDirect) to reduce the memory utilised to edit the dimension.​ In the video, the DimensionUpdateDirect will be used to update the Department dimension. Where can the DimensionUpdateDirect function be used? TurboIntegrator Which TM1 Server version is the DimensionUpdateDirect function available…

DisableBulkLoadMode function for IBM Planning Analytics (TM1)  DisableBulkLoadMode disables bulk load processing on the TM1 Server. To enable bulk load processing, use EnableBulkLoadMode.  In the video, DisableBulkLoadMode will be used to disable bulk load processing. Where can the DisableBulkLoadMode function be used? TurboIntegrator Which TM1 Server version is the DisableBulkLoadMode function available for? Version 11 What…

DisableMTQViewConstruct function for IBM Planning Analytics (TM1)  DisableMTQViewConstruct disables multi-threaded query processing in a process that uses a cube view as the data source. This function will override the value MTQQuery=F set in the tms1.cfg file.  In the video, DisableMTQViewConstruct will be used to disable multi-threaded query processing to show its impact on BatchUpdateFinish. Where can the DisableMTQViewConstruct function…

ElementAttrNL function for IBM Planning Analytics (TM1) ElementAttrNL retrieves a numeric attribute for an element. In the video, ElementAttrNL will be used to retrieve the SupplierCode attribute for Cleaners in the Product Type dimension. Where can the ElementAttrNL function be used? TurboIntegrator Which TM1 Server version is the ElementAttrNL function available for? Version 11 and 12 What is the syntax for…

ElementAttrPutS function for IBM Planning Analytics (TM1) ElementAttrPutS uploads data from a string attribute for an element. In the video, ElementAttrPutS will be used to upload inactive to the active status attribute against Cleaners in the Product Type dimension. Where can the ElementAttrPutS function be used? TurboIntegrator Which TM1 Server version is the ElementAttrPutS function available for? Version 11 and 12 What is the…

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?…

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)…