DBSW function for IBM Planning Analytics (TM1)

DBSW sends a numeric value to a cube’s cell and is more efficient than DBS over WAN. This function cannot send a string to a cube. To send strings, use the DBSS function. This function would typically be used when the data comes from a person who does not have access to TM1.

In the video, the DBSW will send values into Budget from Excel into TM1 for Q2.

Where can the DBSW function be used?

Excel

Which TM1 Server version is the DBSW function available for?

Version 11 and 12

What is the syntax for DBSW?

DBSW(Value, TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN)

Value = The numeric value to be sent
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