SAP BW Upgrade – SAP BW7.01 to SAP BW7.31 for a Leading Malaysian Oil and Gas Company

Our client is currently using SAP BW7.01 system for wide Management and Operational Reporting. They proposed us to upgrade the current system to fully enable themselves to use all features available in new release SAP BW7.31. Parallel Running and Synchronization is recommended to work into the upgrade without taking care of the ongoing parallel projects.

Instead of freezing the current system all the objects in BW7.01 production system are migrated into another sandbox system. All ongoing developments are happened in current BW7.01 system till the upgraded system is ready to use and stable. If the current system is freezing up, ongoing developments are affected until the system is upgraded. In the sandbox system first we are upgrading all technical upgrades to new version BW7.31 and then function upgrades are done. The intensive testing is being done on the upgraded sand box system. This testing is especially to check system performance, data consistency and stability after upgrade.

After successful testing, the selective transports is moved to upgraded production system from the upgraded sandbox system. All adjustments of transport and development are done in the upgraded production system. Upgrading changes the system SIDs and hardware names and it impacts all the Universes. The massive universe connections are changed programmatically based on SAP BW.

All the crystal reports are based on BW publisher service, so after upgrading SAP BW system BW publisher service is reconfigured. Also BW logical system and related RFC connections are updated. Unnecessary objects (PSA, DSO change log, unused aggregates) are deleted and cube requests are compressed to minimize DB size before executing DB shrink.

BW-Case-study-Graphic

Flow of SAP BW Upgrade

Optimize – BW are optimized and House kept for upgrade preparation.

Migrate – System copy each of the BW system to the Upgrade landscape.

Upgrade – Upgrade to BW7.31 is happening in upgrade landscape while BW7.01 being business as usual.

Test – Upgraded system is tested with defined test scenario.

Cutover – Systems were synched and aligned with each other till technically synched.