Tm1 Function Tm1primarydbname 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 TM1ELLIST returns elements based on a list of elements, MDX or set. Use in SUBNM returns an element from a dimension set. If the optional alias parameter is included, the DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). TM1RPTFILTER is used to apply a filter to the Dynamic Report to sort the row based on a column. Used for Dynamic Reports ... TM1USER returns the user logged in. Use in DIMNM returns an element's member ID based on an index in a dimension. Use in ELPAR returns the parent of an element in a dimension. Use in TM1RPTELLEV returns an element's level relative to the root in the subset. Use in TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell which works with