Skip to Content
0
Former Member
Jun 07, 2008 at 12:17 AM

Copy cube

23 Views

Hello guys.

I need your help in telling me what is the best way to make a copy of a cube that has 10 million registers.

I'm in Oracle database, so I need to take care of table spaces also.

But I need to know how can I archive the load of data from the original cube to the copy cube in a successfull way.

Do I have to load all data in once, or in infopackage making filtering selections by 4 or 5 months ??'

the problem of filtering in the DTP is that is creatting me partitions in the fact table of the copy cube, and the loads take a long of time to finish (aprox. 4 hours, for a set of 360,000 registers). How can I improve the performance of loads. ???

THANKS IN ADVANCE.