I wrote recently about what Apache Drill is [https://www.rittmanmead.com/blog/2016/08/an-introduction-to-apache-drill/], and how to use it with OBIEE [https://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/]. In this post I wanted to demonstrate its great power in action for a requirement that came up recently.