1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

SAPBW

Quick Tip to Enhance BW Query Performance

Monday, 18 June 2018 11:15

Quick tip to enhance BW Query Performance

If  you get a complaint from end user that an SAP BW Query is performing awfully low, the first step to be taken is that you must try to understand the expensive average response time component. If the analysis reveals that the performance is low due to  inefficient execution plan caused by obsolete update statistics, then it is recommended to update the statistics for the infocube using RSRV transaction.  As an additional measure, you can instruct BW support team to introduce the process type “Construct Database Statistics” (under Data target administration) in the process chain itself, the same should be added right after data is loaded and index is created on the infocube.

 

 {fcomment} {flike}

Share

Quick Tip to Enhance BW Query Performance

BEx- Export to Excel – Results in xls file with huge size (i.e. 50 MB)

Monday, 18 June 2018 11:15

If you have worked with BEx Web Analyzer, you must have got into a situation where the query results downloaded using “Export To Excel” functionality will be of huge size. I just wanted to give you a background on why it is resulting in huge file size and the ways to avoid such issues.

Read more...

BEx history is missing

Monday, 18 June 2018 11:15

 

Do you want to activate BEx history to view recently executed reports/workbooks?

Here are the steps to activate the BEx Personalization.

 

 

1. SPRO

2. SAP Cusotmization Implementation Guide

3. Business Intelligence

4. Settings for Reports and Analysis

5. Activate Personalization in BEx

 

BEx history is missing

BEx history is missing

Monday, 18 June 2018 11:15

Do you want to activate BEx history to view recently executed reports/workbooks?

Here are the steps to activate the BEx Personalization.

 1. SPRO

2. SAP Cusotmization Implementation Guide

3. Business Intelligence

4. Settings for Reports and Analysis

5. Activate Personalization in BEx

 

{fcomment} {flike}

Share

BEx history is missing

Handling “Warning concerning the BW extraction” during support pack/add-on installation/upgrades

Monday, 18 June 2018 11:15

 

During support pack upgrades, there has always been a confusion on whether to ignore the open data extraction or to take necessary actions when we hit the open data extraction found warning message, below sections will provide some insight to data extractors, so that one can make necessary decision while getting open data extraction related warning message.

 

Read more...

SAP BW