MicroStrategy ONE

ConcatAgg (Concatenate Plus Delimiter)

The ConcatAgg function takes all of the content from a single input and concatenates the content as a single string. By default, each string of characters that is concatenated is separated by a comma. You can define the delimiter.

Syntax

ConcatAgg<Delimiter, FactID

Where:

  • Argument is facts, metrics, columns, or string values.
  • Delimiter is a parameter that determines the characters used to separate each concatenated value. By default, a comma is used.
  • FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.

Example

The ConcatAggBlank function can help to create attribute forms that are a combination of multiple rows in database tables. For example, an LU_CUSTOMER table includes a column CUST_LAST_NAME. You can create a single attribute form that combines all the values (rows) for CUST_LAST_NAME into a single attribute form:

ConcatAgg([CUST_LAST_NAME])

Each last name is concatenated, separating each last name with a comma by default.