Tm1 Function Elpar 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 ... ELCOMP returns the name of a child element from a consolidated element based on the position. Use in ELISPAR determines whether an element is a parent of a child in a dimension. Use in ELPARN returns the number of parent elements for an element. Use in ELWEIGHT returns the element's weight to a consolidated element in a dimension. 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 ... ELLEV returns an element's level in the dimension. Use in ELEMENTPARENTCOUNT returns the number of parents of an element in the dimension. Works in Rule and TurboIntegrator ... TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ... ELCOMPN returns number of components under an element. Use in DIMNM returns an element's member ID based on an index in a dimension. Use in TM1RPTROW returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in