LevelCount function for IBM Planning Analytics (TM1) LevelCount returns the number of levels within a dimension. Where can the LevelCount function be used? Rules and TurboIntegrator Which TM1 Server version is the LevelCount function available for? Version 11 and 12 What is the syntax for LevelCount? LevelCount(dimension, hierarchy) Relevant Functions

TM1User function for IBM Planning Analytics (TM1) TM1User returns the user logged in. In this video, TM1User will be used to see who is logged in for the TM1 server, AdventureWorks. Where can the TM1User function be used? Excel and TurboIntegrator Which TM1 Server version is the TM1User function available for? Version 11 and 12…

ElSLen Excel function for IBM Planning Analytics (TM1) ElSLen returns the number of characters in the element in a dimension. Member ID and alias can be used. In the video, ElSLen will be used to return the character length for elements from the Product Type dimension. Where can the ElSLen function be used? Excel, Rules…

ElWeight Excel function for IBM Planning Analytics (TM1) ElWeight returns the element’s weight to a consolidated element in a dimension. In the video, ElWeight will be used to delete the file ‘Price and Cost.csv’ in Excel. Where can the ElWeight function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElWeight function available…

NumericGlobalVariable function for IBM Planning Analytics (TM1) NumericGlobalVariable declares a numeric global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. Where can the NumericGlobalVariable function be used? TurboIntegrator Which TM1 Server version is the NumericGlobalVariable function available for? Version 11 and 12 What is the…

StringGlobalVariable function for IBM Planning Analytics (TM1) StringGlobalVariable declares a string global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. In this video, StringGlobalVariable will be used to declare a string global variable, sGlobalVariable, and show that the variable can be accessed from processes that are called…

DimensionAttrS function for IBM Planning Analytics (TM1) DimensionAttrS returns a string attribute for a specified dimension. In this video, DimensionAttrS will be used to retrieve string attribute value of the dimension and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the DimensionAttrS function be used? Rules and…

SubSiz function for IBM Planning Analytics (TM1) SubSiz returns the number of members in a dimension set. In this video, SubSiz will be used to return the set ‘Leaves’ from the ‘Department’ dimension. Where can the SubSiz function be used? Excel Which TM1 Server version is the SubSiz function available for? Version 11 and 12…

DatasourceSAPUsingRoleAuths function for IBM Planning Analytics (TM1) DatasourceSAPUsingRoleAuths controls whether security information is processed for an SAP data source. Use in the Prolog. Where can the DatasourceSAPUsingRoleAuths function be used? TurboIntegrator Which TM1 Server version is the DatasourceSAPUsingRoleAuths function available for? Version 11 and 12 What is the syntax for DatasourceSAPUsingRoleAuths? DatasourceSAPUsingRoleAuths = boolean Relevant…

DatasourceSAPUsingTexts function for IBM Planning Analytics (TM1) DatasourceSAPUsingTexts controls whether to ignore characteristic descriptions from an SAP data source. Use in the Prolog. Where can the DatasourceSAPUsingTexts function be used? TurboIntegrator Which TM1 Server version is the DatasourceSAPUsingTexts function available for? Version 11 and 12 What is the syntax for DatasourceSAPUsingTexts? DatasourceSAPUsingTexts = boolean Relevant…