KB17917: How to create a metric that will return a static string in MicroStrategy Developer

In certain situations, a user might need to create a metric that returns a static string in a Strategy Developer report. Follow the next steps to create this type of metric.
 

• In Strategy Developer, create a dummy metric with the following definition
  Max(1)
  
• The metric definition is shown in the image below:
   
  

• Create a second metric with an apply simple statement and using the dummy metric on its definition, as shown below.
  

•  
  ApplySimple(" 'Text goes here' ", Dummy)
  

Below is the Structured Query Language (SQL) for a report that contains the attribute 'Year' and the metric created above in the Strategy Tutorial project:
 
select a11.YEAR_ID YEAR_ID,
'Text goes here' WJXBFS1
from LU_YEAR a11
group by a11.YEAR_ID
The results of the report are shown below. Note that the desired string is repeated across all rows.