InfoCube splitting

Hello together,

I have an InfoCube with all our COPA Data. Now I would like to split the InfoCube in three cubes.

- One cube (COPA_C1) for the current and future data (e.g. 2011 and 2010)

- One cube (COPA_L1) for the last year (e.g. 2009)

- One cube (COPA_A1) for all the other years in the past (e.g. 2008/2007/ and so on.). In this cube I want to store the data only in an aggregated form.

Unfortunately I have no idea how I get such automatic data separation. Is there maybe a SAP function, which I can use?

Thirst I thought I can use a transformation with a data transfer process between the InfoCubes. But then the data exists in the old cube (e.g. COPA_L1) and in the new cube (e.g. COPA_L1) - And I couldnu2019t find a way to delete the old datau2026

Regards,

Alex