I have a Transformer model that uses IQDs created by Impromptu as data sources and I am trying to recreate these queries in Cognos 8 by creating Report Studio reports.
One of the reports runs fine in Report Studio, retrieving the same data as the original Impromptu report but when I try to use this as a data source in the Transformer model, I am getting the following error message:
-UDA-SQL-0358 Line 19: Syntax error near "union".
-RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'. UDA-SQL00358 Line 19: Syntax error near "union".
I have narrowed down the problem to a calculated field in the report that calculates the running-difference.
Does anyone know what could be causing this error and how I can resolve it?
Any help would be much appreciated as this is driving me round the bend.
Just a quick thought - look at the properties of the query in your Report Studio report and make sure that "Auto Group & Summarize" is set to No.
MF.
Autogroup and Summarize was set to Yes but even changing it to No doesn't help. It is definitely the running-difference function that is causing the problem but as the original IQD was created from a report with exactly the same function, I can't understand why it doesn't work.
Thanks for the suggestion though.
Can you re-create this with GO Sales & Retailers and post up an example?