FIX: Local Cube Dimension Member CAPTION Property Not Returned (322908)

SYMPTOMS

When creating a local cube with a CAPTION property for dimension members, the CAPTION for the dimension members in the local cube returns the member name instead of the value for the CAPTION property.

If you request the MDSCHEMA_PROPERTIES rowset by using the ActiveX Data Objects Multi-Dimensional Library (ADOMD) or the OLE DB for OLAP provider, the result indicates the CAPTION property has a Property_Content_Type value of 36 instead of the expected value of 33.

CAUSE

The Analysis Services provider returns the value in the Caption field for dimension members by searching for member properties with a content type of CAPTION. The type of the property is determined by reading the value in Property_Content_Type. The expected Property_Content_Type value, for the CAPTION type property, is 33. Because the local cube has a Property_Content_Type of 36, it is read by the provider as a CAPTION_ABREVIATION property type. As a result, the Analysis Services provider defaults the CAPTION to the name of the member, because it does not find a property with a CAPTION type.

The incorrect value for Property_Content_Type in the local cube is caused by the incorrect conversion of the keyword CAPTION to the corresponding integer value that is stored in Property_Content_Type for the property definition.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How To Obtain the Latest SQL Server 2000 Service Pack

NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.

The English version of this fix should have the following file attributes or later:

   Date         Time    Version     Size            File name   
   --------------------------------------------------------------

   04/15/2002   17:59   8.0.609.0   213,572 bytes   Msmdcb80.dll

NOTE: Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.