Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    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 function available for?

        Version 11 and 12

          What is the syntax for ElIsPar?

          ElIsPar(TM1ServerName:Dimension, ParentElement, ChildElement)

          • ​TM1ServerName = Name of the TM1 Server
          • Dimension = Name of the Dimension
          • ParentElement = Parent element of the child element to be queried
          • ChildElement = Element to be queried of its weighting

          Relevant Functions

          • ElComp = Returns the name of a child element from a consolidated element based on the position
          • ElCompN = Returns the number of components under an element
          • ElIsComp = Determine whether an element is a component of a parent element in a dimension
          • ElIsPar = Determine whether an element is a parent of a child in a dimension
          • ElLev = Returns the level of an element within a dimension
          • ElPar = Determine whether an element is a parent of a child in a dimension
          • ElParN = Returns the number of parents for an element
          • ElSLen = Returns the number of characters in the element in a dimension
          • ElWeight = returns the element’s weight to a consolidated element in a dimension