Skip to Content

Need guidance on Upgrading SAP BW 7.3 (on SQL Server ) to SAP BW 7.5 (SQL Server)

Hi BW Experts,

Thanks for being very helpful in clearing all the questions i have been posting on SCN so far . I am very thankful to all of the SCN family mebers for the support and help.

I would also need your guidance / help in understanding the roles of SAP BW Consultant in the below listed project .

" Our client wants to have BW technical upgrade from SAP BW 7.3 (SQL Server ) to SAP BW 7.5 (SQL Server ) very soon " .

We are not using SAP BW as the EDW(Tera data is being used as EDW system - ECC-->BW-->Tera data ) no BEx queries/reports are built in BW .Its just acting like an intermediete system (Mainly for Sales and Inventory modules ) . This upgradation also happening because only for the reason after 12/2020 SAP Said they dont support SAP BW on 7.3 .

I have below list of quesitons .

1) Before upgrade :What are the list of mandatory activities need to be performed by a BW Consultant in BW /ECC system.

2)Post Upgrade : What are the list of mandatory activites need to be performed in BW /ECC system by a BW Consultant?

3)Master check list of all activites (BW Side /ECC Side ) /Precautions .

4)What are the possible risks of this BW-upgradation Project ( Is there any channce that any of the existing BW objects like Master data Iobj / DSO's / Transforations / Data sources /Process chains / IP / DTP ...gets distrubed)

5) Is there any risk of loosing the existing data in the info providers in BW after upgrade ?

6) Do we need to unschedule the process chains before the upgradation and reschedule them after upgradation ?

7) Is there any way it will effect the Delta pointers in Delata queue in RSA7 ?

8) DO we need to unschedule the jobs in SAP Source system ( Jobs which used to fill the data into set up tables and jobs which are used to bring the data from extraction queue to Delta queue ?)

Please also mention all other list of mandatory activities (If i missed above ) that it will be very helpfull for me to work on this Project .

Thanks ,


Add a comment
10|10000 characters needed characters exceeded

  • 1- Before Upgrade: You will need to identify the objects that are no longer supported or need tweaking as per newer version. There is lot of info and notes available on support portal about this but a few things include Info Spokes, handful functionalities within info providers etc, Older version of BW reports(might not be relevant for you if you dont use BW reporting), some custom routines in your transformations, customer exists etc

    Some of these incompatibility will also appear when your BASIS team starts the upgrade activity and when things start to fail. Just document everything from the error message to fix applied in lower environments

    2 - Post Upgrade:Full scale testing should tell you if everything works as expected or not. There is one list which I have published here long ago, have a look. If you have missed anything identifying before upgrade then you should be able to cover the fixes part of this activity

    3 - Again refer above list, it all depends on your landscape and I dont think anyone can tell you exactly what is required for your situation

    4 - This again, there is no straightforward answer, most objects are supported from 7.3 to 7.5 except if you have customisations done to objects, it wold be handy to have some buffer allocation for ABAP & Security to handle any unforeseen situations

    5 - Not really unless your BASIS team does some screw up during upgrade

    6 - All jobs should be and will be removed from schedule before upgrade anyway by BASIS but worth making sure you do run all your chanin just before system is brought down to flush deltas

    7 - This is very crucial and all depends on upgrade project plan - cutover tasks before and after upgrade. BASIS team play crucial role on how they perform BDLS followed by your full scale testing running all PCs and testing the data. Worth doing data recon before and after upgrade plus asking business to post some new test data to validate your delta pointers

    8 - same as 6


    Abhishek Shanbhogue

  • Frederic Cincet S Sriram Abhishek Shanbhogue

    Please help me in answering the above queries .

    Thanks alot in advance.

Related questions

2 Answers

  • Posted on Jul 21, 2020 at 03:35 PM

    Hi Teja,

    The only things you have to do is to read and follow the associated upgrade guide.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2020 at 05:36 PM

    Hi Taja.

    1. Before starting the BI upgrade, check the ECC version is supported NW 7.5? refer SAP note 1388258 along with PDF file.

    2. Point number 2 to 8 Refer the SAP BI NW 7.5 upgrade guide.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.