PivotTable list is slow to appear when you query the OLAP database in Excel (833830)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
SYMPTOMSWhen 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.CAUSEThis behavior is by design Excel and occurs because Excel
uses the EXCEPT function.STATUS This
behavior is by design.MORE INFORMATIONExcel 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.
| Modification Type: | Major | Last Reviewed: | 2/12/2004 |
|---|
| Keywords: | kbprb KB833830 kbAudEndUser |
|---|
|