Tm1 Function View Excel

Summary

SUBNM returns an element from a dimension set. If the optional alias parameter is included, the TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... 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 ... DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This 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 TM1ELLIST returns elements based on a list of elements, MDX or set. Use in TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). DIMNM returns an element's member ID based on an index in a dimension. Use in