Dr John Tunnicliffe
devops-your-dwh.com
Dr. John Tunnicliffe is a hands-on architect of BI solutions for the modern enterprise. He inspires development teams to deliver best-in-class systems to meet the most demanding business requirements.
SQLBits 2013
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 give you real life examples of why certain approaches work and others do not.
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.
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.