Skip to Content
author's profile photo Former Member
Former Member

Logical partitioning-standard cube which contains data

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 14, 2016 at 09:21 AM

    do you have a dso before your sales cube?

    also, do a search for SPO. this is the way to partition your cube. depending if you have a dso or not we can discuss the options on how to change your current cube to a SPO.

    M.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.