Copy data between productive and test system

[Former Member]

Hi everybody,

I need to copy data from one cube in productive system into the same cube in the test system.

How can I do it?

Regards

Erwin

[Former Member]

If you need to copy data from one system to another maybe you can do a Data Refresh or a SAP_DATA System Copy.

If you wan't only to copy data from 1 Cube to another in other system you shoul'd try transforming the data on the Cube to a Report or maybe an ODS and then dowload it to a CVS archive, and then make a Transformation From PC_FILE to ODS and Cube o from PC_FILE to Cube.

Hope it's work.

Grettings.

Ignacio.

[Former Member]

If data in the cube is less , you can dowload the same in a CSV file in production system and then create a flat file data source and transformation from flat file datasource to the cube in the Q system and load the data through the flat file datasource.

[Former Member]

Hi Erwin,

I think you need to have the connection established between P and Q in order to replicate the P's generated data source in Q environment and then create transformations from 8* to the Q's cube