Getting the Timeline Filter (Slicer) in Excel 2013 to Work with an Analysis Services OLAP Cube
User Rating: / 0
Written by Bryan C Smith   
Friday, 30 November 2012 17:36

In Excel 2013, there is a new Timeline filter (slicer) that allows you to easily select a range of dates over which you want to filter your data. The feature is very slick. Here's an picture:

I wanted to use this slicer in an Analysis Services demo but run into a bit of an issue getting this to work with my OLAP cube. After spending a little time with the Excel team, it turns out that this slicer picks up on the MemberValue property. If you map an attribute's MemberValue property to a field that uses a date data type, the Timeline filter is available to you.



Tags: excel, time

XL Cubed