Tm1 Function Eliscomp Excel - Detailed Analysis
ELCOMP returns the name of a child element from a consolidated element based on the position. Use in ELCOMPN returns number of components under an element. Use in TM1ELLIST returns elements based on a list of elements, MDX or set. Use in ELLEV returns an element's level in the dimension. Use in ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with
ELISPAR determines whether an element is a parent of a child in a dimension. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). ELPAR returns the parent of an element in a dimension. Use in TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in TM1RPTELLEV returns an element's level relative to the root in the subset. Use in
ELPARN returns the number of parent elements for an element. 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 ... 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 ... DIMIX returns an element's index number in a dimension. Use in DNEXT returns the next element based on the index in a dimension. Use in
Photo Gallery
