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.
Slide Deck 965 KB , MP4 Video Low 79 MB , MP4 Video Med 117 MB , MP4 Video High 260 MB , MP4 Video HD 468 MB