KB213490: Error "Conversion failed when converting the varchar value 'xxxx' to data type int" happens when displaying Picture type attribute form using ApplySimple in expression against SQL Server 2012 in MicroStrategy Analytics 9.4.1

SYMPTOM:
The attribute form is in Picture type and defined with the following ApplySimple function with Int type column [ID_BARANG] as the input parameter against SQL Server 2012.
 

ApplySimple("'images/demo/'�&'.png'", [ID_BARANG])

Conversion failed when converting the varchar value 'images/demo/s' to data type int.

• Create an attribute form as type Picture and us custom expression as below where column [ID_BARANG] is of type Int in the database.
   

• ApplySimple("'images/demo/'�&'.png'", [ID_BARANG])
   
  
• Create report with the attribute and show the Picture form.
• Run report in Web and Developer. Error message will occur.

 
CAUSE:
The syntax used in ApplySimple is incorrect for SQL Server 2012 database.
 
ACTION:
Use Concat function instead.

Concat("Images/demo/s", [BARANG_ID_INT], ".png")