what is the reason to RSV-SRV-0042 error?

[bvk.cognoise]

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

[bvk.cognoise]

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