Tm1 Function Elcomp Excel - Detailed Analysis
DBRA is used to retrieve and write back a value or text to a dimension's attribute. 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 ... TM1RPTVIEW controls the definition of the report like zero suppression and the format area. Used for Dynamic Reports (Active ... DBSS is used to send text to a cube's cell. Use in ELCOMPN returns number of components under an element. Use in TM1ELLIST returns elements based on a list of elements, MDX or set. 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 ... ELSLEN returns the number of characters in the element in a dimension. Member ID and alias can be used. Use in ELLEV returns an element's level in the dimension. Use in ELPARN returns the number of parent elements for an element. Use in DBS is used to send a value to a cube's cell. This DBSW sends a numeric value to a cube's cell. DBSW is more efficient over a WAN than DBS. This
ELPAR returns the parent of an element 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 TM1RPTFILTER is used to apply a filter to the Dynamic Report to sort the row based on a column. Used for Dynamic Reports ...
Photo Gallery
