FIX: Calculated Members, Actions, and Named Sets That Are Created from a Decision Support Objects Application Are Not Displayed (320723)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q320723 BUG #: 12827 (plato7x) SYMPTOMS Calculated members, named sets, and actions are not
displayed in Analysis Manager Cube Editor after you create a new cube from a
custom Decision Support Object (DSO) application, and then you edit it in
Analysis Manager.
This problem only occurs if the instance of
Analysis Manager that you used to edit the cube is open when you create the new
cube from the custom DSO application.
NOTE: If you close Analysis Manager, and then restart it, the problem
no longer occurs. CAUSE The problem occurs because of an issue with the way the
list of cubes is refreshed in the Analysis Manager. 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 : 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
-------------------------------------------------------------
19-MAR-2002 13:57 PM 8.0.0.601 4,043,328 Msmddo80.dll
19-MAR-2002 13:56 PM 8.0.601.0 1,008,192 Msmdgd80.dll
19-MAR-2002 12:53 PM 8.0.601.0 1,774,148 Msmdsrv.exe
19-MAR-2002 13:57 PM 8.0.601.0 2,024,016 Msolap80.dll
18-APR-2001 12:23 AM 2000.80.382.0 815,676 Sqldata.dll
19-MAR-2002 13:56 PM 2000.80.534.0 590,396 Sqlsort.dll
NOTE: Because of file dependencies, the most recent hotfix or feature
that contains the files may also contain additional files. WORKAROUND To work around this problem, close all instances of
Analysis Manager before you run the custom DSO application that creates the
cube. STATUSMicrosoft has
confirmed that this is a problem in Microsoft SQL Server 2000 Analysis
Services.
This problem was first corrected in Microsoft SQL Server
2000 Service Pack 3.MORE INFORMATION Analysis Services stores the definition of the calculated
members, actions, named sets and Dynamic Link Library (DLL) registrations as a
collection of commands. These commands are included in the database record in
the OLAP Repository. Security roles also store a collection of commands that
are related to the role restrictions. Prior to this fix, the commands
collection of new objects was incorrectly read from the ROLES commands
collection for the cube instead of the Cube Commands collection.
| Modification Type: | Minor | Last Reviewed: | 4/28/2003 |
|---|
| Keywords: | kbSQLServ2000sp3fix kbbug kbfix kbSQLServ2000preSP3fix KB320723 kbAudDeveloper |
|---|
|