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 ... DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in ELCOMPN returns number of components under an element. Use in SUBNM returns an element from a dimension set. If the optional alias parameter is included, the TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. 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 ... ELPAR returns the parent of an element in a dimension. Use in TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ... TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... ELPARN returns the number of parent elements for an element. Use in DIMNM returns an element's member ID based on an index in a dimension. Use in