Correcting myself. I was ranting about MS SQL and Cognos interaction. I was totally wrong. The problem, described shortly is: you have 2 databases in MS SQL residing on the same physical server you create a join “table A from db1 with table B from db2” Cognos creates two select queries (select * from db1.A) [...]
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes application. It should be set to “Yes” by default, imho. See how incremental publish can streamline your reporting in these posts: 1, 2.
on DMR’s pros and cons
on DMR’s pros and cons on DMR’s pros and cons
on DMR’s pros and cons on Macro functions and prompts in Cognos BI reports