Tm1 Function Tm1rptfilter Excel

Summary

TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). 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 ... TM1RPTELLEV returns an element's level relative to the root in the subset. Use in TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... DBRA is used to retrieve and write back a value or text to a dimension's attribute. Use in 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 ... TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ... TM1RPTROW returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in ELCOMP returns the name of a child element from a consolidated element based on the position. Use in TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... TM1USER returns the user logged in. Use in DFRST returns the first element in a dimension. Use in TM1PRIMARYDBNAME returns the primary