Microsoft KB Archive/248619

= FIX: Dimension Wizard Does Not Allow Creating Time Dimension Hierarchies with DB2 Date Columns =

Article ID: 248619

Article Last Modified on 8/7/2006

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q248619



BUG #: 1378 (SQLBUG_70)



SYMPTOMS
OLAP Manager Dimension Wizard does not allow users to create time dimension hierarchies (such as year, month, day, and so forth) with IBM Data Base 2 (DB2) database columns of "date" data type. When the user tries to specify a "time" dimension, the following error message appears:

OLAP Manager

Could not count the members of the ‘Year’ level.

Cannot open the record set.

Query: …

Error: The operation requested by the application is not allowed if the object is closed.



WORKAROUND
To work around this problem, use the Dimension Wizard to create this dimension as a "standard" dimension and then use the Dimension Editor to manually edit the "member key column" property of the levels with corresponding DB2 date functions to display the time hierarchy (such as year, month, day, and so forth). Other properties such as "level type" may need to be changed as well.



STATUS
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8

For more information, contact your primary support provider.



MORE INFORMATION
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Keywords: kbbug kbfix KB248619

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.