Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"The query could not be processed" error message when you try to ungroup a group after you create a filter field in an Access 2010 database

View products that this article applies to.


Consider the following scenario:
  • You open a database that contains a form. The form has a pivot table view.
  • You drag a field from the field list into the drop area of the filter fields.
  • You select a group from the fields in the row. Then, you select the complete row.
  • On the Design tab, you click Ungroup.
In this scenario, you receive the following error message:
The query could not be processed:
The heirarchy'[{GUID_Heirarchy}]' was not found in the cube when the string, [String_name].[{GUID_String}] was parsed

↑ Back to the top


To work around this problem, do not create a new filter field before you ungroup a row group in a pivot table view.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: KB982791, kbdatabase, kbpivottable, kbprb, kbsurveynew, kbtshoot, kbexpertiseadvanced

↑ Back to the top

Article Info
Article ID : 982791
Revision : 1
Created on : 5/27/2010
Published on : 5/27/2010
Exists online : False
Views : 464