SYMPTOMS
If a member property is defined for a level in an Analysis
Services dimension and the member property type is set to
Caption, any calculated members created in the dimension for that level
will have a blank caption value.
For example, if a member property is
defined on the
"customer"."state_province" column of the customer table for the State Province level of the
Customers dimension in the
Foodmart
2000 sample database, and the type of the property is set to
Caption, the following query will return a row with a blank caption when
it is run from the MDX sample application:
With Member [Customers].[All Customers].[USA].[Total] AS
'[Customers].[All Customers].[USA].[CA] +[Customers].[All Customers].[USA].[WA] +[Customers].[All Customers].[USA].[OR] '
SELECT
{[Measures].Members}
ON COLUMNS,
{[Customers].[All Customers].[USA].[Total]}
ON ROWS
FROM [Sales]
RESOLUTION
Service pack information
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 How to obtain the latest SQL Server 2000 service pack
Hotfix information
The English version of this
fix has the file attributes (or later) that are listed in the following table.
The dates and times for these files are listed in coordinated universal time
(UTC). When you view the file information, it is converted to local time. To
find the difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name
--------------------------------------------------------------
17-Apr-2003 01:29 8.0.806.0 217,668 bytes Msmdcb80.dll
23-Jul-2003 04:23 8.0.0.843 4,055,616 bytes Msmddo80.dll
22-Aug-2003 06:18 8.0.853.0 1,032,768 bytes Msmdgd80.dll
16-May-2003 08:26 8.0.823.0 172,608 bytes Msmdpump.dll
27-Jan-2003 07:47 8.0.0.761 9,638,464 bytes Msmdsgn80.dll
22-Aug-2003 01:07 8.0.853.0 1,831,492 bytes Msmdsrv.exe
27-Aug-2003 21:29 8.0.855.0 2,077,264 bytes Msolap80.dll
10-May-2003 08:05 8.0.820.0 213,069 bytes Msolap80.rll
Note Because of file dependencies, the most recent hotfix or feature
that contains the files may also contain additional
files.
SQL Server 2000 Analysis Services 64-bit
For additional information about a hotfix build designed to be applied on a server that is
running SQL Server 2000 Analysis Services 64-bit, or to find out if a fix is
scheduled to be included in SQL Server 2000 Analysis Services 64-bit Service
Pack 4, click the following article number to view the article in the Microsoft Knowledge Base:
822985
Hotfix Information for Build 8.0.861.0 of SQL Server 2000 Analysis Services 64 bit