XL2000: Calculated Member Is Not Displayed in PivotTable (259587)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q259587

SYMPTOMS

When you create a PivotTable from an Online Analytical Processing (OLAP) cube, all of the calculated data that you selected to be included in the report does not appear.

CAUSE

This problem occurs when you select calculated members in your OLAP data cube whose parent is not a measure dimension.

STATUS

Microsoft has confirmed that this is a problem in Excel 2000.

MORE INFORMATION

OLAP databases are organized to facilitate the retrieval and analysis of large amounts of data. Before Excel displays summarized data in a PivotTable report, an OLAP server performs calculations to summarize the data. The OLAP server returns only the summarized data to Excel, and only returns data if the data member is from a measure.

When you are working with a PivotTable report based on OLAP source data, you can only use dimensions as row, column, or page fields. You can only use measures as data fields.

For additional information about dimensions, measures, and using OLAP data sources in your PivotTable, click the article number below to view the article in the Microsoft Knowledge Base:

234700 XL2000: Differences Between OLAP and Non-OLAP PivotTables

Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbpending KB259587
©2003 Microsoft Corporation. All rights reserved.