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

Crosstab with Union Query

Started by BiliBoy, 19 Oct 2012 03:10:59 PM

Previous topic - Next topic

BiliBoy

Hello Experts

I have created crosstab report based on union query. From the final query  i am trying to use two coulmns and two measures but when i introduce  second column and two measure i am getting below mentioned error.
RQP-DEF-0149 The query specification is incorrect.
RQP-DEF-0469 The query 'Ethnicity+Group_tab0_sub' references the non-existent query 'AAA-BBB-CCC'.

can anybody tell what am i doing wrong?

in final query(crosstab query) i have one data item with aggregate function= count distinct and rollup aggregate function=Automatic,which is one of my measure.
i am able to put one column and two measures under the column but as son as  i introduce second column, i am getting error.