GetUseActiveSandboxProperty function for IBM Planning Analytics (TM1) GetUseActiveSandboxProperty determines if the process can read/write to the base or active sandbox for the user. In this video, GetUseActiveSandboxProperty will be used to get the user’s active sandbox name. Where can the GetUseActiveSandboxProperty function be used? TurboIntegrator Which TM1 Server version is the GetUseActiveSandboxProperty function available for?…

HierarchySubsetAttrN function for IBM Planning Analytics (TM1) HierarchySubsetAttrN retrieves a field from a numeric attribute from a subset tied to a dimension’s hierarchy. Where can the HierarchySubsetAttrN function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrN function available for? Version 11 and 12 What is the syntax for HierarchySubsetAttrN? HierarchySubsetAttrN(Dimension, Hierarchy, Subset, Attribute)…

HierarchySubsetAttrS function for IBM Planning Analytics (TM1) HierarchySubsetAttrS retrieves a field from a string attribute of a subset tied to a dimension’s hierarchy. In this video, HierarchySubsetAttrS will be used to retrieve data from the Office attribute associated with the Benelux subset in the Western Europe hierarchy from the Sales Region dimension. Where can the HierarchySubsetAttrS function be used? TurboIntegrator Which TM1 Server…

HierarchySubsetAttrPutN function for IBM Planning Analytics (TM1) HierarchySubsetAttrPutN writes a numeric value to a subset’s attribute or set of elements in a hierarchy for a dimension. Where can the HierarchySubsetAttrPutN function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrPutN function available for? Version 11 and 12 What is the syntax for HierarchySubsetAttrPutN? HierarchySubsetAttrPutS(String, DimName, HierName, SubName, AttrName,…

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