BUG: Error message when you try to perform a grouping operation on an Excel pivot table that uses a SQL Server 2005 Analysis Services cube as a data source: "The permission required for this operation has not been granted" (920992)


The information in this article applies to:

  • Microsoft SQL Server 2005 Analysis Services
Bug #: 916 (SQL Hotfix)

SYMPTOMS

When you try to perform a grouping operation on a pivot table in Microsoft Office Excel, you may receive an error message that resembles the following:
The permission required for this operation has not been granted
This problem occurs when the pivot table uses a Microsoft SQL Server 2005 Analysis Services cube as a data source.

This problem occurs when you use the following versions of Excel:
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000

CAUSE

This problem occurs because of a bug in SQL Server 2005 Analysis Services. Excel uses session cubes to perform grouping operations on SQL 2005 Analysis Services-based pivot tables.

Note A session cube is a cube that is available to all queries that are in the same session.

To create a session cube, the Excel user must be in a security role that has drillthrough permissions in SQL Server 2005 Analysis Services. When the Excel user is in a security role that does not have drillthrough permissions in SQL Server 2005 Analysis Services, this problem occurs.

WORKAROUND

To work around this problem, add the Excel user to a security role that has drillthrough permissions in SQL Server 2005 Analysis Services.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:9/18/2006
Keywords:kbpending kbtshoot kbbug KB920992 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.