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

Union Error

Started by Luhaine, 24 Nov 2008 08:38:06 AM

Previous topic - Next topic

Luhaine

Hello,

I've been having some issues with creating a union in report studio. I have three different queries that provide data that I want to use in a crosstab.

Query 1: Mobile Phone costs within condition A (during workweek)
Query 2: Mobile Phone costs within condition B (outside workweek)
Query 3: Mobile Phone costs within condition C (international calls)

Each query works on it's own and returns the correct results.

When I run the union query, through "View Tubalar Data", I am getting the following error:

SubQuery 'Total_Query_during_workweek' used in a set operation cannot use members or member functions.

At first I thought the query was still linked to something or other in the report but I've removed it there.

Any tips or pointers are appreciated.

-Luhaine

Luhaine

Issue is fixed. Haven't quite figured it out yet what went wrong but I based the union on two working queries that were already present in the report (made them a 1:1 copy), this gave the error.

I rebuild each query into a new one from scratch and then it worked.