Tm1 Function Dnlev 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 ... TM1ELLIST returns elements based on a list of elements, MDX or set. Use in TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with 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 TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... ELPAR returns the parent of an element in a dimension. Use in Returns the number of members in a dimension set. Available for ELCOMP returns the name of a child element from a consolidated element based on the position. Use in TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... SUBNM returns an element from a dimension set. If the optional alias parameter is included, the DTYPE returns the element type in a dimension. N = numeric element C = consolidated element S = string element Use in TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ...