Exploring TM1 - a Chartertech Company
Search
Close this search box.

DBSS TM1 Excel Syntax and Use

The DBSS function sends a string value to any TM1 cube’s cell.

DBSS Syntax

The syntax for DBSS is:

DBSS (string, cube, e1, e2,…en)

Where:

  • 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.

Example

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.

Usage

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

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In