on 09-19-2014 6:17 AM
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.
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/docs/DOC-6191
http://scn.sap.com/people/james.rapp/blog/2012/07/03/bi4-pattern-books-are-now-live
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.