TM1 Function – DBSS
Available In
Excel
Definition
DBSS is used to send text to a cube’s cell.
Syntax
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 for the Cube.
Example
Add text to the System Info cube under the Comments measure.
Using this Excel spreadsheet to load the string fields in column B.
This is how each parameter will be defined.
TM1ServerName = AdventureWorks
CubeName = Product Scorecard
Element1 = Current Date (System Info Parameter)
Element2 = Comment (System Info Measures)
DBS(B4, “Adventureworks:System Info”, A4, “Comment”)
e.g. DBSS(“Today’s Date”, “Adventureworks:System Info”, “Current Date”, “Comment”)
Refresh to load the data to TM1
The data loaded into TM1.