SYMPTOM:
The following error is thrown when running a report in Strategy Developer:
Sample Code/Error
Error: Error(s) occurred while loading report: DSSSQLEngine: converting Report....Error in Process method of Component...
The report contains a metric defined with an ApplySimple statement.
CAUSE:
This error occurs when a pass-through metric is defined incorrectly with {~}. The ApplySimple is a scalar function and the {~} symbol in the metric definition requires the engine to attempt to Aggregate to report level.
The metric definition likely looks something like the following:
ApplySimple("statement with placeholders", ,) {~}
ACTION:
Remove the Report Level tag {~} from the metric defintion.
