Microsoft KB Archive/233003

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

Article ID: 233003

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



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.

Keywords: kbbug KB233003

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.