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…

ViewAttrS function for IBM Planning Analytics (TM1) ViewAttrS returns a string from a cube view’s attribute. In this video, ViewAttrS will be used to retrieve the Description’s attribute from the Employee cube’s default view. Where can the ViewAttrS function be used? TurboIntegrator Which TM1 Server version is the ViewAttrS function available for? Version 11 and 12 What is the syntax for…

ViewAttrSL function for IBM Planning Analytics (TM1) ViewAttrSL returns a string from a cube view’s attribute for a given locale. In this video, ViewAttrSL will be used to retrieve the Description attribute from the Employee cube’s default view from the locale, pt-BR. Where can the ViewAttrSL function be used? TurboIntegrator Which TM1 Server version is the ViewAttrSL function available for? Version 11…

SubsetIsAllSet function for IBM Planning Analytics (TM1) SubsetIsAllSet sets all elements to a public subset In this video, SubsetIsAllSet will be used to set all elements to the subset, ‘All Elements’, from the Product Scorecard dimension. Where can the SubsetIsAllSet function be used? TurboIntegrator Which TM1 Server version is the SubsetIsAllSet function available for? Version 11 and…

ViewColumnSuppressZeroesSet function for IBM Planning Analytics (TM1)  ViewColumnSuppressZeroesSet hides or displays columns containing zero values in a cube view. In the video, ViewColumnSuppressZeroesSet will be used to show columns containing zero values in the Default view from the Sales Quota cube. Where can the ViewColumnSuppressZeroesSet function be used? TurboIntegrator Which TM1 Server version is the ViewColumnSuppressZeroesSet function available for?…

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