Microsoft KB Archive/920992

= 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: &quot;The permission required for this operation has not been granted&quot; =

Article ID: 920992

Article Last Modified on 9/18/2006

-

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 &quot;Applies to&quot; section.

Keywords: kbpending kbtshoot kbbug KB920992

-

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

© Microsoft Corporation. All rights reserved.