Dear BW enthusiasts,
did you know there is a useful versioning feature in SAP BW since a long time? Here I would like to provide some key facts to understand, setup and use this feature.
First of all, the default customizing can be found the general customizing of your system (Tr. SPRO). There in the settings for Data Modeling (BW/4HANA) or within the General Settings (NetWeaver BW) you will find the option Create historical TLOGO versions automatically. This function maintains the customizing table RSTLOGOHISTCUST.
The initial customizing consists of only two records. These have following meaning:
- Automatic version creation before export and after import for all (*) transportable BW object types (TLOGOs).
- Any definition for a specific TLOGO overrules the first (*)-record:
So for BW Queries (ELEM) this versioning is completely switched off by the second customizing record.
If you would like to create versions also during each activation for some TLOGOs, additional entries are required: In the example above (see “Customer enhancement”), versioning for object activation has been switched on additionally for ADSOs, InfoObjects, CompositeProviders and Transformations as well.
Since mid of 2017, history versioning is also available in the BW Modeling Tools in a separate view called “History” for both BW 7.5 on HANA and BW/4HANA. There you see the full TLOGO history. Starting from the early 2020 releases, you can compare different versions or revert to older ones for ADSOs, CompositeProviders or InfoObjects in the BW Modeling Tools as well.
If the History view is not available by default, you can open it via menu Window/Show View > Other … in the group called Version Control (Team).
From administration point of view there are two points to consider:
- There is a dedicated authorization object S_RS_HIST to control what each user is allowed to do with the historical versions.
- The versions are captured in the backend table RSOTLOGOHISTORY including timestamp, transport ID and User ID. This table can reach significant size depending on how the concept is used. For housekeeping purposes SAP provides report RSDG_DELETE_TLOGO_HISTORY.
Related SAP notes
- 2886009 – CompositeProvider: History version can not be opened in editor (endless loop)
- 2760770 – Revert (retrieve, restore) historical versions of BW objects
- 2637109 – Wrong timestamp displayed for active version in history view
- 2426069 – OutOfMemoryError in BWMT
- 2416068 – Support for historical versions for BW-MT objects (HCPR, IOBJ, ADSO, etc)
- 2248171 – RSOTLOGOHISTORY Cleanup Report