COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: WKar on 04 Nov 2008 01:32:43 PM

Title: Cognos BI connection to Bex - Performance
Post by: WKar on 04 Nov 2008 01:32:43 PM
Hello

Another question, we have (in one instance for testing) our framework manager pulling from a BW query data source, but the report runs FOREVER.

Please advise? Anything we can do about the performance?
Title: Re: Cognos BI connection to Bex - Performance
Post by: DustPanMan on 20 Nov 2008 02:06:25 PM
You can check your model to make sure that it is built properly.  WIthout seeing the model or the SQL that is generated, it is very hard to give performance tuning suggestions.
Title: Re: Cognos BI connection to Bex - Performance
Post by: pmoloney on 16 Dec 2008 10:11:44 AM
We've been doing similar tests of runniung C8 over BW and performance was pretty much the same as if we were running the query in BEx itself.  I'd suggest you look at the harware in place or do some benchmarking to at least establish what other factors may be coming into play.