Tm1 Function Elcomp Excel

Summary

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 ... ELCOMPN returns number of components under an element. Use in ELISCOMP determines whether an element is a component of a parent element in a dimension. Use in SUBNM returns an element from a dimension set. If the optional alias parameter is included, the ELPAR returns the parent of an element in a dimension. Use in ELLEV returns an element's level in the dimension. Use in ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). ELCOMPN returns the number of elements of the consolidation. Works in Rule and TurboIntegrator Syntax ELCOMPN(dimension, ... TM1ELLIST returns elements based on a list of elements, MDX or set. Use in DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This