KB14442: ‘Syntax error or access violation: Variable #table_name# not found’ error occurs when attempting to execute a datamart report against Sybase IQ 12.5 in MicroStrategy Developer 9.4.1 and 10.x

SYMPTOM:
When a user attempts to execute a datamart report in Strategy Developer 9.4.1 and 10.x against Sybase IQ 12.5, the following error occurs:
 

SQLExecDirect. Syntax error or access violation: Variable '#table_name#' not found

• Create a report with one attribute.
• Configure the report as datamart report with the 'Create a new table' option selected, as shown below:
  

• Execute the report. The error described above occurs.
• The SQL for the datamart pass looks something like:
  select distinct COL1,...
  into DATAMART_TABLE
  from TABLE1,....
  

CAUSE:
The above SQL syntax 'Select ... Insert into #table_name#', does not constitute valid SQL syntax against Sybase IQ 12.5, it is however valid against Sybase IQ 12.6.
 
ACTION:
Change the VLDB setting 'Table Creation Type' to 'Explicit Table' for the datamart database instance, as shown below: