Main Content

Date and Role-Playing Dimensions

About the Talk

November 5, 2011 9:15 AM

Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815

Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815

Let's go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn't know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be. What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and configuring SSAS to use the table as the time dimension. We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus