HierarchyUpdateDirect function for IBM Planning Analytics (TM1) HierarchyUpdateDirect recompiles a hierarchy edited by *Direct functions (e.g. HierarchyElementInsertDirect) to reduce the memory footprint. Where can the HierarchyUpdateDirect function be used? TurboIntegrator Which TM1 Server version is the HierarchyUpdateDirect function available for? Version 11 and 12 What is the syntax for HierarchyUpdateDirect? HierarchyUpdateDirect(Dimension, Hierarchy) Relevant Functions

ODBCOpenEx function for IBM Planning Analytics (TM1) ODBCOpenEx closes an ODBC connection. Where can the ODBCOpenEx function be used? TurboIntegrator Which TM1 Server version is the ODBCOpenEx function available for? Version 11 and 12 What is the syntax for ODBCOpenEx? ODBCOpenEx(Source, Client, Password, UseUnicodeODBC) Relevant Functions

DimensionAttrNL function for IBM Planning Analytics (TM1) DimensionAttrNL returns a numeric attribute for a specified dimension given a language locale. Where can the DimensionAttrNL function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrNL function available for? Version 11 and 12 What is the syntax for DimensionAttrNL? DimensionAttrNL(DimName, AttrName, [Locale]) Relevant Functions

RefreshMDXHierarchy function for IBM Planning Analytics (TM1) RefreshMDXHierarchy refreshes all the MDX hierarchies on the TM1 Server. In this video, RefreshMDXHierarchy will be used to see who is logged in for the TM1 server, AdventureWorks. Where can the RefreshMDXHierarchy function be used? TurboIntegrator Which TM1 Server version is the RefreshMDXHierarchy function available for? Version 11…

DimensionAttrSL function for IBM Planning Analytics (TM1) DimensionAttrSL returns a string attribute for a specified dimension given a language locale. In this video, DimensionAttrSL will be used to upload a number to the index attribute from the Employee dimension. Where can the DimensionAttrSL function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrSL function available for? Version 11 and 12…

SetODBCUnicodeInterface function for IBM Planning Analytics (TM1) SetODBCUnicodeInterface determines if Unicode wide functions are used on the ODBC interface or regular single-byte character functions. Where can the SetODBCUnicodeInterface function be used? TurboIntegrator Which TM1 Server version is the SetODBCUnicodeInterface function available for? Version 11 What is the syntax for SetODBCUnicodeInterface? SetODBCUnicodeInterface = boolean; Relevant Functions

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

AddInfoCubeRestriction function for IBM Planning Analytics (TM1) AddInfoCubeRestriction restricts values that are imported from an InfoCube data set. Use this function in the Prolog. AddInfoCubeRestriction can be called multiple times to filter more than one characteristic in a process. Where can the AddInfoCubeRestriction function be used? TurboIntegrator Which TM1 Server version is the AddInfoCubeRestriction function…

HierarchySubsetAttrNL function for IBM Planning Analytics (TM1) HierarchySubsetAttrNL retrieves data from a numeric attribute associated with a subset in a hierarchy based on a language locale. Where can the HierarchySubsetAttrNL function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrNL function available for? Version 11 and 12 What is the syntax for HierarchySubsetAttrNL? HierarchySubsetAttrNL(DimName,…

HierarchyAttrS function for IBM Planning Analytics (TM1) HierarchyAttrS retrieves a string attribute from a dimension’s hierarchy. Where can the HierarchyAttrS function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrS function available for? Version 11 and 12 What is the syntax for HierarchyAttrS? HierarchyAttrS(Dimension, Hierarchy, Attribute) Relevant Functions