Custom Program Enables You to Transport IP Lock Characteristics Settings Between Two Systems

  • by Pranab Parhi, Senior Associate SAP BI and Planning, Bluefin Solutions, UK
  • April 7, 2011
Find out how to create a custom program and use it to transport SAP NetWeaver BW integrated planning (IP) lock characteristics from one system to another. This process helps you avoid manually creating the lock characteristics in multiple systems. Sample code is included.
Key Concept
If you use SAP NetWeaver BW integrated planning (IP) as your planning tool, you need to customize your lock characteristics to avoid concurrent users locking each other using the same application.

If you have an SAP NetWeaver BW integrated planning (IP) planning application, multiple users should be able to use it at the same time. To allow concurrent users in IP, the system defines all the characteristics of the transactional InfoCube as the lock characteristics. This considerably slows down the planning application because of the extended lock arguments. To avoid this and make things quicker, you have the option to customize the InfoCube with a few selected few characteristics such as lock characteristics using transaction RSPLSE. Otherwise you need to maintain these lock characteristics settings manually in all the systems.

My method will help you to transport your IP transactional InfoCube lock characteristics settings from one SAP NetWeaver BW system to another. This method involves finding the standard SAP table that is updated while creating lock characteristics, downloading these tables from the source system to a local desktop file with the correct format, and uploading them to the target system. You can use this method with SAP NetWeaver BW 7.x. Users need standard authorization to execute programs as well as to upload and download files from the desktop.

Create the Custom Application

The first step is to create the application ZBW_IP_LOCK_CHARS_TRANSPORT in your SAP NetWeaver BW system. I provide the code for this program in the Downloads section at the bottom of this article. This a global program that you can use across all your SAP NetWeaver BW systems. If you have SAPLINK already installed in your SAP NetWeaver BW system, you can upload the nugget file NUGG_ZBW_IP_LOCK_CHARS_TRANSPORT.nugg, which is also attached at the end of the article, to create the proposed application. After you have created the program, follow the process from step 4 to transport the program to all the destination systems and use it.

Pranab Parhi

Pranab Parhi is a senior SAP NetWeaver BW and planning consultant who has been involved with multiple full-life cycle SAP NetWeaver BW reporting and planning implementations. He has 10 years of SAP consulting experience in various industries, including pharmaceutical, oil, public sector, aviation, consumer packaged goods, services, and retail in multinational environments. He is currently working as a senior associate for Bluefin Solutions. Pranab is an SAP-certified SAP NetWeaver BW 7.0 and SAP NetWeaver BW 3.5 consultant with six years of BI experience. In addition, he is an SAP-certified ABAP consultant with more than four years of ABAP experience. He also holds a bachelor’s degree in engineering (computer science).

If you have comments about this article or BI Expert, or would like to submit an article idea, please contact the BI Expert editor.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.