BUG: OLAP Manager Cube Browser Unable to Display Data When All Base Measures are Hidden (233003)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q233003
BUG #: 1529 (plato7x)

SYMPTOMS

The OLAP Manager cube browser does not display the defined calculated members for a cube when all base measures are hidden by setting the Is Internal property to Yes. Instead, it displays the value #ERR in the column measures level.

When all base measures are hidden, the cube processes without any errors, but attempting to browse the cube data results in the measures level on the columns displaying #ERR. Even when the cube contains valid data, the OLAP Manager cube browser does not display calculated members on columns unless a base measure for the cube is also available for display.

WORKAROUND

Here are three workarounds:
  1. If the measures dimension is dragged to the page area you can then view one calculated member value at a time by selecting that member in the drop-down list box.
  2. You can view calculated members from the MDX sample application using appropriate queries.
  3. You can view the calculated members on the columns axis by using the Pivot Table Service in Excel 2000.

STATUS

Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug KB233003
©2003 Microsoft Corporation. All rights reserved.