DBSW sends a numeric value to a cube's cell.
Excel
DBSW sends a numeric value to a cube’s cell. DBSW is more efficient over a WAN than DBS. 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 that does not have access to TM1.
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 for the Cube.
Send values into Budget from Excel into TM1 for the period Q2.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book