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 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 ... ELWEIGHT returns the element's weight to a consolidated element in a dimension. Use in ELEMENTPARENTCOUNT returns the number of parents of an element in the dimension. Works in Rule and TurboIntegrator ... ELLEV returns an element's level in the dimension. Use in ELEMENTPARENT returns the parent of an element in the dimension. Works in Rule and TurboIntegrator Syntax ... ELCOMPN returns number of components under an element. Use in TM1RPTTITLE is used to define the title dimensions for a Dynamic Report. TM1RPTTITLE is used in conjunction with ...