FIX: OLAP: "Object Does not exist" Error Processing Multi-Hierarchy Dimension (234660)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q234660
BUG #: 1539 (plato7x)

SYMPTOMS

When processing a cube or partition where a partition is sliced by a multi-hierarchy level member, an error similar to the following occurs:
Processing Failed:
Object Does not exist 'Qtr;AllTime;1998'
Qtr is the name of one drill-down path of the hierarchy (for example, Time.Qtr).

WORKAROUND

Create a view on the datasource that will limit the data on the partition to the desired subset.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.
Modification Type:MajorLast Reviewed:3/14/2006
Keywords:kbBug kbfix KB234660
©2004 Microsoft Corporation. All rights reserved.