KB8903: How to specify that metric names be used as column aliases in the SQL generated in MicroStrategy Developer 9.x and 10.x

In Strategy Developer, by default, the metric name is not used as the column alias in the report Structured Query Language (SQL) generation.
For example, the metric Revenue in the following grid is referred to by the name of 'WJXBFS1' in the SQL, as shown in the report below:
 
 

Strategy has a Very Large Database (VLDB) setting to allow users to change this default behavior at the project level so that the metric's name can be used as a column alias.
 
To change the Strategy SQL Engine's default behavior and use the metric's name as a column alias, configure the VLDB setting, 'Default to Metric Name'. To locate this setting:
 

• Go to 'Project Configuration' for the specified project (Right-click on the project to open the Project Configuration editor).
• Under 'Project Definition', choose 'Database instance'. The 'VLDB Properties' button will appear. Click on this button to open the VLDB Properties editor.
• Open the Metrics folder. Under 'Default to Metric Name', uncheck the 'Use default inherited value' box and click the radio button for 'Use the metric name as the default metric column alias'.
  

•  
  Note: For this setting to take effect in 2-tier, the user must disconnect from the project source. In 3-tier, the Strategy Intelligence Server must be re-started.
   
  
• Re-execute the report.

Observe in the SQL View that the metric column alias was changed to the metric's name, which is "Revenue".