Copying Queries between InfoCubes

By Debasish BI EXPERT

You can use this function to copy queries and their sub-objects (structures, calculated key figures and restricted key figures) between different InfoCubes.

The target InfoCube, the InfoCube for the query copies, must contain all the InfoObjects of the source InfoCube (InfoCube of the original queries).

Procedure...
1. In the SAP Easy Access Menu of the BI system, choose SAP Menu  Business Explorer  Query  Copy. Double-click on Copy Queries. The Copying Queries between InfoCubes dialog box appears.
2. Select the required source and target InfoCube.
3. Choose Continue. A selection box appears that contains all the queries of the source InfoCube.
4. Select a query from those available.

You have the following options for selecting multiple queries.
• To make several selections from the list, select the required queries with a mouse click and the Ctrl key.
• If you want to select several queries that are next to each other in the list, you can select whole blocks by holding down the Shift key.

5. Choose Transfer Selections.

Note the following if you are working with reusable sub objects such as variables, structures, calculated key figures and restricted key figures:

• Variables are not dependent on InfoCubes so they are not copied.
• If you select more than one query to be copied and these queries reference reusable sub objects that are next to each other in the list, the system only makes one copy of the sub object. The references of the copied queries are retained.
• If you copy queries again at a later time, the system creates new sub objects. The references to queries that have already been copied are lost.

6. Change the technical names of any copied query components in dialog box Rename Components.

7. Choose Continue.
Result:
The copied queries and the copied sub objects have their own names. The new names are derived from the name of the original object and the added element _.

This does not affect variables, since they are not copied.

Example:

The queries weekly report, monthly report and annual report use company code as a variable and the calculated key figure contribution margin. If you copy the queries weekly report and monthly report into another InfoCube, the queries weekly report_1 and monthly report_1 are created along with the calculated key figure contribution margin_1. The new queries refer to the new key figure contribution margin_1 and the variable company code.
If you copy queries quarterly report and annual report, a new calculated key figure, contribution margin_2, has to be created as a copy of contribution margin. Quarterly report_1 and annual report_1 then refer to contribution margin_2 and not contribution margin_1. Company code is still used as a variable.