Skip to Content
Author's profile photo Former Member

Major Lessons Learnt from BW 7.30 Upgrade

Dear SAP BW-ers,

This is my 1st time blog posting experience, I would like to share with you my journey when upgrading to BW 7.30 SP05 from BW 7.01 SP07.

Whatever I’ve written below is purely my opinion and not my employer.

It has been a painful project yet rewarding since this will enable the BW to be on HANA and have much better integration with other Business Objects tools.

Data Modelling Issue

·         There is a new data validation check procedure in BW 7.30, some of our daily batch jobs fails because of this new behavior. We have to remove conversion routine in 0TCTTIMSTMP and also write an ABAP routine to do the conversion during data loading. The same thing happened for 0WBS_ELEMT, we wrote a routine to fix this thing as well.

·         Cannot activate an InfoSource after the upgrade, run program RS_TRANSTRU_ACTIVATE_ALL in debugging mode and set the value of the parameter “v_without” to “x”.

·         3.x DBConnect Data source stopped working after upgrade, needs to be regenerated because it was corrupted after the upgrade Go-Live

BWA Issue

·         If you are running on BWA 7.20 lower than revision 22, please set the query properties back into using Individual access instead of Standard/Cluster access. You can also do mass maintenance of every queries in an InfoProvider in transaction RSRT. If you don’t do this you will be having major performance problem, for example a query that used to take 9 secs before upgrade will come back in 800 seconds if the cluster access is enabled.

Reporting Issue

·         Error #2032 because of dashboard crosstab data binding, we experienced this with most query that has 0CALDAY. You have to remove the 0CALDAY and then put it back again in the query so that the BICS connection will be refreshed from the query to the dashboard.

·         UOM conversion issue after the upgrade for some query, implements this SAP Note 1666937 to solve the issue.

·         Cell defined value was not impacted by scaling factor in BW 7.01, but in BW 7.30 it does. We have to make lots of adjustment in few queries because of this.

·         A condition on a hidden key figures no longer supported in BW 7.30, again some queries has to be adjusted because of this.

·         Dashboard Design 4.0 cannot be connected to BW 7.30 system until we upgrade SAP GUI version to 7.20 SP10.

This is the list of major issues that we encountered so far a week after Go-Live; hope that this will help your journey. I personally say to run the upgrade better we need to have a copy of production right before the upgrade and do the heavy testing few times and involve the business when doing so. You will then expect only few minor issues during the go-live.


Erdo Dwiputra

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Tammy Powlas
      Tammy Powlas

      Great seeing you blog and sharing your experiences!


      Author's profile photo Former Member
      Former Member

      Thanks for the encouragement, Tammy.. Really nice to have SAP Mentor like you 🙂

      Author's profile photo Roland Kramer
      Roland Kramer


      Did you had a chance to see these Informations?

      Best Regards Roland

      Author's profile photo Former Member
      Former Member

      You should look up John Appleby, he has a lot of experience of BW on HANA and could be a good contact for you.

      Thanks for blogging, I hope you continue to post about your experiences!

      Author's profile photo Former Member
      Former Member

      Thanks for the reference Tim, I followed him on twitter as well.

      Last time I saw him doing BW on HANA in Mac Mini, EPIC!

      Author's profile photo Former Member
      Former Member

      Just took me back to when we upgraded at the beginning of this year! Thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      Hi Zimkitha,

      Thanks for your comment.

      What was the motivation to upgrade to 7.30? And since you're already using it for quite some time what are the most beneficial new features that you are currently using?

      At the moment we are thinking to deploy at least SPO.

      Author's profile photo Ashfaq Ali
      Ashfaq Ali

      1)Any idea when is SAP planning to have the latest release of BW (meaning 7.3) for SCM product. As we will be working on a conversion project using BODS 4, we wanted to use the latest functionality of Data Services source system which is present in BW 7.3 but our latest SCM (APO) does not have 7.3 in it ?

      Any idea when is it due to come ?

      Author's profile photo KD Jain
      KD Jain

      Thanks for sharing your experience... Keep blogging

      Author's profile photo Satendra Mishra
      Satendra Mishra

      thanks for sharing ur time and knowledge with us.



      Author's profile photo Former Member
      Former Member

      Good one Sir !