Microsoft KB Archive/818389

= BUG: Unexpected Behavior Occurs When You Perform a Drill Down of a Parent-Child Dimension That Has a Ragged Hierarchy =

Article ID: 818389

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



BUG #: 13976 (Plato7x)



SYMPTOMS
When you drill down a parent-child dimension member that has a ragged hierarchy, you might see one of the following behaviors in the Microsoft Analysis Services client application:
 * You cannot drill down to the lowest level.
 * The drill down shows the same child member repeatedly. It never shows the next child member.

Analysis Services shows the same child member repeatedly when:
 * The dimension is a parent-child dimension.
 * A Skipped_levels column is specified in the dimension definition.
 * The MDX Compatibility connection string property is set to 1 or 0 to expose placeholder members.
 * One or more skipped levels exist between the parent and child members.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



WORKAROUND
To work around this problem, set one of the following connection string properties:
 * Set MDX Compatibility to 2.
 * Set MDX Unique Name Style to 1.

Note If you use Microsoft Excel as the client application, set the MDX Unique Name Style property in the connection string, and then use the connection string to create the pivot table.

To use MDX Unique Name Style in the connection string, you must edit the Microsoft Excel OLAP Query File (.OQY). By default, the Microsoft Excel OLAP Query File is stored in the C:\Documents and Settings\\Application Data\Microsoft\Queries folder.

