SubsetAttrInsert function for IBM Planning Analytics (TM1) SubsetAttrInsert creates a string, numeric or alias subset attribute for a dimension. In this video, SubsetAttrInsert will be used to create a string, numeric and an alias subset attribute in the Product Scorecard dimension.  Where can the SubsetAttrInsert function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrInsert function available for? Version 11 and 12…

SubsetAttrNL function for IBM Planning Analytics (TM1) SubsetAttrNL retrieves a value from a subset’s numeric attribute based on the local language code. If the attribute is not defined for the language code, then the function returns the base attribute value. In this video, SubsetAttrNL will be used to retrieve the numeric attribute, No of Elements, from the…

SubsetAttrPutS function for IBM Planning Analytics (TM1) SubsetAttrPutS updates a string attribute from a subset. In this video, SubsetAttrPutS will be used to update the string attribute, Description, from the ‘All Elements’ subset in the Product Scorecard dimension.​  Where can the SubsetAttrPutS function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrPutS function available for? Version 11…

SubsetAttrS function for IBM Planning Analytics (TM1) SubsetAttrS retrieves a string attribute from a subset. In this video, SubsetAttrS will be used to retrieve the string attribute, Description, from the ‘All Elements’ subset in the Product Scorecard dimension.  Where can the SubsetAttrS function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrS function available for? Version 11…

ViewAttrPutS function for IBM Planning Analytics (TM1) ViewAttrPutS inserts a string to an attribute for a cube view. In this video, ViewAttrPutS will be used to insert a string to the attribute, Description, from the Employee cube. Where can the ViewAttrPutS function be used? TurboIntegrator Which TM1 Server version is the ViewAttrPutS function available for? Version 11 and…

ViewCreateByMDX function for IBM Planning Analytics (TM1)  ViewCreateByMDX creates a cube view with an MDX expression. In the video, ViewCreateByMDX will be used to create a view for the Finance cube using an MDX expression. Where can the ViewCreateByMDX function be used? TurboIntegrator Which TM1 Server version is the ViewCreateByMDX function available for? Version 11 and 12…

Synchronized function for IBM Planning Analytics (TM1) Synchronized forces processes to run in sequence.  In this video, Synchronized is used to show how processes behave when synchronized is used and isn’t used.   Where can the Synchronized function be used? TurboIntegrator Which TM1 Server version is the Synchronized function available for? Version 11 and 12 What is…

TM1ProcessError.LOG function for IBM Planning Analytics (TM1) TM1ProcessError.LOG generates a log file when a process encounters an error. In this video, a process will be executed which will cause an error that creates a TM1ProcessError log file. Where can the TM1ProcessError.LOG function be used? TurboIntegrator Which TM1 Server version is the TM1ProcessError.LOG function available for?…

Value_Is_String function for IBM Planning Analytics (TM1) Value_Is_String is a reserved local variable that checks if the data source type is a string or number. If the function return ‘1’, then the value is a string,  otherwise it is numeric. For reserved variables, we don’t need to define it in the script. In this video, Value_Is_String will be used to…

ViewAttrDelete function for IBM Planning Analytics (TM1) ViewAttrDelete deletes a view attribute from a cube. In this video, ViewAttrDelete will be used to delete the view attribute, Developers Commentary, from the Employee cube. Where can the ViewAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ViewAttrDelete function available for? Version 11 and 12 What is the…