DBSS TM1 Excel Syntax and Use
The DBSS function sends a string value to any TM1 cube’s cell.
The syntax for DBSS is:
DBSS (string, cube, e1, e2,…en)
- string: The string value that is being sent to the cube.
- cube: The specific cube to which the string value is being sent.
- e1, …en: The names of elements that define the intersection within the cube to which the string value is sent.
Importance of Sequence
It is important to note that the arguments (e1…en) follow a specific sequence in which e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element from the second dimension, and so on. It is crucial to ensure that you select the elements in the correct order based on the dimensions of the cube.
Use of Aliases
These arguments can also represent the names of aliases for dimension elements, offering flexibility in specifying the desired intersection.
Let’s consider a Sales Analysis cube with dimensions such as Year, Month, Customer, Product, and Measures:
- Year: 2015
- Month: Oct
- Customer: The Corner Cafe
- Product: Coffee
- Measure: Status
Suppose we want to send a string value of “High” to the “Status” value of the element “Coffee” in the “Sales Analysis” cube. We can use the DBSS function to do so.
You can use the DBSS function in the following manner:
DBSS("High", "Sales Analysis", "2015", "Oct", "The Corner Cafe", "Coffee", "Status")
By using the provided elements, you can utilize the DBSS function to correctly associate the string value “High” with the “Status” measure for the “Coffee” element in the “Sales Analysis” cube. This allows for accurate data representation and analysis within the TM1 environment.
In Planning Analytics for Excel (PAX), we like to keep things flexible and dynamic! Instead of sticking to old hard-coded values, we prefer referencing values from other cells. This approach lets us easily tweak and update the values in our reports.
Example of the use of DBSS in TM1 and Planning Analytics