|Getting the Timeline Filter (Slicer) in Excel 2013 to Work with an Analysis Services OLAP Cube|
|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.Read more...