XL2000: Calculated Member Is Not Displayed in PivotTable

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.

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

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

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: