Incremental processing of SSAS Multidimensional databases

Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions.  John will illuminate the dark interior of SSAS and describes how attribute relationships, aggregation design and different processing techniques can all have a positive or negative impact on your real-time cubes.
John will give you real life examples of why certain approaches work and others do not, describing some of the pitfalls of each approach.

At the end of the session, you should fully understand how to use ProcessUpdate and ProcessAdd to incrementally update dimension data and also various approaches to processing fact partitions including negation strategies.
  • Downloads
    Slide deck available Slide Deck 529 KB
    Video available MP4 Video Low 102 MB
    Video available MP4 Video Med 193 MB
    Video available MP4 Video HD 531 MB
  • SpeakerBIO

    John is an independent consultant with extensive experience of implementing Business Intelligence solutions on the Microsoft platform across a wide range of industries including financial services and professional services organisations.

    John designs and builds solutions based on Microsoft SQL Server / SSAS / SSRS / SSIS delivered to the end-user through SharePoint portals.

    John's key skills are in systems integration, bringing together disparate components and getting them working in a coherent fashion.

    Specialties: Design and development of business intelligence, data warehouse and reporting systems based on OLAP technologies delivered to the end-user via SharePoint.
  • Video