Transport Sequence in SAP BI/BW

Transporting objects in SAP BW is not same like in other SAP or non-SAP systems, handling transportation in SAP BW is some what different. Here below listed all the BW objects in sequence to follow while transporting with in the landscape.

1. R/3 - R/3 objects must be transported first before BW transports cab begin

2. Development Class - for backend objects

3. Developer Security Roles - End user roles for projects can be transported later

4. Application Component - including InfoAreas

5. Custom Tablespace /  Custom Data Class - DBA creates custom tablespaces and Basis data class entries must be transported

6. InfoObject & InfoObject Catalogs - only object definition, no  InfoSource or Rules

7. DataSources - replicate DataSources prior to importing objects listed below

8. InfoSources - master data and text

9. Data Targets for Transactional data - InfoCubes and ODSs (this can be grouped with the two following items

10. InfoSource - Transaction Data ODS - includes Update Rules, Communication Structure, Transfer Rules, Transfer Structures, InfoPackages

11. InfoSource - Transaction Data InfoCubes - includes Update Rules, Communication Structure, Transfer Rules, Transfer Structures, InfoPackages

12. MultiCubes 

13. Development Class - for frontend objects

14. InfoSet Queries 

15. End user security roles 

16. Variables Customer Exit code 

17. Workbooks / Queries/ Structures / Calculated Key Figure / Restricted Key Figure

18. Workbook Folders - needs to be transported whenever new workbooks are created

19. Jump Targets 

20. Process Chains