DBSS function for IBM Planning Analytics (TM1)
DBSS is used to send text to a cube’s cell.
In the video, the DBSS will add text to the System Info cube under the Comments measure.
Where can the DBSS function be used?
Excel
Which TM1 Server version is the DBSS function available for?
Version 11 and 12
What is the syntax for DBSS?
DBSS(Value, TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN)
- Value = The string 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