Applies to:
SAP NetWeaver Business Warehouse (formerly BI) - SAP BW 3.5 & 7.x. Versions.
Summary:
The article explains how to create an SAP ABAP Program to activate all BW Objects in SAP BW Production System.
Table of Contents:
1. Introduction
2. Test Scenario for creating an ABAP Program to Activate the BW Objects in Production System
3. Describing the Test Scenario
4. Related content
Introduction:
In many BW Projects, we have seen that most of the time we need to activate the SAP BW objects like Cube, MultiCube, DataSource, Transformation and etc… objects in the Production environment. Hence creating a Program/Activator tool, which will activate the following BW objects in the Production/Quality systems without transporting the objects again from Development system.
Update Rules
DataSources
Transfer Structure
Communication Structure
InfoCubes
MultiProviders
DSO Objects
InfoObjects
Activate the Transformation
Activate the DTP
Details of InfoCube Design
Convert the Full Request to Repair Request
Test Scenario:
Below is the program created to activate the all BW objects.
Go To: SE38 and create a program, give name, description etc details.
And write your Code in the ABAP editor.
Below is the Code written in the ABAP editor.
*******************************************************************************************
*&---------------------------------------------------------------------*
*& Report ZACTIVATE_OBJECTS_TOOL
*&---------------------------------------------------------------------*
REPORT ZACTIVATE_OBJECTS_TOOL.
*& It can be used to Activate the following objects:
*& 1. Update Rules
*& 2. DataSources
*& 3. Transfer Structure
*& 4. Communication Structure
*& 5. InfoCubes
*& 6. MultiProviders
*& 7. DSO Objects
*& 8. InfoObjects
*& 9. Activate the Transformation
*& 10. Activate the DTP
*& 11. Details of InfoCube Design
*& 12. Convert the Full Request to Repair Request
*& Creation date : 07/29/2015.
*&*************************************************************************************&*
* SELECTION SCREEN.
*&*************************************************************************************&*
SELECTION-SCREEN BEGIN OF BLOCK FRAME WITH FRAME TITLE text-001 NO INTERVALS .
PARAMETER p_update TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_dataso TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_commst TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_tran TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_cube TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_Multi TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_DSO TYPE C RADIOBUTTON GROUP RG1.
PARAMETER P_IOBJ TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_repair TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_icubed TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_trans TYPE C RADIOBUTTON GROUP RG1.
PARAMETER p_dtp TYPE C RADIOBUTTON GROUP RG1.
SELECTION-SCREEN END OF BLOCK FRAME.
*&*************************************************************************************&*
* ACTIVATE UPDATE RULE
*&*************************************************************************************&*
if p_update = 'X'.
SUBMIT RSAU_UPDR_REACTIVATE_ALL VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE DATASOURCE
*&*************************************************************************************&*
ELSEif p_dataso = 'X'.
SUBMIT RSDS_DATASOURCE_ACTIVATE_ALL VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE COMMUNICATION STRUCTURE
*&*************************************************************************************&*
ELSEIF p_commst = 'X'.
SUBMIT RS_COMSTRU_ACTIVATE_ALL VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE TRANSFER STRUCRTURE
*&*************************************************************************************&*
ELSEIF p_tran = 'X'.
SUBMIT RS_TRANSTRU_ACTIVATE_ALL VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE INFOCUBES
*&*************************************************************************************&*
ELSEIF p_cube = 'X'.
SUBMIT RSDG_CUBE_ACTIVATE VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE MULTIPROVIDERS
*&*************************************************************************************&*
ELSEIF p_Multi = 'X'.
SUBMIT RSDG_MPRO_ACTIVATE VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE DSO's OBJECTS
*&*************************************************************************************&*
ELSEIF p_DSO = 'X'.
SUBMIT RSDG_ODSO_ACTIVATE VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* ACTIVATE INFOOBJECTS
*&*************************************************************************************&*
ELSEIF P_IOBJ = 'X'.
SUBMIT RSDG_IOBJ_ACTIVATE VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* CONVERT FULL REQUEST TO REPAIR FULL REQUESTS
*&*************************************************************************************&*
ELSEIF p_repair = 'X'.
SUBMIT RSSM_SET_REPAIR_FULL_FLAG VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* Details of InfoCube Design
*&*************************************************************************************&*
ELSEIF p_icubed = 'X'.
SUBMIT SAP_INFOCUBE_DESIGNS VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* Activate the Transformation
*&*************************************************************************************&*
ELSEIF p_trans = 'X'.
SUBMIT RSDG_TRFN_ACTIVATE VIA SELECTION-SCREEN AND RETURN.
*&*************************************************************************************&*
* Activate the DTP
*&*************************************************************************************&*
ELSEIF p_dtp = 'X'.
SUBMIT RSBKDTPREPAIR VIA SELECTION-SCREEN AND RETURN.
ENDIF.
****************************************************************************************
Save & Activate the program.
Then Execute (F8) the program and select the option/object which you want to activate.
Above program will help you to activate the BW Objects directly in Production system without performing the transports.
Related content:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |