-
HierarchyAttrSL function for IBM Planning Analytics (TM1)
HierarchyAttrSL function for IBM Planning Analytics (TM1) HierarchyAttrSL retrieves a string attribute from a dimension’s hierarchy given a language locale. Where can the HierarchyAttrSL function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrSL function available for? Version 11 and 12 What is the syntax for HierarchyAttrSL? HierarchyAttrSL(Dimension, Hierarchy, Attribute, [Locale]) Relevant Functions
-
HierarchyAttrPutN function for IBM Planning Analytics (TM1)
HierarchyAttrPutN function for IBM Planning Analytics (TM1) HierarchyAttrPutN uploads a value to a numeric attribute from a dimension’s hierarchy. Where can the HierarchyAttrPutN function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrPutN function available for? Version 11 and 12 What is the syntax for HierarchyAttrPutN? HierarchyAttrPutN(Value, Dimension, Hierarchy, Attribute, [Locale]) Relevant Functions
-
HierarchyAttrPutS function for IBM Planning Analytics (TM1)
HierarchyAttrPutS function for IBM Planning Analytics (TM1) HierarchyAttrPutS uploads text to a string attribute from a dimension’s hierarchy. Where can the HierarchyAttrPutS function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrPutS function available for? Version 11 and 12 What is the syntax for HierarchyAttrPutS? HierarchyAttrPutS(Text, Dimension, Hierarchy, Attribute, [Locale]) Relevant Functions
-
PublishSubset function for IBM Planning Analytics (TM1)
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 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 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…
-
DBR function for IBM Planning Analytics (TM1)
DBR function for IBM Planning Analytics (TM1) The DBR serves as a fundamental tool for interacting with multidimensional data cubes on IBM Planning Analytics (TM1), enabling precise retrieval and modification of data within the context of financial planning, analysis and reporting. This function is used directly in Excel, enabling users to create dynamic and interactive…
-
Explore February’s Insights with Cubewise EDU
Check out what’s happening in the world of IBM Planning Analytics, and harness our focus and enthusiasm to your benefit in one or more ways!
-
Planning Analytics Workspace latest and greatest features
Unlock the power of IBM Planning Analytics Workspace with the latest features and enhancements for seamless data analysis and management
-
MDX Fundamentals
Who is it for End Users and Developers Duration 8 hours Difficulty Intermediate Prerequisite End User (PAW) Product IBM Planning Analytics Workspace Next Course Universal Report (for students learning IBM Planning Analytics for Excel) MDX Fundamentals When retrieving a list of members in a dimension or analysing cube data, IBM Planning Analytics utilises the MDX…