Copying data from one cube to another cube

[Shwetha]

Hi,

I want to copy data from one cube to another cube using TI process. Both cubes have same number of dimensions and similar dimensions.

Please someone suggest me regarding this:)

Thanks,
Shwetha

[BariAbdul]

Sounds familiar,Please have a look at the below post:
http://www.tm1forum.com/viewtopic.php?f=3&t=9587

[mattgoff]

Hi Shwetha,

Welcome to TM1 Forum. Sounds like you're new to TM1, and that's OK-- we all were once! First, it's a good idea if you read the Request for Assistance Guidelines (particularly #6). Second, I strongly recommend that you start with at least one formal training class on TM1 administration and TI. The question you're asking is the Excel equivalent to "how do I sum two cells." I'm a big believer in self learning, but taking a class will give you the foundation you need to learn the rest on your own (with the help of the forum).

Matt

[macsir]

If the cubes are across servers, you could use TI to export csv file and import it to another server.

[EvgenyT]

If the cubes are across servers, you could use TI to export csv file and import it to another server.

or if its on the same server, then you can use TI process to create cube view as a datasource...and then use it to import to another cube.

Look at View / Subset manipulation functions..


ET

[winsonlee]

If you are doing this once off, then just save the view with the data you would like to copy across, create a TI using Cube View as the data source and use a cellputn command in the data tab to paste the data in the destination cube.

If this has to happen regularly, then consider creating view using TI process in the prolog so that the view is dynamic and also consider clearing the existing data in the destination you would like to copy if required.