Cognos BI connection to Bex - Performance

[WKar]

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?

[DustPanMan]

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.

[pmoloney]

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.