This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time. Other patterns concerns the use of Slowly Changing Dimensions in Analysis Services, evaluate whether to use parent-child hierarchies or not, the consolidation of independent attributes into a junk dimension. Finally, the session will analyze drillthrough issues and solutions and the technique necessary to create special calculation dimensions.