XL2002: Cannot Use Two GB18303 Characters in Dynamic OLAP Cube (821032)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft SQL Server OLAP Services 8.0

SYMPTOMS

When you try to create a dynamic cube programmatically by using two GB18030 characters as member or measure names, you receive one of the following error messages:
Measure<Null> can not be added.
-or-
Runtime error '1004'
Application-defined or object-defined error

CAUSE

This problem occurs because Analysis Services version 8.0 uses the Unicode support in Microsoft SQL Server 2000. SQL Server 2000 is based on Unicode 2.0. GB18030 was not included in the Unicode specifications until version 4.0.

MORE INFORMATION

The Chinese government mandates that all new applications and operating systems sold in China support the GB18030 character set. Because SQL Server 2000 was developed before the law went into effect, it is exempt from this law.

GB18030 is a new Chinese character encoding standard that has the following characteristics:
  • Very large character set with room for 1.6 million characters.
  • GB18030 characters can be one, two, or four bytes.
  • Provides support for previously unsupported languages (for example Tibetan, Mongolian, Yi, and Uyghur).
  • Code page identifier of 54936.
For more information about and how to obtain GB18030 support for Microsoft Windows XP and Microsoft Windows 2000, visit the following Microsoft Web site:

http://www.microsoft.com/globaldev/DrIntl/columns/015/default.mspx#Q6

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:5/15/2003
Keywords:kberrmsg kbBug kbprb KB821032 kbAudEndUser
©2002 Microsoft Corporation. All rights reserved.