Skip to Content

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.


SE38.jpg

And write your Code in the ABAP editor.

SE38-1.jpg

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 text001 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.


SE38-2.jpg


Above program will help you to activate the BW Objects directly in Production system without performing the transports.


Related content:


https://scn.sap.com/

https://help.sap.com/

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Ankit Chaudhary

    Great stuff.. Never thought it would be so much easy to implement. Thanks for sharing it.
    Looking forward for some more helpful posts from you.

    (0) 

Leave a Reply