When you drill-down into a PivotTable in Microsoft Excel
that is attached to an Online Analytical Processing (OLAP) cube, the list of
results may take longer than you expect to appear. When you update the
PivotTable, any new items that you have added to the cube appear as
unfiltered.
↑ Back to the top
This behavior is by design Excel and occurs because Excel
uses the EXCEPT function.
↑ Back to the top
Excel uses the Multidimensional Expressions (MDX) language
to query the OLAP cube. When Excel runs a query, it uses the EXCEPT function to
return the differences between two sets of data. When Excel uses the EXCEPT
function, your filtered data and any new data will be returned as a result of
drilling down into your PivotTable.
Excel uses exclude filtering
instead of include filtering because you have no way of knowing that additional
items have been added to the cube unless the new items appear when you update
the PivotTable. After the new items appear, you must manually remove the
selection if you want to filter out the new items.
↑ Back to the top