Question Re: Web Intelligence: how to improve performance in Technology Q&A

Web Intelligence: how to improve performance

Former Member — Wed, 27 Jan 2010 10:25:56 GMT

Hi!

I really need help to improve performance of my Business Objects servers (version is Enterprise XI 3.1). I cannot find the "sizing guide" and I'd like to understand which servers I can duplicate ... & so on.

Problem is that there are many rows saved in the repository that need to be "organized" into report when users see the last report instance

Is there anyone that can help? What can I try do to from the architecture side?

Many thanks indeed

Re: Web Intelligence: how to improve performance

Former Member — Wed, 27 Jan 2010 21:27:50 GMT

Sizing document is not listed in the public documents. But you can get it from Business Objects by opening a ticket.

Can you please explain the second part of your requirement? Reports are stored in FRS and user and rights etc info is stored in the DB repository. There is nothing to tune the DB repository. If the report is pulling more data, yo have to tune the query.

Re: Web Intelligence: how to improve performance

Former Member — Mon, 01 Feb 2010 13:58:28 GMT

Hi,

thanks for replying... what I need is to understand how I can configure and set properties of all Business Objects servers (listed in the "Servers" page of CMC), to improve Business Objects Web Intelligence performances. The current poor performances I'm experiencing are related to the large amount data saved in the repository, for each hystorical instance (in fact I'm not refreshing reports, generating queries on DB, but I'm only viewing the latest instance)

Thanks for any further suggestion

Re: Web Intelligence: how to improve performance

former_member142702 — Mon, 01 Feb 2010 14:14:59 GMT

how many data rows are stored in your instances? How long does it take to display such an instance?

Is your file repository local or on a network drive?

Regards,

Stratos

Re: Web Intelligence: how to improve performance

Former Member — Tue, 02 Feb 2010 17:44:04 GMT

I presume you're on XI 3.1 with no patches installed. i.e. no Fix Packs.

I don't know enough of your deployment to make suggestions with any sense certainty. That said, you might want to look at the cache size for the Web Intelligence Proc Servers (SAP NOTE: 1344492).

We're on XI 3.1 (12.1.0.882) and were having similar issues. Purging the cache daily has done wonders for performance.

Re: Web Intelligence: how to improve performance

Former Member — Thu, 04 Feb 2010 15:30:35 GMT

Hi, thanks for suggestion...how can I purge the cacheof my Web Proc Servers? Does it come by restarting the server?

Re: Web Intelligence: how to improve performance

Former Member — Thu, 04 Feb 2010 18:51:07 GMT

No. The cache will need to be deleted outside of Business Objects. Restarting the Webi Proc Servers does not delete files in cache.

The default cache directory for the Webi Proc Server on *nix is

<install_dir>/bobje/data/<cms_port/storage/

I believe the equivalent on Windows is

<install_dir>\BusinessObjects Enterprise 12.0\data\<cms_port>\storage\

Look at the size of the /docs directory in the /storage directory. This is the directory we purge every 24 hrs.

There is more information in SAP NOTE: 1368964 - When Web Intelligence performs its cache cleaning, only the .wid files are cleared leaving XMLs, XSL, CSV, TXT and PDF files to take up disk space

Best.

Srinivas

Re: Web Intelligence: how to improve performance

Former Member — Fri, 05 Feb 2010 08:36:16 GMT

this would be very helpful indeed! thank you!!!

one more question: how do you delete daily this directory? Are you removing all files in it with a scheduled task?

What these files are created and used for?

By the way I can't find SAP Notes 1344492 and 1368964, how can I search for them?

Edited by: Tube Girl on Feb 5, 2010 10:00 AM

Re: Web Intelligence: how to improve performance

former_member136842 — Fri, 05 Feb 2010 09:18:27 GMT

Hi,

yes you could to this via the task manager on WIN or via a Script on *nix.

You find those SAP Notes on the SAP Service Marketplace (SMP)

- service.sap.com

- sap support portal

- enter s-user id and password

- click on "help & support"

- enter the Number on the top right.

Regards

-Seb.

Re: Web Intelligence: how to improve performance

Former Member — Fri, 05 Feb 2010 15:11:04 GMT

I use a script that runs every 24 hours. I delete the entire /doc directory. The Webi Proc Server recreates the directory when new cache files are generated.

The /storage directory contains Webi Proc Server cache files. i.e. wid, xls, pdf etc. In XI 3.1, only *.wid files are deleted during the cache cleanup; other files/directories remain, causing the cache to grow indefinitely.

You will need a S-User ID to look at the notes:

[1368964 - When Web Intelligence performs its cache cleaning, only the .wid files are cleared leaving XMLs, XSL, CSV, TXT and PDF files to take up disk space|https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3133363839363426]

[1344492 - Web Intelligence Report Server cache is growing larger than the Maximum Document Cache Size|https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3133343434393226]