Custom Program Enables You to Transport Query Variants Between Two Systems

  • by Pranab Parhi, Senior Associate SAP BI and Planning, Bluefin Solutions, UK
  • February 26, 2010
Find out how to create a custom program and use it to transport multiple SAP NetWeaver BW query variants from one system to another. This process can also apply to transporting variants used with Analysis Process Designer.
Key Concept
If you use SAP NetWeaver BW for reporting, you save your most frequent filters/selections as query variants, in which you save the variable values. In addition, you also use variants when you create an analysis process with Analysis Process Designer in SAP NetWeaver BW.

Say you use variants to execute a query in BEx Analyzer or SAP NetWeaver Portal. Or perhaps you create a variant in transaction RSRT for Analysis Process Designer (APD). Although the queries themselves are transportable, the variants used in them are not. No standard SAP process is available to transport the variants, so you have to create them manually in each destination system. This can be a source of system bottleneck, especially when you have a multiple analysis processes.

I will outline a method that helps you to transport your variants from one SAP NetWeaver BW system to another. This method involves finding the standard SAP tables updated while creating variants, 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 BW 3.x and SAP NetWeaver BW 7.x. Users need standard authorization to execute programs as well as to upload and download files from the desktop.

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.