Excel Services filter: "Additional Items Hidden"

Question

I am publishing an Excel Services report to Sharepoint.  The report is connected to an SSAS cube and contains a pivot table that is filtered to show the Top 10 values.  When viewing the report in Sharepoint there is a down arrow on the column that is being filtered.  If the down arrow is clicked a small menu containing the attribute name which is being filtered is displayed.  The attribute name contains a submenu with the following options: "Sort Ascending", "Sort Descending", "Clear Filter from <Attribute Name>", "Label Filters", "Value Filters", and "Filters..." 

This particular attribute that is being filtered has a lot of values.  If a user selects "Filters..." from the submenu they only see a partial list of values and the very last value reads "Additional Items Hidden...".  The users can get around this by instead selecting "Label Filters" but they would rather not have to do this.  Is there a way to show all the filter values or at least set the threshold of how many filter values will show up in the list?

Thank you!

Answer 1

The limit is 1000 per level in the tree/hierarchy.  It is not configurable and is the same in MOSS 2010.

http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/4c2b51f2-e510-4159-8bb8-618e63d03f37

---

S/W Engineer, Microsoft Office Excel Services