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…

EvalJavaS function for IBM Planning Analytics (TM1) EvalJavaS is a rules function that executes a Java TI process that returns a string. Where can the EvalJavaS function be used? Rules Which TM1 Server version is the EvalJavaS function available for? Version 11 What is the syntax for EvalJavaS? EvalJavaS(‘Class’, [‘OptionalParameter1’, ‘OptionalParameter2’, …]) Relevant Functions

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…

ViewExtractSkipCalcsSet function for IBM Planning Analytics (TM1) ViewExtractSkipCalcsSet skips or includes consolidated values when exporting a view using ASCIIOutput. Use in the Prolog tab. In the video, learn how to use ViewExtractSkipCalcsSet to export a view from the Product Scorecard cube and exclude consolidated elements. Where can the ViewExtractSkipCalcsSet function be used? TurboIntegrator Which TM1 Server version is the ViewExtractSkipCalcsSet function…

DimensionAttrDelete function for IBM Planning Analytics (TM1) DimensionAttrDelete deletes a dimension’s attribute. Where can the DimensioDimensionAttrDeletenAttrN function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrDelete function available for? Version 11 and 12 What is the syntax for DimensionAttrDelete? DimensionAttrDelete(AttributeName) Relevant Functions

EvalJavaN function for IBM Planning Analytics (TM1) EvalJavaN is a rules function that executes a Java TI process that returns a number. Where can the EvalJavaS function be used? Rules Which TM1 Server version is the EvalJavaN function available for? Version 11 What is the syntax for EvalJavaN? EvalJavaN(‘Class’, [‘OptionalParameter1’, ‘OptionalParameter2’, …]) Relevant Functions

DimensionAttrInsert function for IBM Planning Analytics (TM1) DimensionAttrInsert inserts a string, numeric or alias attribute for dimensions. Where can the DimensionAttrInsert function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrInsert function available for? Version 11 and 12 What is the syntax for DimensionAttrInsert? DimensionAttrInsert(PreviousAttribute, NewAttribute, AttributeType) Relevant Functions

ServerShutdown function for IBM Planning Analytics (TM1)  ServerShutdown shuts down the TM1 Server. It can only be used if the TM1 Server runs as an application, not a Windows service. Where can the ServerShutdown function be used? TurboIntegrator Which TM1 Server version is the ServerShutdown function available for? Version 11 What is the syntax for…