Tm1 Function Eliscomp Excel

Summary

ELCOMP returns the name of a child element from a consolidated element based on the position. Use in VIEW sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker. When Slicing a view in ... TM1ELLIST returns elements based on a list of elements, MDX or set. Use in ELCOMPN returns number of components under an element. Use in ELLEV returns an element's level in the dimension. Use in ELISPAR determines whether an element is a parent of a child in a dimension. Use in ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in ELPAR returns the parent of an element in a dimension. Use in DBSA is used to send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the ... TM1RPTELLEV returns an element's level relative to the root in the subset. Use in DFRST returns the first element in a dimension. Use in DIMNM returns an element's member ID based on an index in a dimension. Use in