CPU usage while running Bex report

[Former Member]

Hello,

Sometimes, when I run a Bex report with many lines the computer CPU Usage is 100% (=full ) for a long time. In some cases i need to do restart again for the computer.

In the WAD it doesn’t happened...

Did anybody have the same problem? Is there a way to reduce the CPU usage?

Please Advice,

Amir

[Former Member]

Hello,

there are quiet a few performance pitfalls with Bex Analyser and large result areas. The problem is in most cases not Bex but Excel. A few things you want to look at are:

- OSS 852700: Performance issues with Excel Calculations in the Analyzer.

- Remove all sub-totals. Many sub-totals kill the performance

- Switch off the formatting if you don't need it.

Any questions please let me know.

Stefan

[S0004647611]

Amir,

This is "normal" behaviour in Bex with query's which return very long lists. The client computer already received all data, but is formatting the layout.

Solutions:

1) a faster pc with enough memory (512 mb) and win200 or >.

2) a query with less return rows.

The reason that in wad (web reporting) this is not experienced is because the formatting (rendering html) from the result table is done within the WAS (application server, which is hopefully faster then your PC...). Your browser only receives the html page..no exotic hardware needed for that..

Any questions left: please ask; if you're satisfied please grant with rewards.

Kind regards Patrick Rieken.

Message was edited by: Patrick Rieken

[Former Member]

Hi Amir,

You may look at OSS Note #567746 - 'Composite note BW 3.x performance: Query & Web Applications'.

Best regards,

Eugene

[Former Member]

Hi Eugene,

I already looked at that note but didn't find the solution.

Amir