Custom Program Enables You to Transport Query Variants Between Two Systems

by Pranab Parhi, Senior SAP NetWeaver BW and Planning Consultant, Bluefin Solutions UK (February 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.

Categories: BI/BW, ETL

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.

Would you like to see the full version of this article?

If you are an electronic license holder to BI Expert, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the BI Expert online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
BI Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.