At my client we experience performance issues regarding BW queries via BEx Analyzer ever since we upgraded to office 2010

Our current configuration:

what could be the issue? When executing via RSRT queries execute within seconds, but when going through the Analyzer it takes 10-20 minutes for the same query.

Thanks in advance for your suggestions.

Christian Brokken - CBBIC

Welcome to today’s BI/BW Forum!

We’re looking forward to some great discussion and  tips on tuning your BW landscape for better query performance today. Thanks to consultant and BI expert Joerg Boeke for joining us today and taking these questions during the hour. 

Joerg recently presented a number of sessions at our recent BI 2012 conference in Las Vegas, including a session on this topic. SAPinsider’s upcoming BI 2012 Europe event, June 6-8, also has a number of sessions on BW performance, and I invite you to join us there as well! 

I encourage you to post your questions early in the hour. We expect quite a bit of discussion today and  hope to get to as many questions as possible before the Forum ends at 12:30pm EDT.

To post your question for Joerg, first log in to Insider Learning Network. Then, in the forum, use the "Post Reply" button below to enter your questions. Joerg will post his answers directly in the Forum thread. Please refresh your browser to see the latest posts.

Hi, additional info, queries perform well when using bex web or bo analysis for office

Apr 23, 2012 -- 11:51AM, CBBIC wrote:

At my client we experience performance issues regarding BW queries via BEx Analyzer ever since we upgraded to office 2010

Our current configuration:

BI   Components

7.20 Patch 402

Check   done on:	23-4-2012   17:48:11
Excel Version:	Excel 2010 (14.0.6024.1000)
Windows Version:	Windows 7 Service Pack 1 (7601)
Default Browser:	Internet Explorer (9.0.8112.16421)
SAP GUI:	720 Patch 7

what could be the issue? When executing via RSRT queries execute within seconds, but when going through the Analyzer it takes 10-20 minutes for the same query.

Thanks in advance for your suggestions.

Christian Brokken - CBBIC

 

Hello,

yes indeed this is a common problem, you can even test it in frontend by using BEX 3.5 oening New queries.

The new world is working different. The old 3.x environment stored variables and settings within two hidden sheets. The new world stores the information in the Excel structure itself.

This cannot be changed. What you can do, there are a lot of performance settings I recommend in my session in Milano.

First of all, the exoerience at customers shows that migrated workbooks store some orphantdata, so try to build new ones.

Secondly check with OSS notes Note 912367 RSADMIN Performance Parameter  and

Note 1510916  Collective Note RS_FRONTEND_INIT parameters

These will help a lot with new workbooks

Apr 24, 2012 -- 11:33AM, petergmk wrote:

Hi Joerg,

My client is a merchant bank implementing BW and BO (WEBI) to for their financial reporting. My role is to create the all the BEx queries required for building the Universe on which the WEBI reports are created. In these BEx queries based on the standard DSO 0FIGL_O10, Financial Statement Item (0GLACCEXT) is enabled as a hierarchy under the Row and the key figure Balance (0BALANCE) placed under the Column. The 0GLACCEXT is something I added to 0FIGL_O10 and I created a BAdI for virtual characteristic to derive the value of 0GLACCEXT during the query run time based on the value of 0BALANCE, e.g. account 30001010 appears under two different parent nodes Assets and Liabilities in the 0GLACCEXT hierarchy and in the BEx report it should go to Assets if the run-time balance is larger than zero otherwise it should go to Liabilities. Without this BAdI solution, the data would double count in the report. But I am worried about the performance. I was told the number of records generated for the G/L account transactions is about half a million per day. It will be much appreciated if you have any suggestions on the design and performance as I have not got the chance to gauge the performance yet because not much test data is available at this moment though I believe there will definitely be a performance issue with the huge data volume as described. Thank you in advance.

Ming Kai

 

Yes your consideration is correct.

Virtual characteristics and keyfigures will eat up a lot of time concerning the different aggregation level of data.

If possible try to populate those keyfigures as real keyfigures within your design.

This will swap the performance load to the WHM not the reporting execution time.

Otherwise your users will getting bored.

Another option, try to use CACHE Warming. In case having as many records in cache the execution will be faster due to missing DB time.

Maybe you need to contact me out of this session due to the fact that this anwer will take longer