Microsoft KB Archive/290416

= BUG: Unable to Drill Down to Next Level with Hide Member if Property Set =

Article ID: 290416

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q290416



BUG #: 12020 (plato7x)



SYMPTOMS
If you use the Cube Browser within the Analysis Manager, you may not able to drill down to the next level if the Hide Member If property is set to any valid value other than Never Hidden.



WORKAROUND
To work around this problem, double-click the level name of the dimension (instead of the individual member) to expand to the next level.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0.



MORE INFORMATION
This problem only occurs with ragged dimensions and has nothing to do with the actual dimension data. This problem is specific to the Analysis Manager Cube Browser.

Steps to Reproduce Behavior
  Using Microsoft Access, create the following two tables: Store Location (Dimension table) Store LocationID  City        Zip_Code    Store - 1                 Hong Kong   NULL        ABC 2                 Houston     35816       OWC

Transactions (Fact table) Store LocationID  Sales_Unit -- 1                 30 2                  40

 In the Analysis Manager, create a new database, and then create a new data source pointing to the Access database using the Microsoft Jet 4.0 OLE DB provider. In the Dimension Wizard, create a new dimension with the following levels: City, Zip_Code, Store. Change the Hide Member If property for Zip_Code to No Name. Save the dimension as &quot;Store Location&quot; and process the dimension.</li> In the Cube Wizard, create a cube using Transactions as Fact table and Sales_Unit as measure. Add Store Location as the dimension table. Make sure that both tables are joined using the Store LocationID.</li> Save the cube as &quot;HideMemberIfCube&quot; and process the cube.</li> Open the cube folder, right-click the HideMemberIfCube cube, and then click Browse Data.</li> In the Cube Browser, under the City level, double-click the Hong Kong member name.</li></ol>

You are unable to drill down Hong Kong to the next level. However, if you double-click the level's name (which is City), you are able to drill down to the next level.

Keywords: kbbug kbnofix KB290416

-

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

© Microsoft Corporation. All rights reserved.