Dear all,

I have a question about dimension restriction.

Using Database Role Manager and Cube Role Manager, I retricted data access
to certain users. However, when they used "Grouping" in Excel's Pivot Table,
error was shown.

I would like to know whether "Grouping" can only be used when all dimensions
are required to be unrestricted access. Thanks!

Polly

Hi Polly,

It looks to me like you encountered the problem documented in:

XL: Calculated Measures Disappear When OLAP PivotTable Is Grouped WGID:353
ID: 313611.KB.EN-US
http://support.microsoft.com/default...b;en-us;313611

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."