Report Portal

Getting the Timeline Filter (Slicer) in Excel 2013 to Work with an Analysis Services OLAP Cube

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


2007-2015 VidasSoft Systems Inc.