KB18023: How to create a metric that concatenates a string metric with an Integer metric in MicroStrategy Developer 10.x against SQL Server or Oracle

SYMPTOM:
A user wants to create a metric value that concatenates a metric which contains integer values and a metric which contains strings values, as shown in the image below.

 
ACTION:
Follow the steps below to do this:

• Create a new metric.
• Add the following expression if using SQL Server.
  

• ApplySimple("str(#0) + #1", , )
  
• Add the following expression if using Oracle.
  

• ApplySimple("CONCAT(to_char(#0, 999999) , #1)", , )
  
• Validate the expression.
• Save and close the metric definition.
• Add the metric into the report and the concatenated metric should display as shown below: