-
ElIsPar Excel function for IBM Planning Analytics (TM1)
ElIsPar Excel function for IBM Planning Analytics (TM1) ElWeight determines whether an element is a parent of a child in a dimension. In the video, ElWeight will be used to determine if Bikes is Mountain Bikes’s parent. Where can the ElIsPar function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElIsPar…
-
SubNm function for IBM Planning Analytics (TM1)
SubNm function for IBM Planning Analytics (TM1) SubNm returns an element from a dimension set. If the optional alias parameter is included, the function returns the alias for the element. The formula transforms the cell into a drop-down and can open to the set editor by double-clicking on the cell. In the video, SubNm will…
-
ElementName function for IBM Planning Analytics (TM1)
ElementName function for IBM Planning Analytics (TM1) ElementName returns the element of a dimension based on the index argument. In the video, ElementName will be used to retrieve the name of an element of the Employee Hierarchies dimension and apply it in the rule to populate in the Employee Salaries cube. Where can the ElementName…
-
TabDim function for IBM Planning Analytics (TM1)
TabDim function for IBM Planning Analytics (TM1) TabDim returns the dimension name in a cube based on an index. In this video, TabDim will be used to obtain the dimensions from the Product Scorecard cube. Where can the TabDim function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the TabDim function available…
-
LevelCount function for IBM Planning Analytics (TM1)
LevelCount function for IBM Planning Analytics (TM1) LevelCount returns the number of levels within a dimension. Where can the LevelCount function be used? Rules and TurboIntegrator Which TM1 Server version is the LevelCount function available for? Version 11 and 12 What is the syntax for LevelCount? LevelCount(dimension, hierarchy) Relevant Functions
-
TM1User function for IBM Planning Analytics (TM1)
TM1User function for IBM Planning Analytics (TM1) TM1User returns the user logged in. In this video, TM1User will be used to see who is logged in for the TM1 server, AdventureWorks. Where can the TM1User function be used? Excel and TurboIntegrator Which TM1 Server version is the TM1User function available for? Version 11 and 12…
-
ElSLen Excel function for IBM Planning Analytics (TM1)
ElSLen Excel function for IBM Planning Analytics (TM1) ElSLen returns the number of characters in the element in a dimension. Member ID and alias can be used. In the video, ElSLen will be used to return the character length for elements from the Product Type dimension. Where can the ElSLen function be used? Excel, Rules…
-
View function for IBM Planning Analytics (TM1)
View function for IBM Planning Analytics (TM1) The View function sets up an optimised view for a cube cached in memory so it can be referenced quicker when referred within the DBRW or DBR formula. In the View function, the title dimension is referenced to an element, while the row and column axis dimensions are…
-
ElWeight Excel function for IBM Planning Analytics (TM1)
ElWeight Excel function for IBM Planning Analytics (TM1) ElWeight returns the element’s weight to a consolidated element in a dimension. In the video, ElWeight will be used to delete the file ‘Price and Cost.csv’ in Excel. Where can the ElWeight function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElWeight function available…
-
TM1RptView function for IBM Planning Analytics (TM1)
TM1RptView function for IBM Planning Analytics (TM1) TM1RptView controls the definition of the report like zero suppression and the format area. Used for Dynamic Reports (Active Form). In the video, the TM1RptView will be used in a Dynamic Report to suppress and un-suppress zeros on the row set. Where can the TM1RptView function be used?…