Creating a Copy of BW 

Use

Apart from

all BW tables (BW Metadata) are cross-client. For this reason there is no point in refreshing a BW with a client copy.

Procedure

There are three different scenarios:

  1. You want to install a new BW (here a "Target BW") with a copy of an existing BW (here an "Original BW"), meaning you import the copy into an ‘empty’ computer.
  2. You want to replace an existing BW (here "Old BW") by copying another BW (here "Original BW"), meaning that BW (Old BW) has already been installed on the target computer. Here, the copy of the original BW is called "Target BW".
    1. You have not yet made the copy.
    2. You have already overwritten the old BW with the copy of the original BW.

Where possible, case a) is always preferable to case b), because with case b) information has already been lost.

Scenario 1

  1. In the Administrator Workbench for the original BW, select Goto ® Transport connection and collect all source system-dependent objects for the object type source system together in a transport request. In this way you are supported by Grouping backup for system copy. The source system-dependent objects include the object types ISMP, ISIP and ISTS.

    2. The object ISTS requires, among other things, routines that are also automatically transported as user objects.

  2. Export the request.
  3. Replace the BW system with the copy.
  4. In the target BW, select Tools ® Administration ® Management ® Network ® RFC Destinations and delete all RFC connections to the R/3 and data mart source systems.
  5. Delete all source systems in the source system tree of the Administrator Workbench - Modeling for the target BW.

    6. As you have already deleted the RFC connections, you get a message saying that the source systems are not accessible. Select Ignore to delete the source systems.

  6. In the target BW Customizing Implementation Guide, select Business Information Warehouse ® Connections to Other Systems ® General Connection Settings ® Name Logical System and give the BW a new logical name. Then, also under General Connection Settings, assign the logical system to a client.
  7. In the source system tree of the target BW Administrator Workbench - Modeling, once again connect the original source system or whichever source system you want. You can find information on connecting source systems under: Creating R/3 Source Systems, Creating External Systems, Creating File Systems.
  8. Import the request that was created previously in the original BW.

You have ensured that all source system-dependent objects remain intact when the BW copy is made.

Scenario 2.a

  1. In the Administrator Workbench for the old BW, select Goto ® Transport Connection and collect all source system-dependent objects for the object type source system together in one transport request. For this you are supported by Grouping backup for system copy. The source system-dependent objects include the object types ISMP, ISIP and ISTS.

    2. The object ISTS requires, among other things, routines that are also automatically transported as user objects.

  2. Export the request.
  3. In the old BW, delete all R/3 source systems and data mart source systems in the source system tree of the Administrator Workbench - Modeling.
  4. Replace the BW system with the copy.
  5. In the target BW, select Tools ® Administration ® Management ® Network ® RFC Destinations and delete all RFC connections to the R/3 and data mart source systems.
  6. Delete all source systems in the source system tree of the Administrator Workbench - Modeling for the target BW.

    7. As you have already deleted the RFC connections, you get a message saying that the source systems are not accessible. Choose Ignore to delete the source systems.

  7. In the Customizing Implementation Guide of the target BW, choose Business Information Warehouse ® Connections to Other Systems ® General Connection Settings ® Name Logical System and give the target BW the same name as the old BW. Then, also under General Connection Settings, assign the logical system to a client.
  8. In the source system tree of the Administrator Workbench - Modeling of the target BW, reconnect the source systems that were connected to the old BW. You can find information on connecting source systems under: Creating R/3 Source Systems, Creating External Systems, Creating File Systems.
  9. Import the request that was previously created in the original BW.

You have ensured that all source system-dependent objects remain intact when the BW copy is made.

Scenario 2.b

  1. You have replaced the BW system with the copy.
  2. In the target BW, choose Tools ® Administration ® Management ® Network ® RFC Destinations and delete all RFC connections to the R/3 and data mart source systems.
  3. Delete all source systems in the source system tree of the Administrator Workbench - Modeling of the target BW.

    4. As you have already deleted the RFC connections, you get a message saying that the source systems are not accessible. Choose Ignore to delete the source systems.

  4. In the source systems for the old BW, delete the connection to BW.

    5. Using Tools ® ABAP Workbench ® Development ® Function Builder call up the function module RSA_BIW_DISCONNECT in the single test.

    Enter the name of the system pair in which you fill the parameter I_BIW_LOGSYS with the logical name of the BW and the parameter I_OLTP_LOGSYS with the logical name of the source system. Do not fill the parameter I_FORCE_DELETE.

    The system connection is deleted.

  5. In the Customizing Implementation Guide of the target BW, choose Business Information Warehouse ® Connections to Other Systems ® General Connection Settings ® Name Logical System and give the target BW the same name as the old BW. Then, also under General Connection Settings, assign the logical system to a client.
  6. In the source system tree of the Administrator Workbench - Modeling of the target BW, reconnect the source systems that were connected to the old BW. You can find information on connecting source systems under: Creating R/3 Source Systems, Creating External Systems, Creating File Systems.
  7. In the BW Administrator Workbench, recreate the transfer structures and transfer rules and activate them.

Result

The copied BW system is ready for transferring data from the connected source systems.