BUG: Unable to Drill Down to Next Level with Hide Member if Property Set (290416)

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

1. 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
   
   					

2. 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.
3. In the Dimension Wizard, create a new dimension with the following levels: City, Zip_Code, Store.
4. Change the Hide Member If property for Zip_Code to No Name.
5. Save the dimension as "Store Location" and process the dimension.
6. 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.
7. Save the cube as "HideMemberIfCube" and process the cube.
8. Open the cube folder, right-click the HideMemberIfCube cube, and then click Browse Data.
9. In the Cube Browser, under the City level, double-click the Hong Kong member name.

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.