Skip to Content
0
Former Member
Jul 14, 2016 at 09:15 AM

Logical partitioning-standard cube which contains data

52 Views

Dear Experts,

We are on BW 7.4 SP 13 though our sales data flow is 3.x.

We are looking at a standard sales cube which contains almost 8 yrs of data. Now this has been poorly managed so far with no compression no logical partition happening and this has landed us into load and query performance trouble.

I have gone through a few threads that reference logical partitioning and I would like some guidance on the steps I plan to carry out:

Any help will be appreciated.

1. I plan to remodel the sales cube such that the dimensions are not overly loaded. I will move some chars from one dimension to another.

2. Post running the rule and reshuffling all the dimension data, I will create copy of the existing cube.

3. Run data load from old cube - cube 1 to new cube - cube 2.

4. I would like to post all data for years 2008- 2013 in the cube 2 and retain 2014-2016 in the existing cube 1 and continue delta load to this.

5. Now, I will run selective deletion on the cube 1 to delete data for the years 2009-2013.

6. Continue normal deltas to the existing cube.

I would like to understand if this impacts the initializations that have happened to the existing cube. As I understand it, selective deletion should not affect the original delta links to this cube 1.

Also, remodeling has any impact, since it will change the structure of the cube and reload all the data (by use of temporary DTP and cube). I am trying my hand at remodeling for the first time hence the hesitation.

Could you please let me know if this sounds reasonable.

Thanks,

Sally