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

Issue Merging Reports: Queries for the Set Operation Are Incompatible

Started by juliaf, 25 May 2010 06:12:55 PM

Previous topic - Next topic

juliaf

Hi All,
I have lurked on these boards for quite some time now and they have always been useful for finding answers- thanks to everyone! I am finding myself stumped on this issue- and I can't seem to find anyone who has encountered a similar problem. Basically I have two separate reports, lets call them Report 1 and Report 2, with their own queries named uniquely. For example:

Report 1 would have:
-Query A
-Query B
-Query C (a union between A and B, A U B)

Report 2 would have:
-Query D
-Query E
-Query F (a union between D and E, E U F)

*note that query A, B, D, E are all based on the same data source with the same columns.

Basically what I am encountering is Report 1 and 2 will run fine individually on their own. However, if I try to merge the two reports into one (not changing any of the queries or layout- simply appending queries and layout one beneath the other) Cognos will give the following error: RQP-DEF-0182 The queries for the set operation are incompatible.

When I merge the reports- I change nothing. But its like Cognos can't run both sets of queries in the same report....??

Any help or suggestions would be greatly appreciated!! Thanks!

MFGF

If you view tabular data for each underlying query - A, B, D, E - does this return expected results?  What then happens if you view tabular data for query C and query F - do you get the same error from one/both/neither?

Regards,

MF.
Meep!

juliaf

Hi MFGF,
Thanks for your answer. Individually the queries all run as expected and none return any errors. The unions C and F run as expected as well without any errors. It seems the error only comes when trying to run the whole report together. Worst case scenario I can always maintain these as two separate reports- but it would be nicer for users to receive one report instead of two. I guess I am not understanding why these reports work separately but won't work together-- frustrating.

Thanks,
J

MFGF

Very odd!  What layout objects are referencing the queries?  Do they have anything advanced such as variables/conditional highlighting which may not have copied across from the original report and could be causing odd behaviour?

If you temporarily remove the layout objects and replace them with simple lists, does the error still occur?

MF.
Meep!