Home Forums Data Warehousing Analysis Services Date Filter in Excel for pivot table with cube data source not filtering RE: Date Filter in Excel for pivot table with cube data source not filtering

  • Thanks RonKyle! #2 was the issue for me as well.

    RonKyle (10/19/2012)


    This has stymied me for some time as well. Based on the question, I took a relook. There are only two things required, as I found in Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables:

    1. To enable date filtering in the PivotTable, first set the Type of the dimension to Time.

    2. Set the ValueColumn property of the key attribute hierarchy in the time dimension to point to a date data type column in the source database. The DataType property should be set to Date.

    I had already had number 1. #2 turned out to be the missing ingredient.