If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

UDA-SQL-0114 & UDA-SQL-236

Started by colt, 17 Oct 2011 02:17:11 AM

Previous topic - Next topic

colt

Hi,
I have a relational report with some queries.
Query1 selects revenue totals for the last 6 years.
Query2 selects budget total for the last 1 year.
Query3 selects as join Query1 x Query2 the Deviation Revenue-Budget for the last year-

Query4 Unions Query2 & Query3.
Query5 Unions Query4 & Query1.

So finally I want 8 lines showing actuals + budget + deviation.

When I insert lists to show the results of the queries, Query1 - Query4 show the expected results.

Results of Query1:
2011009; 2011008;1;2006;9231231,12;totalcompany
2011009; 2011008;1;2007;10231230,24;totalcompany
2011009; 2011008;1;2008;11899814,35;totalcompany
2011009; 2011008;1;2009;10230454,46;totalcompany
2011009; 2011008;1;2010;10767890,86:totalcompany
2011009; 2011008;1;2011;11787169,65,totalcompany

Results of Query4:
2011009;2011008;2;2011;12300876,76;totalcompany
2011009;2011008;3;2011;-513707,11;totalcompany

But when I add list for final Query5, I get the following error message:

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0236 Left table attribute is not a key.

I don't understand why it should be impossible to union the 2 queries.

Any suggestions ?


Arsenal

sounds like an issue with the data item you're using to Union query 4 and query 1