Tm1 Function Eliscomp Excel

Summary

ELCOMP returns the name of a child element from a consolidated element based on the position. Use in TM1ELLIST returns elements based on a list of elements, MDX or set. Use in ELPAR returns the parent of an element in a dimension. 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 ... TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... ELCOMPN returns number of components under an element. Use in ELLEV returns an element's level in the dimension. Use in DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in