Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


differential cube building

differential cube building

differential cube building

We are currently building a cube in our environment that is taking about 12 hours to complete.  Initially (way before my time) the cube was built using differential data, which I am assuming is the use of new data after the initial cube build for updating.

Searching about on the internet, I am not having any luck finding information about this technique.  Has anyone been using differential cube builds?  Can you point me to a link?

Baring that, is there any best practices or tune-up advice to get this thing moving just a bit faster?  We have already gave the server a lot more memory.  I am running SS 2005.

Thanks in advance!


Glen Braden

RE: differential cube building

Look at partitioning your cube.  You can partition along any of your dimensions but time is usually the norm.  This allows you to process only the data represented in that partition.  If you partition by month you only ever process a months data unless you do a full process of the cube.  You can also do an update process on yuor dims an facts but becareful of doing it on your dims as it drops the aggregations.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: differential cube building

Thanks MDXer.  That makes a lot of sense. Can you point me to website/knowledge base explaining the use of partitions?  

Glen Braden

RE: differential cube building

Project Real

Project real is MS best practices.  It is the Barnes and Noble solution implemented by MS they have a number of white papers that will probably give you the true answers you need for this element of your solution along with information for other areas you may not have even thought of yet.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close