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.