MicroStrategy ONE
Max Metric Alias Size
Max Metric Alias Size is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.
Max Metric Alias Size allows you to set the maximum size of the metric alias string. This is useful for databases that only accept a limited number of characters for column names.
Set the Max Metric Alias Size VLDB property for the following gateways:
| Gateway | Max Metric Alias Size |
|---|---|
|
SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 |
128 |
|
Azure Synapse |
128 |
|
Db2 |
128 |
|
PostgreSQL |
63 |
| Oracle 12c | 30 |
|
Oracle 12cR2 Oracle 18c Oracle 19c Oracle 21c |
128 |
|
Redshift |
127 |
|
Teradata 15.x Teradata 16.x Teradata 17 |
128 |
| Google BigQuery | 128 |
|
Snowflake |
256 |
Levels at Which You Can Set This
Database instance only