How to copy Queries From one InfoCube to Another InfoCube

Enter the T-Code RSZC

Enter the Source InfoCube and Target InfoCube

Select Queries

Then Click Execute


In the next Screen select Query name and Click Transfer Selections



Next screen Give the new name for the copied Query

Click Continue

Then the Pop up Screen shows the Query with Technical name Created Successfully.

Then Click Continue.

How to Restore the Modified Transformation to Active Version of a Transformation

I have made some changes in the Active Transformation and saved it with out activating the transformation.


Now i don't want the changes and i have to restore it to the active version.


Open the transformation in Edit mode

Go to Menu -> Edit -> Return to Active Version