How to copy the data in a cube to another cube

[Former Member]

Hi ,I created one cube by copying.Now I want the data available in earlier cube to Copied Cube.Plz can any one help in this.

Thanx in Advacnce

Vasu

[Former Member · Accepted solution]

Hi Vasu,

1.You can create an export datasource on the first cube.

2.For the 2nd cube create the update rules using the 8<Cube1> Infsource.

3.Create infopackage and load the 2nd cube.

Bye

Dinesh

[Former Member]

Hi Vasu,

Have you created the update rule based on the Info-source 8<Cube 1>, only then you would get the Data target in the specific tab of the infoapckage.

Bye

Dinesh

[Former Member]

You can use the export datasource option to copy the data.

Another option is:

The steps for copying the contents of one cube to another:

1. Go to Manage -> Recontruct of the new cube.

2. Select the "selection button"(red , yellow, blue diamond button).

3.In the selection screen you can give the technical name of the old cube, requests ids you want to load, from & to date.

4.Execute and the new cube would be loaded.

Its all that easy!!!!!!

Refer this link:

[Former Member]

Thanx AHP.IAs per the steps given by I executed But When I tried to create Infopackage in Data target Tab I am not getting my data target.I created update rules and they are active.

Could hlep me.

Vasu

[edwin_harpino]

hi Vasu,

say you have cube1 copy to cube2,

if it's updated from ods, you can create update rules for cube2 and update from ods

or you can try datamart scenario

- cube1 right click 'generate export datasource'

- create update rules for cube2, assign with cube1

- rsa1->source system->bw myself, right click 'replicate datasource'

- rsa1-> infosource -> search 8[cube1 name]

(if not get, try right click root note 'infosource'->insert lost node(s)

- from that infosource, you will find assigned with datasource, right click and 'create infopackage', schedule and run.

hope this helps.