DBSS

DBSS sends a string to a cube of any number of dimensions. This function cannot send a numeric value to a cube. Use the DBS function to send numeric values.

When you build a DBSS function with the TM1 > Edit Formula option, the Edit Formula dialog box prompts you through a series of steps to build each function argument in the correct sequence.

If the cube does not exist or one of the arguments is invalid, the function returns KEY ERROR.

This worksheet function is valid in worksheets only.

Syntax

DBSn(string, cube, e1, e2,...en)

Argument	Description
string	The string being sent.
cube	The cube to which the string is sent.
e1, ...en	The names of elements defining the intersection in the cube to which the string is sent. Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension of the cube, and so on. These arguments can also be the names of aliases for dimension elements.

Argument

Description

string

The string being sent.

cube

The cube to which the string is sent.

e1, ...en

The names of elements defining the intersection in the cube to which the string is sent.

Arguments e1 through en are sequence-sensitive. e1 must be an element from the first dimension of the cube, e2 must be an element from the second dimension of the cube, and so on. These arguments can also be the names of aliases for dimension elements.

Example

DBSS("Smith","Info","California","Last Name")

In this example, the formula sends the string Smith to the cube Info at the intersection of California and Last Name.