cancel
Showing results for 
Search instead for 
Did you mean: 

SAO BOBI 4.1 SP4

former_member552170
Participant
0 Kudos

Hi all,

   In our landscape, one new requirement came. The requirement is oen webi report is fetching two years data from BW query. And while refreshing every time in launchpad its taking too much time to load the data so client want a solution to fetch the data every day morning. And whenever the users refresh the report then it should not take too much time to load. Please suggest your inputs.

System Details:

BOBI 4.1 SP4

Oracle 11g

BW 7.01

Thanking you in anticipation.

Regards,

Obinna.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear

there are many factors that can play in this, starting from proper Sizing, proper tuning of APS and WPS servers to configuration of Java app server used, network between BI servers and data sources and even report design.

This sort of question have been asked before in this forums, there are also SAP KB articles on sizing, performance and other areas that are part of this question.

I'd start here :

https://service.sap.com/sap/support/notes/0001570271

https://service.sap.com/sap/support/notes/0001694041

https://service.sap.com/sap/support/notes/0001522418

http://scn.sap.com/community/coil/blog/2012/06/12/best-practices-for-running-bi-4-in-virtualized-env...

http://scn.sap.com/docs/DOC-6191

http://scn.sap.com/people/james.rapp/blog/2012/07/03/bi4-pattern-books-are-now-live

Regards

former_member552170
Participant
0 Kudos

Hi Rajendra,

   We have did the proper sizing in our landscape. Please find the configuration details.

Processor: Intel Xeon CPU 2.4 GHZ(2 processor)

CPU : 16

RAM : 64 GB

Windows 2008 R2 Enterprise

Frequent users : 20

Total Users : 100

Obinna

Former Member
0 Kudos

Dear

As you suggest your sizing kindly look in to work process increase background and dia workprocess then you will get result faster

Regards

former_member552170
Participant
0 Kudos

Hi Rajendra,

   BW has 21 dialog and 18 background process. I think its fair enough. Please suggest.

   Thanking you in anticipation.

Obinna

former_member197037
Participant
0 Kudos

Hi Obinna,

Using the scheduling feature in BO is your best here.

You can schedule your reports to run early morning so that the employees will have the updated report first thing when they reach office.

Refer the admin guide for details on setting up scheduling:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp4_bip_admin_en.pdf

However, to better your system performance you can also refer to the solution provided in the following thread:

Hope this helps.

Thanks,

Nagendra

former_member552170
Participant
0 Kudos

Hi Nagendra,

   Thanks for your inputs. I tried that method already. I scheduled the same report to run daily in the morning. Then also we are facing this issue. Please suggest.

Obinna

former_member197037
Participant
0 Kudos

So if I understand this correctly, viewing the scheduled instance is also taking a lot of time?

former_member552170
Participant
0 Kudos

Hi Nagendra,

   Yes, But i have few more reports also but am facing this issue only with one report. Is there any other way to store the report data in cache. Please suggest.

Obinna

former_member182521
Active Contributor
0 Kudos

Kindly verify whether "refresh on open" option is enabled in your report. If it is so you are required to uncheck it.

Since you are already scheduled the report along with the data, It is unnecessary to refresh it again while opening it.

former_member552170
Participant
0 Kudos

Hi manikandan,

   Thanks for your inputs. Refresh on open option is not enabled for that report. I have scheduled the report and then also while opening the report its not showing the refreshed the data. After closing the report and  when i open the report it will not show the refreshed data. Your help is highly appreciated. Please suggest.

Obinna

former_member182521
Active Contributor
0 Kudos

Have you enabled this

former_member552170
Participant
0 Kudos

Hi Manikandan,

    The View Latest Instances is already enabled for webi application. Please suggest.

Obinna