Tm1 Function Elslen Excel - Detailed Analysis
DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in TM1ELLIST returns elements based on a list of elements, MDX or set. Use in SUBNM returns an element from a dimension set. If the optional alias parameter is included, the ELCOMP returns the name of a child element from a consolidated element based on the position. Use in DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This ELLEV returns an element's level in the dimension. Use in
DTYPE returns the element type in a dimension. N = numeric element C = consolidated element S = string element Use in ELPAR returns the parent of an element in a dimension. Use in ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in DBSS is used to send text to a cube's cell. Use in DBS is used to send a value to a cube's cell. This DBR retrieves and writes back a value or text to a cube's cell. DBR is less efficient over a WAN than DBRW. DBR will be ...
ELPARN returns the number of parent elements for an element. Use in ELCOMPN returns number of components under an element. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). TM1RPTVIEW controls the definition of the report like zero suppression and the format area. Used for Dynamic Reports (Active ... TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with
Photo Gallery
