Splitting a Infocube

[former_member182470]

Hi,

Pre-Requisite Requirement : I want to partition my large cube(contains 4 Cr records). So I proceeded as the following

I carried out the Creation of a copy of my existing Cube and loaded data to my new copy cube. Before partitioning the original cube, I need some clarifications on the following :----

---

1. In the course of creation of Copy of my Cube, I created Transformation and DTP. After this, I loaded data from Original Cube to Copy cube, but there was no Infopackage to run. I just ran Full load in DTP which got the entire data from original to Copy cube. Is it correct?

2. After I partition my original cube and try to load yearwise, How should I put selection year range without Infopackage between Original to Copy?

Please clarify me for the above........

Regards,

Suman

[Former Member · Accepted solution]

1. Yes it is correct

2. Create a transformation between you Original Cube and Copy Cube.

Original cube should be your target and Copy cube should be your source for transformation.

and then create a DTP for the newly created transformation. IF you want to load year wise, use selections in DTP filter.

--- Thanks...

[former_member182470 · Accepted solution]

Any more inputs............

Points will be assigned

Regards,

Suman

[former_member182470]

Thanks Guys