We have a Cognos 8.x and Cognos 10.x installation running a problematic report that takes up to 2 mins against traditional databases. We now have it setup against an in-memory database (Kognitio). The queries are now sub-second and some modifications to the cogdmod made some good improvements to the report run time but a significant chunk of the processing time remains in the Cognos DMR creating the virtual cube.
We had the derived table issue discussed elsewhere on the forum and are going to give it a try to see if we can push all processing to database only, but we get similar unsupported errors when trying DQM. Can the same trick of overriding the ODBC capability DQM=1 work?
Also, can anyone suggest other functions that could be overloaded to database functions or cogdmod/connection tuning that would take more of the work away from DMR and benefit from the speed of the database?