| 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... |
