Tm1 Function Elweight Excel - Detailed Analysis
DBRA is used to retrieve and write back a value or text to a dimension's attribute. 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 ELPAR returns the parent of an element in a dimension. Use in ELCOMPN returns number of components under an element. Use in DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This
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 ELPARN returns the number of parent elements for an element. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in TM1RPTELLEV returns an element's level relative to the root in the subset. Use in
TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with 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 ... DIMNM returns an element's member ID based on an index in a dimension. Use in ELISCOMP determines whether an element is a component of a parent element in a dimension. Use in
Photo Gallery
