excel 2007 and analysis services, filter reset to all when moving filed to the filter section of pivot table

• lcohen-831390

  SSC-Addicted

  Points: 408

  More actions

  March 23, 2010 at 4:49 am

  #139519

  Environment : Excel 2007 connected to an Analysis Services (OLAP) Sql server 2005 cube (using pivot table)

  when I use a chronological filtering on a date hiearchy dimension and move the dimension (with the filter set) to the filter section of the pivot table, the dimension filter reset to "ALL", and I have to manually deselect manually every date I don't want in the date hiearchy.

  However when I move the dimension to the row section of the pivot table, the filter works. This is not an acceptable workaround because moving the date dimension to the row filter shows the date hiearchy dimension with all dates.

  Is there a way to solve this issue ? I tried to find a previous discussion on this topic with no success.

  Thanks a bunch.

  Laurent

  Laurent

• matthew.p.zinn

  Grasshopper

  Points: 15

  More actions

  July 20, 2011 at 4:50 pm

  #1356095

  Have you got a solution to this? I am having a similar issue with date filter resetting in my excel 2007 pivot table report...

  i choose a date range and when i expand through the different groupings, it resets the filter to include more than i originally filtered out.