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?
hey, can you send your report specification (Report Studio , Tools>>Copy report to clipboard and paste into notepad)...might be i can help
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.