Copy Structure from one cube to another

[Former Member]

I need to copy a structure from one cube to another. I cannot use RSZC b/c the source has some custom fields that the target does not contain. The structure itself does not contain any custom fields.

[Former Member]

Robin,

Did your Problem solved....

Sridhar.

[Former Member]

I am trying to copy a BEx query structure from one query in a cube to a completely different query in a different cube. Is that possible? I can't copy the query from cube to cube because there are custom fields in one that are not in the other.

[Former Member]

Create a Multiprovider that is similar to the cube that contians ur query.

Copy ur query to the Multiprovider.

Drop or add fields to the Multiprovider so as to make it similar to the new Cube to which u want transfer.

Copy ur query from Multiprovider to new cube.

Delete Multiprovder & query.

hope this helps

Raj

[Former Member]

Hello,

Please follow the following steps

1. Check Function Module RSZ_I_COPY_QRY_TO_CUBE_POPUP exists in your system

2. Find IF l_subrc <> 0 OR l_is_compliant = rs_c_false in the main program

3. Place a break point in the code and then Execute Function Module RSZ_I_COPY_QRY_TO_CUBE_POPUP

4. Change the value of l_is_compliant = ‘X’ in the debug mode.

5. Select the Query you want to Copy, the Query will be copied with the structure

6. Open the target Cube and assign a technical name to the Structure.

Hope this helps…

Sridhar.

[Former Member]

RSZC is for copying queries between cubes. if u want to copy the structure of say cube1, create a new cube named cube2 and in the creation page click the button copy from and give cube1. copy from copies the structure only. if u want the same data as of cube1 in cube2 u need to do an export datasource on cube1.

[Former Member]

Hi

I just want to add a point that maybe helps some. The line IF "l_subrc <> 0 OR l_is_compliant = rs_c_false." is found in the FM RSZ_I_COPY_QRY_TO_CUBE not in RSZ_I_COPY_QRY_TO_CUBE_POPUP in BW 3.5 Patch 19. And it seams to work fine.

So thanks for your help again.