Skip to Content
Author's profile photo Former Member

How to copy a BEx query with different Cube in SAP BW 7.3+

Do you ponder when


  • Your design advises your solution to copy existing cube (on which many reports/queries are built)for various reasons
  • You need to copy queries on cube to cube or cube to Multiprovider, DSO to InfoSet and so on..       
  • Sometimes you need to copy almost similar queries between two info providers. For this we generally use transaction RSZC, but the transaction won’t allow us to copy the queries because few info objects are missing in the other Info providers.
  • You cannot copy Bex queries/reports, which are, built on the Infosets. So you have to create all the reports again on new Infoset. However in that case new Infoset will create new technical names for Info objects. For example if you have the ZFUND info object into the base Infoset then new copied Info object name will be Z_FUND_1.

I did spend some time to think on those issues and solution and thus decided to write my first white paper on describing my experience and also the resolution for copying queries irrespective of Info providers.

Step-By-Step Solution

1) Go to SE37

2) Type in RSZ_I_COPY_QRY_TO_CUBE_SINGLE


Untitled.jpg

3) Clicked on Display

4) Run the module by pressing F8


Untitled.jpg


How to get I_SOURCE_COMPUID?

a) Go to SE16.

b) RSRREPDIR goes to in this table.

c) Enter the source query name or info provider name to find the COMPUID


Untitled.jpg

d) After executing copy COMPUID from A version column.


Untitled.jpg


5) Enter the Source I_SOURCE_COMPUID, I_SOURCE_INFOCUBE, I_TARGET_INFOCUBE and then click on Execute button.


Untitled.jpg


As you can see the BEx query has been copied successfully on top of your target provider


Untitled.jpg


I am sure this document will help you to perform similar kind of development.

Even though there are couple of few steps, but I do feel privileged by penning down my First White Paper!

Many thanks for your encouragement and reading through this.

Thanks

PM







Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing this possibility.

      Works perfect on 7.31 SP14

      Thomas

      Author's profile photo Former Member
      Former Member

      It is very helpful

      Author's profile photo Siddhartha Anand
      Siddhartha Anand

      Thanks Pramod, congratulations on your white paper. Thanks for sharing.

      Does using the function module solve the issues with copying queries from one InfoSet to another?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks all.

      Siddhartha: we can't copy the queries from infoset.

      Author's profile photo Yahya Kamran
      Yahya Kamran

      Use the RSZC T-code.