Tm1 Function Elispar Excel

Summary

ELPAR returns the parent of an element in a dimension. Use in 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 ... ELCOMP returns the name of a child element from a consolidated element based on the position. Use in ELISCOMP determines whether an element is a component of a parent element in a dimension. Use in TM1ELLIST returns elements based on a list of elements, MDX or set. Use in ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form). ELLEV returns an element's level in the dimension. Use in ELISANC determines if an element is ancestor of another element or not. Works in Rule and TurboIntegrator Syntax ... TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active ... TM1RPTELLEV returns an element's level relative to the root in the subset. Use in DFRST returns the first element in a dimension. Use in