Tm1 Function Dbss Excel

Summary

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 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 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 ... SUBNM returns an element from a dimension set. If the optional alias parameter is included, the TM1RPTVIEW controls the definition of the report zero suppression and the format area. Used for Dynamic Reports (Active ... DBSA is used to send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the ... DB retrieve a value from a cube cell. Works in Rules Syntax DB(Cube, e1, e2 [,...en]) Cube = Cube Name to retrieve the data from ... TM1ELLIST returns elements based on a list of elements, MDX or set. Use in ELCOMP returns the name of a child element from a consolidated element based on the position. Use in