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…

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…