DBRW function for IBM Planning Analytics (TM1)

    Where can the DBRW function be used?

      Which TM1 Server version is the DBRW function available for?

        What is the syntax for DBRW?

        • TM1ServerName = Name of the TM1 Server
        • CubeName = Name of the Cube
        • Element1 to ElementN = An element in each dimension from the Cube. Each element must be ordered based on the dimension of the Cube.

        Relevant Functions

        • DBR = Retrieve and write back a value or text to a cube’s cell
        • DBRW = Retrieve and write back a value or text to a cube’s cell, which is more efficient than the DBR over a WAN than DBRW
        • DBS = Send a value to a cube’s cell. This function cannot send a string to a cube
        • DBSS = Send a text to a cube’s cell
        • DBSW = Send a numeric value to a cube’s cell. DBSW is more efficient over a WAN than DBS
        • View = Sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker