Upgrading to 10.2.2 from 8 - some cubes are experiencing long running queries

[jsjones]

Hello all,
We are currently upgrading to 10.2.2 from 8.  We have about 10 cubes that will need to be converted over.  There are about 3 of those that while build in C8 took 2 hours, it is taking far longer in 10.  Originally the cubes were built off of IQD files.  I took the SQL from those files and created reports out of them in C10.  Now the cube build times are very long.  While I would love to just replace these cubes with a DMR or even a package, there are too many reports to tackle that endeavor as of now. 

I'm looking for suggestions to get this righted so we can move past it, and get this upgrade finished.

Thanks,
Jeff

[prikala]

As a temporary Quick&Dirty workaround, you could use IQD sources withc 10.2.2. Build times should be the same as in C8.

As a real solution, take a look at the SQL that your reports generate when they are used as cube datasource. Try to fix that.

I am not sure where I got this idea from but reports might be more unefficient as cube data sources than packages.
So if your datasource is currently a report, try using the same querysubjects directly at the transformer model.

[jsjones]

Thank you for the suggestion.  I will try that route.  Anything at this point to keep this upgrade moving along.

[CharlesAZ]

Check your SQL in the Cognos 10 Report and compare it to IQD file, see if there is a issue with your report or framework.  Other considerations database functions vs Cognos functions see if this could be impacting as well.  Typically Database functions will perform better. 

Thanks

Charlie