Tm1 Function Elweight Excel

Summary

ELCOMP returns the name of a child element from a consolidated element based on the position. Use in SUBNM returns an element from a dimension set. If the optional alias parameter is included, the TM1ELLIST returns elements based on a list of elements, MDX or set. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). 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 ... DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This ELPAR returns the parent of an element in a dimension. Use in ELCOMPN returns number of components under an element. Use in ELPARN returns the number of parent elements for an element. Use in TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ... 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