I have a report that has 5 separate queries. The Execution Method was set to the default (Sequential). So I thought I could change it to Concurrent and expect to see all of those queries ran at the same time in SQL Server. But it isn't doing that. They continue to be Sequential. Anyone have any experience with this? If I can get them to run Concurrently then I would think the report would execute faster as well. Is there an actual Cognos Server Setting to allow this property to work the way I expect it to?
Yes there is a server setting that needs to be flipped.
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=138326