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

• Microsoft SQL Server OLAP Services version 7.0

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 this to be a problem in SQL Server OLAP Services version 7.0.

Additional query words:

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbbug