DBS
DBS sends a numeric value to a TM1® cube.
This function cannot send a string to a cube. To send strings, use the DBSS function.
In IBM® Planning Analytics for Microsoft Excel, the DBS function is equivalent to the DBSW function. Both functions are optimized to reduce network traffic and improve performance on wide area networks.
Syntax
DBS(value, server:cube, m1, m2[,...mn])|
Argument |
Description |
Required/Optional |
|---|---|---|
|
value |
The value being sent. |
Required |
|
server:cube |
The name of the TM1 server and the cube to which the value is sent. |
Required |
|
m1, ...mn |
The names of members defining the intersection in the cube to which the value is sent. Arguments m1 through mn are sequence-sensitive. m1 must be a member from the first dimension of the cube, m2 must be a member from the second dimension of the cube, and so on. These arguments can also be the names of aliases for dimension members. Numeric member names must be enclosed in double quotation marks. |
Required |
Example
In this example, the TM1 server name is GO_New_Stores and the cube name is Base Sales Forecast. The function writes the value 5342 to the intersection of Americas, Department Store, Freight, Corporate Store, Budget version 1, and Feb.DBS(5342,"GO_New_Stores:Base Sales Forecast","Americas",
"Department Store","Freight","Corporate Store","Budget version 1","Feb")