SAP BW Version Management: A Nifty Feature of SAP BW Objects

  • by Ned Falk, Senior Education Consultant, SAP
  • February 9, 2015
Learn the steps needed to leverage the Version Management feature of SAP BW objects. Using Version Management, a little-known SAP BW option, you can automatically or manually create different versions of SAP BW objects and perform version comparisons and version recovery. This allows you to restore an object to a prior state.
Learning Objectives

Reading this article, you will learn how to:

  • Configure the system to automatically create different versions of SAP BW objects
  • Import and export versions of SAP BW objects
  • Manually create different versions of SAP BW objects (for example, InfoProviders, data transfer processes, and transformations)
  • Compare the content of different versions of the same object
  • Restore prior versions of  SAP BW objects
Key Concept

In the past, versioning for objects in SAP BW was very limited. Now, in SAP BW 7.3 and onward, versioning is a new full-featured, helpful offering.

A little-known SAP BW feature, Version Management of SAP BW objects, allows you to recover prior versions of BW Objects, like InfoProviders, data transfer processes (DTPs), and other objects.

Prior to version SAP BW 7.3, after you activated an SAP BW object you could not return to the previous settings of the object. The only exception was if the object was delivered by SAP. In this case, you could recover back to the SAP system’s original version, but not to an interim version created by you. As of the release of SAP BW 7.3, this is no longer the case. You now have the option to manage versions of SAP BW objects.

Starting in SAP BW release 7.3, you have a fully functioning version management system for SAP BW objects. These include basically all important objects such as InfoCubes and other InfoProviders, DTPs, and transformations. With Version Management, you can save any iteration of an object’s settings, including, for example, the mappings in a transformation or the InfoObjects contained in an InfoCube. After you have a saved version you can compare, import, export, delete, and, most importantly, restore the older version.

In this article I use an InfoCube as the example object, but it works the same way with other objects. The configuration involved references CUBE, which is a reference to an SAP BW InfoCube.

I show the following SAP BW configuration steps for automatically creating historical versions of BW objects:

1. Review the starting point of an InfoCube that has an active and revised version (where the revised version is the same as the active version).

2. Show automatically created versions:

  • Upon activation
  • During transport

3. Make a small change and save this version of the object without activating.

4. Export an historical version to your PC and import a version from your PC back to the version database.

5. Compare a prior historical version (one that worked the way you want it to) to the currently active version.

6. Restore the historical version as the current revised version and then activate this revised version to fully restore the historical version to the active version.

Ned Falk

Ned Falk is a senior education consultant at SAP. In prior positions, he implemented many ERP solutions, including SAP R/3. While at SAP, he initially focused on logistics. Now he focuses on SAP HANA, SAP BW (formerly SAP NetWeaver BW), SAP CRM, and the integration of SAP BW and SAP BusinessObjects tools. You can meet him in person when he teaches SAP HANA, SAP BW, or SAP CRM classes from the Atlanta SAP office, or in a virtual training class over the web. If you need an SAP education plan for SAP HANA, SAP BW, BusinessObjects, or SAP CRM, you may contact Ned via email.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.