MicroStrategy ONE

Steps to create a column alias in Query Builder

A column alias is used to name and identify a column expression in a SQL query. A column alias is displayed only in the SQL syntax of a Query Builder report when you run the report in SQL view. A column alias is not displayed in grid or graph view of a Query Builder report.

To create a column alias

  1. Access the Query Builder Editor.

  2. Select a column. A column is created and displayed in the Selections pane (the bottom pane on the right).

  3. Select the Alias field in the row of the column expression you want to create an alias for.

  4. Type in the alias to use for the column expression in the SQL query.

Column aliases are automatically created when you perform a simple aggregation on a column expression.