BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SQLBits/com
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
DTSTART:20130504T134000Z
DTEND:20130504T144000Z
LOCATION:SQLBits Conference - Suite 3
SUMMARY:Incremental processing of SSAS Multidimensional databases
DESCRIPTION: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.
X-ALT-DESC;FMTTYPE=text/html:

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.

Dr John Tunnicliffe

John is a well-respected designer and architect of business intelligence solutions who likes nothing more than getting his hands dirty with real life coding problems. 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, retail and professional services organisations.

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

Pulling on his systems integration skills whereby disparate components are brought together in a coherent fashion, John has become an expert in applying continuous integration techniques to data warehouse projects, thereby ensuring code is automatically built, deployed and tested as changes are made by the development team.
John is also a regular speaker at the SQLBits conference and SQL Saturday events.