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

Unions in Report Studio

Started by ComplexQry, 12 Oct 2007 07:28:50 AM

Previous topic - Next topic

ComplexQry

I have made 3 simple queries that produce results from 3 different Fact Tables.  Each Query is structured the same (Column names/Data Types).  But when I union them together, I get blank results.  But if I view Tabular Data, it looks fine.  Any thoughts?

Maple

hey, can you send your report specification (Report Studio , Tools>>Copy report to clipboard and paste into notepad)...might be i can help

rockytopmark

In the query subject resulting from creating the Union, make sure you have selected query items from the original query(s).  Just doing the Union will not create the items of the Union Query.