Monday, April 16, 2012

BI Objects Version Management


BI objects Versions.

Often we find it difficult to find out what is the version we have  in different systems across Landscape. Also this  becomes difficult when we have more business rules in Transformation and some complicated ABAP code for Start and End routines. Generally we do get some answers by comparing generated Transformation ABAP  Program across systems. The issue has been resolved in new Bi 7.3 version and steps are as follows. 
To get info about version your objects should have D version and has to be transportable means the objects needs to be associated with Development package..
The A version and M version are only temporary versions. They are not saved permanently in the database. The manual versions provide a time-point-specific picture of an object status and are therefore historical versions.
Historical Version can be automated by Customizing by following path
In Customizing for Business Warehouse under   SAP NetWeaver  Business Warehouse  General Settings  Generate Historical TLOGO Versions Automatically .
Steps to get Version Info.
  1. You are in object maintenance. Choose   Goto  Version Management  . Alternatively, you can also access the version management from the collection view of the Data Warehousing Workbench transport connection, by using the object's context menu.
  2. The table displays the existing versions. Create a manual version by choosing http://help.sap.com/saphelp_nw73/helpdata/en/58/cb165007914e5ca2a0734ac628a95d/ppt_img.gifCreate New Version. This version is saved directly to the database.
  3. Choose http://help.sap.com/saphelp_nw73/helpdata/en/d3/64ddb4b8a84d9e9225f26884f242d3/ppt_img.gifRead Again to update the display of the version, if other users have made changes in the meantime.
  4. Choose Restore from Version to restore an older version. You can reset the changes to the object in the version management.
  5. You can export a version as a file by choosing Export from the context menu of the relevant version. The file can also be imported. In the version context menu, choose Import.
  6. There are two ways of dislaying the details of a version:
    • You can display the details in a tree-like structure.
    • You can view the details as an XML file.
  7. You can compare two historical versions (including the temporary versions). Select the required rows in the overview and choose http://help.sap.com/saphelp_nw73/helpdata/en/db/2abc2d371345ee83f2d7e6f2302f7f/ppt_img.gifCompare Versions.
Now how about older versions. This is not a straight forward method but possible to get from standard views created by SAP from Transport copies.
The view for this is V_E071. This table gives all the changes done to the object part of your Data Flow. The thing here is you need to give individual technical names to find out the versions under object name selection. You can also drive the result of this table  by date/developer/object Type like CUBE/ODSO/TRFN etc.











See the result for a DSO and status is R here means it is released and other status could be D means it is being modified.

 

 Status with D

 



No comments:

Post a Comment