Skip to Content
author's profile photo
Former Member

CPU usage while running Bex report

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 27, 2005 at 07:37 AM

    Hi Amir,

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

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 29, 2005 at 09:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 30, 2005 at 11:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded