Activation of Inactive Objects in Production

Sometimes there may be a case that in spite of successful migration of a BW object via transport, the object
continues to remain inactive. There may also be cases where we mistakenly forget to transport a dependent
object and hence the dependent object remains inactive in the Production system.
For such scenarios SAP has helped us by providing programs which activate the objects without the need for
us to transport them from development to production.
Here is a list of programs which can be used to activate the inactive objects in the system:

Below are the steps required to create an Open Hub Destination in BI 7.0

1.  Click on Open Hub Destination from left side panel after executing RSA1.

Riqht click on InfoArea where the Open Hub Destination will reside and select “Create Open Hub Destination”

Fill in the following:

• Open Hub Destination:  Z_IFSFFPT (up to 9 characters only)
• Description:  IFS FFP Interface Test
• Object Type:  DataStore Object

• Name:  ZRV_O904

2.  Click on the Destination Tab.

Select “File” from the drop down box

Select the directory… for testing purposes, save to your desktop

Click on the Application Server Box… notice the Application Server “MVSADBDV1” will be displayed initially as the default application server.

For migration to production, you want to work with Basis to setup a ‘logical file path/name’.  This will ensure that the logical path and logical name can be migrated into all environments without having to specify the server name.

For R8.1 IFS, we are using the newly created Logical File Name “Z_OPENHUB_IFS”

From AL11 in BA8, you can see the Logical File Name “Z_OPENHUB_IFS” directories

3.  Now you are ready to specify the fields for the Open Hub Destination.

Select the Tab “Field Def”.

4.  Now you are ready to create the Transformation (source).

Right click on the saved Open Hub Destination “Z_IFSFFPT”, and select “Create Transformation” from dropdown box.

5.  Select “DataStore Object” from the Object Type drop down box.

Select “ZRV_O904” from the drop down box.

Click on the Green Check Mark to continue.

6.  Now, you can do all of the activities available to a Transformation:

              Create Start Routine

              Create End Routine (see below)

              Create Formulas (see below)

Activate the transformation when completed.

7.  Now, you are ready to create the Data Transfer Process for the Open Hub Destination.

Right click on the Open Hub Destination “Z_IFSFFPT”, and select “Create Data Transfer Process” from the drop down box.

The target and source will be prepopulated, so you may not need to do anything; however, you can also specify the details. 

Click on the Green Check Mark to continue.

8.  From the Extraction Tab:

Select Extraction Mode:  Full

Click on the Radio Button “Active Table (Full Extract Only)

No steps required in the Tab “Update”.

No steps required in the Tab “Execute”.

9.  Finally, click on the Activation Icon.

Steps to copy queries from one cube to other

Log into BW system and enter the code RSZC.

Enter the source and target infocubes in the screen as shown below and click OK

This screen allows to move even the structures, KFs as shown in select component section .List of queries will be displayed only if the structure of  both the infoproviders are same else it will give a pop up message saying unable to

Select the queries u want to move to the target cube and click on transfer selections button at the bottom of the screen.This new screen will pop up to allow you to rename the technical name of the query or variable. Change the names and the click on check mark.The queries will be moved to the cube and successful message is displayed as shown below.