SubsetDeleteAllElements function for IBM Planning Analytics (TM1) SubsetDeleteAllElements deletes all elements from a public subset.  In this video, SubsetDeleteAllElements will be used to delete all elements from the subset, SubsetDeleteAllElements, from the Product Scorecard dimension. Where can the SubsetDeleteAllElements function be used? TurboIntegrator Which TM1 Server version is the SubsetDeleteAllElements function available for? Version 11 and 12 What…

SubsetDestroy function for IBM Planning Analytics (TM1) SubsetDestroy deletes a subset.  In this video, SubsetDestroy will be used to delete ‘All Elements’ subset in the Product Scorecard dimension.  Where can the SubsetDestroy function be used? TurboIntegrator Which TM1 Server version is the SubsetDestroy function available for? Version 11 and 12 What is the syntax for SubsetDestroy? SubsetDestroy(DimName,…

SubsetElementDelete function for IBM Planning Analytics (TM1) SubsetElementDelete deletes an element from a public subset.  In this video, SubsetElementDelete will be used to delete the ‘Sales Amount’ element from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetElementDelete function be used? TurboIntegrator Which TM1 Server version is the SubsetElementDelete function available for? Version…

SubsetElementExists function for IBM Planning Analytics (TM1) SubsetElementExists checks if an element exists in the specified public subset. If an element exists in the subset then it returns 1 otherwise it returns 0.  In this video, SubsetElementExists will be used to check if an element exists in the ‘All Elements’ subset from the Product Scorecard dimension. An existing and non-existing…

SetChoreVerboseMessages function for IBM Planning Analytics (TM1) SetChoreVerboseMessages turns on or off detailed messages to the tm1s.log file.  In this video, SetChoreVerboseMessages will be used to show the difference when it is toggled on and off. Where can the SetChoreVerboseMessages function be used? TurboIntegrator Which TM1 Server version is the SetChoreVerboseMessages function available for? Version…

SubsetExists function for IBM Planning Analytics (TM1) SubsetExists checks if a public subset exists. The function returns a 1 if the subset exists in the dimension, otherwise it returns 0. In this video, SubsetExists will be used to check if two subsets exist in the Product Scorecard dimension.  Where can the SubsetExists function be used? TurboIntegrator Which…

SetHierarchyElementGroupsSecurity function for IBM Planning Analytics (TM1) SetHierarchyElementGroupsSecurity sets the level of security to an element on a hierarchy to non-admin groups. In the video, SetHierarchyElementGroupsSecurity will be used to set READ access to the ‘No Department’ element from the ‘Department Name’ hierarchy. Where can the SetHierarchyElementGroupsSecurity function be used? TurboIntegrator Which TM1 Server version is the SetHierarchyElementGroupsSecurity…

SubsetExpandAboveSet function for IBM Planning Analytics (TM1) SubsetExpandAboveSet sets expand above a subset. It returns 1 if successful otherwise it returns 0.  In this video, SubsetExpandAboveSet will be used to set Expand Above to the subset, ExpandAbove, in the Quarter dimension. Where can the SubsetExpandAboveSet function be used? TurboIntegrator Which TM1 Server version is the SubsetExpandAboveSet function available…

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…