InfoCube splitting

[alexander_stettler]

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

[Former Member · Accepted solution]

Hi,

Say your current cube is COPA-1. And you want to have data in cubes as

COPA-1 -> 2010 and onwards

COPA-2 -> 2009

COPA-3- >2008 and before

You already have cube COPA-1, so create rest of the cubes COPA-2 & COPA-3.

Now for the new cubes create Transformations as:

COPA-1 ==> COPA-2

COPA-1 ==> COPA-3

here these two new cubes will have data source as your originla cube ie COPA-1

Create DTPS for above Transformations.

DTP (COPA-1 ==> COPA-2)

DTP (COPA-1 ==> COPA-3)

Now Run the DTPs with Year selections as you have specified or whatever way you want.

DTP (COPA-1 ==> COPA-2) Year = 2009

DTP (COPA-1 ==> COPA-3) Year = 1990 - 2008

Once data load is successful, delete that years data from COPA-1 so that this cube only contains data for year 2010. and keep loading only the cube COPA-1.

Try out please. All the best.

Best Regards,

Pratap Sone

[alexander_stettler]

Hi at all...

It looks quite good. Now I'm able to split my cubes automatically with a process chain by years.

(Realized with a few transformations, a few DTPs, an own process type (ABAP with a result flag for success or failure) and an own customizing table to define the selection values (to split and delete the Cube data)u2026

Thanks for your tips...

Regards, Alex

[Former Member]

Hi Alex and all,

I am trying to do exactly the same on our COPA cube with a small variation. I am trying to implement a sliding window concept.

Current year "Y" cube A

Previous year "Y-1" cube B

Earlier than "Y-I" cube.C

This year, Cube A will only have 2010 data.

On Dec 31st 2010, Cube B data moves to Cube C, Cube A data moves to Cube B, and 2011 data gets loaded into Cube A.

This should be an automated process over the years.

Is there an elegant way to implement this solution into the Process chains?

Thank you

Murali

[alexander_stettler]

Hi Murali16,

This is nearly the same thing i had to do

Have a look at the following links - Wiith this infos it should be easy for you to implement a splitting solution in your system:

- [Scheduling selective deletion in process chain - (info cube..) |http://wiki.sdn.sap.com/wiki/display/BI/Schedulingselectivedeletioninprocesschain-%28infocube..%29]

- [Creating an ABAP Process Type for Process Chains in BI that Reports Success or Failure.|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30664504-40dd-2a10-3794-db7b4190bef3?quicklink=index&overridelayout=true]

Regards, Alex

[alexander_stettler]

Good morning together and thanks for your tippsu2026

Until now, I didnu2019t know something about the possibility for selective deletion of InfoCube data. But - So it should be much easier to realize my scenario I will try it in the next few days and inform you about the success or failureu2026

Regards, Alex

[Former Member]

Hi,

As Des said why you woundnt be able to delete the data.Do a selective deletion based on your years once you have New cubes ready.

Make sure you run a report based on original data for your testing and keep for validation.You can use DTP and split Data based on Years.

Good Luck,You should be fine!

~AK

[desgallagher]

Hi Alex,

The idea of having a DTP and a seperate transformation between the original cube and the three target cubes

appears to be a good idea. Why would you not be able to delete the data from the original cube by right clicking on

it and selecting 'delete data' option? Please give some more detail.

Best Regards,

Des