How to use Time Intelligence Filters with Excel Services or how to pass a range selection into your Excel Report

PerformancePoint Dashboards have a set of filters that allow both PerformancePoint content and other content to connect and interact with each other. I wanted to talk a little bit more about the Time Intelligence Filter and how you can use this to get range based queries in Excel.