Steps to copy queries from one cube to other

Log into BW system and enter the code RSZC.

Enter the source and target infocubes in the screen as shown below and click OK

This screen allows to move even the structures, KFs as shown in select component section .List of queries will be displayed only if the structure of  both the infoproviders are same else it will give a pop up message saying unable to

Select the queries u want to move to the target cube and click on transfer selections button at the bottom of the screen.This new screen will pop up to allow you to rename the technical name of the query or variable. Change the names and the click on check mark.The queries will be moved to the cube and successful message is displayed as shown below.