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

The information in this article 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\<User>\Application Data\Microsoft\Queries folder.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

304337 INF: How to Control a Member's Unique Name

For more information about the MDX Unique Name Style and the MDX Compatibility properties, see SQL Server 2000 Books Online.

Modification Type:	Major	Last Reviewed:	7/18/2003
Keywords:	kbbug KB818389 kbAudDeveloper