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…

PublishSubset function for IBM Planning Analytics (TM1) PublishSubset converts a private subset to public. This function can be used from Planning Analytics 2.0.9.10/TM1 Server 11.8.9 or newer. In this video, PublishSubset will be used to create a private subset and use PublishSubset to make it public Where can the PublishSubset function be used? TurboIntegrator Which…

SubsetAliasGet function for IBM Planning Analytics (TM1) SubsetAliasGet retrieves the alias used for a subset. This function can be used from Planning Analytics 2.0.9.10/TM1 Server 11.8.9 or newer. In this video, SubsetAliasGet will be used to retrieve the MDX expression for the Department subset that’s associated with the Employee hierarchy and Employee dimension. Where can the SubsetAliasGet function be used? TurboIntegrator…

HierarchySubsetAliasGet function for IBM Planning Analytics (TM1) HierarchySubsetAliasGet retrieves the alias used for a subset in a hierarchy. This function can be used from Planning Analytics 2.0.9.10/TM1 Server 11.8.9 or newer. In this video, HierarchySubsetAliasGet will be used to return the alias used for a subset in a text file. Where can the HierarchySubsetAliasGet function…

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,…