Tag Archives: tips

Cognos and MS SQL — happy together

 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) [...]

Incremental Publish in EP

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.