BW- Utilities by ABAP code- Part 1

[Former Member]

Author(s): Anil Kumar Puranam and Peesu Sudhakar

Company: Deloitte

Created on: 24th December, 2014

Authors Bio:

Sudhakar Reddy Peesu is an SAP Technology professional with more than 15 years of experience leading SAP BW/ABAP implementations, developing custom applications, and developing IT strategy. He is a PMP certified manager, has led BW/ABAP teams with hardware and landscape planning, design, installation and support, and development teams through all phases of the SDLC using the onsite/offshore delivery model.  He has strong communication, project management, and organization skills.  His industry project experience includes Banking, Consumer/Products, and Public Sector industries

Anil Kumar. Puranam is working as a Senior BW/BI Developer in Deloitte consulting. He has more than 10 years of SAP BW/BI/BO experience. He has worked on various support/implementation projects while working in consulting companies like Deloitte, IBM India, and TCS

As part of Business wareshouse system development, we always look for easy and fast way to complete our day to day activities and different phases of the development and production support. Here are few Utility programs that we can use to make our job easy.

• • 
    How to find out the list of Inactive objects of imporatant Categories:
    
  
  
  • 
    Mass activation of DTPs:
    
  
  
  • 
    Selection changes for Mass DTPs:
    
  
  
  • 
    Mass activation of Trasnsformations:
    
  
  
  • 
    List of hieararchy usuages:
    
  
  

How to find out the list of Inactive objects of imporatant Categories:

                    We need to cross check the inactive components in the system, whenever we do system level changes. Few of the instances have been given below, where we need to check the inactive objects and made them active.

• System copy from one environment to other.
• Support patch or upgrade.
• If changing the object leading to have impact on numerous objects.

                  It is time consuming task to check them one by one to find out the list. We can use below program to get the list of objects for important types of object categories. The selection screen of the program execution is given below. As it is shown, we can get complete list of selected category.

Program: ZINACTIVE_OBJECTS_LIST. Code is attached to the document.

Mass activation of DTPs:

            It is often that we create number of DTPS for the same target or multiple targets from one source or multiple targets. And we need to activate all of them if we modify any Transformations, and it become time taking task sometimes if we have numerous number of DTPs. This is more often in case of Semantic partition Objects. We can leverage the below program to activate all of them at a time.  If we are trying to activate the DTPS which were transported to other systems, we need to collect the DTPS first into a TR, to avoid the selecting the Transport request for each DTP while activating the DTPS. We can add them manually to a TR and we need to lock them.

Here is a Custom program we can use to activate the DTP. The selection screen is given below.
Here we have option to do modification of the mass DTPs filter too. In this example we have given option to modify the Calendar. We can modify the program if we need to go with different selection for the DTP.

Program : ZMASSACTIVATE_DTP. Code is attached to the document.

Selection changes for Mass DTPs:

  It is very often that we create Homogeneous info providers and SPO with Multiple partitions. In such cases we can see that there is a need to create numerous number of the DTPS with selection on same characteristics. We can use the below program if we need to modify the number of DTPS at a same time with different selection values. In this program we can specify the field name also to which we need to alter the filter selection value.

Here is a Custom program we can use to activate the DTP. The selection screen is given below. Here we have option to do modification of the mass DTPs filter here along with filter value.

Program : ZMASSACTIVATE_DTP. Code is attached to the document.

Mass activation of Trasnsformations:

Here is a Custom program we can use to activate the mass Transformations . The selection screen is given below.

Program : ZMASSACTIVATE_TRANSFORMATION. Code is attached to the document.

List of hieararchy usuages:

  We often hard code the Hierarchies in the Query as per the Business requirements. But this will be leading to be a problematic issue if we need to alter the Hierarchy structure or discard the hierarchy.  In such situations, we can use the below program to get the list of Queries where we have used the specific Hierarchy. In the selection screen we need to enter the Info object and it’s hierarchy which we would like to check.

Program : ZMASSACTIVATE_TRANSFORMATION. Code is attached to the document. In the output we can see the Info provider on which the query is build and the Query Technical name in which we have used the concern Hierarchy.