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

SUBJECT QUERY AND REPORT UTILIZATION

Started by gosoccer, 12 Feb 2018 01:27:36 PM

Previous topic - Next topic

gosoccer

HI,

I have  a Subject Query that is excluding a lot of bad data from a different table in the physical layer in my model. so lots of
select * from good
except
select * from bad
where x.id in bad

now, the above is repeated 18 times in my only subject query in physical layer.
How can I do the 18 "Except" in a way that the actual Report Studio (Cognos 11 Analytics) doesn't run
the "Excepts" and just run the result set after the rows are excluded from BAD.

We are still running CQM for the Db connection.

Thanks in advance for your time.