Article ID: 281117 - View products that this article applies to.
This article was previously published under Q281117
BUG #: 11122 (plato 7.x)
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
When you complete the design of a large dimension in Dimension Wizard while the Count level members automatically option is selected, you may receive the following error message:
The error may also occur in Dimension Editor.
Unable to count the members of the 'XYZ'level. Unable to open the record set. Error: Timeout expired.
The command timeout in OLAP Manager is set to 30 seconds. If the counting of the members takes longer than 30 seconds, you receive the error message.
Microsoft SQL Server 2000 (Analysis Services)To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Microsoft SQL Server 2000 Analysis ServicesThis problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
Note The new timeout is three minutes, and after three minutes, the timeout reoccurs.
With the Member Count property in Dimension Editor, you can enter the Member Count manually, but if you click the button in the property field, or if you click Count Dimension Members on the Tools menu, you are prompted as to whether you want the members counted automatically. This counting process can take a long time. If you click Yes in response to this prompt, you may receive the error message that is described in the "Symptoms" section, and you must manually type a value.
Note Make sure that you type an accurate count for these levels because the aggregation design relies heavily on these counts. To count the members, you can use a tool such as SQL Query Analyzer and query for the count of the members.
You can use syntax similar to the following SQL query to return the number of members for a specific dimension level: