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 2011
Building a dynamic OLAP environment
This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.
You will have heard of (and hopefully used) dynamic SQL; but dynamic OLAP?
Often end-users demand that extra attributes are added to the cube to meet their own specific analysis needs. This is particularly true when you are selling market data where each client demands their own cube with their own set of attributes. Building several hundred OLAP databases per day, each with its own unique set of data and attributes becomes a tall order unless the process is automated.
This session will present the tools and techniques used to create fully functional OLAP data marts on-the-fly from a mere set of data files and configuration metadata.