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

RQP-DEF-0149 The query specification is incorrect.

Started by DolAny, 16 Feb 2010 08:58:14 AM

Previous topic - Next topic

DolAny

Hi, community.
Could you land me you hand, please?

Environmental:
-DMR model.
-Report Studio 8.4
Task:
I have products sold by price > 100$ and <0$ in different countries.
I'd like to show within Crosstab:
GEO and amount of products sold by price > 100$ and <0$ as three columns.

My solution:
- I create Query2 with "GEO", "amount of products" and filter for products sold by price > 100$, "0" as value for column (calculated measure) that show products sold by price <= 100$,
- I create Query3 with "GEO", , "0" as value for column (calculated measure) that show products sold by price > 100$, "amount of products" and filter for products sold by price <= 100$
- I create UNION as Query 1

Trouble:
- The list is working perfect
- the crosstab doesn't want to work and error occurs

Error:
RQP-DEF-0502 Master dataset can not be used for the provided query Query2 as they do not match. RQP-DEF-0149 The query specification is incorrect. RQP-DEF-0457 Referenced Query 'Query1_tab' is not defined or its query items contain unresolved references.

Any help appreciated.