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:
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:
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