Hi,
i created a union query and create a report.now my my problem is when im running that query im getting the following error
RQP-DEF-0182
The queries for the set operation are incompatible
again i searched in IBM website i follow the same steps which was given by IBM (i used same data items and package(gosales query) ).here is that link.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id9132cr_rptstd_wrkdat_create_union_query_.html
im getting the same problem even im following these steps.please solve this issue. it is very urgent .....your help highly appreciated.. :(
thanks
bvk
Hi,
i solved this issue myself.......
i did a mistake while dragging data items into the Query2 and Query3
>we must drag same type of data items in a order in both query's
for eg:
in query2: Product Line(Attribute)
Revenue(fact)
Sort key(identifier)
in Query3:Order method(Attribute)
Revenue(fact)
Sort key(identifier)
we should not do like this
for eg:
in query2: Product Line(Attribute)
Sort key(identifier)
Revenue(fact)
in Query3 :Revenue(fact)
Sort key(identifier)
Order method(Attribute)
data items order must be same in both query's...then we will get output..
thanks
bvk