Creating Analysis Services Partitions Using BIDS

Who is online?  0 guests and 0 members
Home  »  Blogs  »  briankmcdonald  »  Creating Analysis Services Partitions Using BIDS
 
3.79
/5
Avg: 3.79/5: (1 votes)

Comments (8)

Daniel
Daniel said:

Nice review of how to set up and configure query binding to create partitions Brian.  Thanks.  Although you built your queries with this in mind, I think it is important to note that it is a cardinal rule in partition design that there should be NO overlap and NO gaps between partitions.  In other words your 2006 partition constrains the data with

WHERE OrderDateKey >= '20060101' AND OrderDateKey <= '20061231'

 

If your query was:

WHERE OrderDateKey >= '20060101' AND OrderDateKey < '20061231' 

  

Or:

WHERE OrderDateKey >= '20060101' AND OrderDateKey <= '20070101' 

 

you would have data integrity problems in your cube.  In the first case you could have data missing for the December 31 2006.  For the second you will double your numbers for January 1 2007 because of the overlap.  When building several queries in a row for several partitions it is very easy to cut and paste and put a typo in your operators, or typo in your criteria and end up with data problems.

4/11/2011
 · 
 
by
briankmcdonald

Daniel,

You are so right. And as I wrote my blog, I made it a note as to not have any missing or overlap. My queries would not have either one of those, but I guess I could have included that information in my blog post. Thanks for your reply.

Brian K. McDonald, SQLBIGeek

4/11/2011
 · 
 
by
meganathank
meganathank said:

I was looking for step by step instructions for cube partition and found the right one here, Thanks!

4/13/2011
 · 
 
by
briankmcdonald

I'm glad that it helped.

4/13/2011
 · 
 
by
Sandeep Reddy
Sandeep Reddy said:
Nice Review.. It help me a lot.
4/12/2012
 · 
 
by
cecil
cecil said:
Great post.very grateful to u ..
10/4/2012
 · 
 
by
briankmcdonald
You're welcome Cecil. I am glad it helped you.
10/4/2012
 · 
 
by
bhavi
bhavi said:
nice information.This information helped me more in my work. thank you
10/11/2013
 · 
 
by
  • Name:*
  • Email:*
  • Website:
Type the characters you see in the image: *
Blogs RSS Feed

briankmcdonald's latest blog posts

Blogs RSS Feed

Latest community blog posts