I must be missing something fundemental. Please point out my problem
somebody!

I have created a role in my Analysis Services database for a group of
users. I added the relevant domain users to the group and set
permissions described below. When the user accesses the data, they can
see the cube and dimensions but cell data is populated with #N/A
everywhere.

They are accessing the data through ProClarity. Also, I can reproduce
this by browsing the cube from the VS IDE by using the Security Context
feature.

When I give the Role Administrative access (by clicking Admin on the
General page), the rol provides the expected access to the data.

So what am I missing?

Note that I included all domain users in the local user group for SSAS
Users. I didn't read anywhere that this was required. I just did it
when nothing else woked.

I configured the role as follows:

General - Read, Process
Data Source - Read
Cube - Read, Drillthrough, Process
Cube Data - Enable read permissions
Dimensions - All: Access = Read, Read Def = Yes, Process = Yes
Dimension Data - All everywhere
Mining Structures - n/a

Some dimensions in the database are no longer applicable and are
unprocessed. But the cube and its definitions are processed.

Since you're seeing "#N/A" in the cells, you may be getting misled by
the (admittedly confusing) verbiage on the Cell Data page of the Role
Designer. At first glance, you'd assume that you need to check at least
one of the 3 options (and it looks like you selected "Enable read
permissions"); but try clearing all the 3 check-boxes instead:

http://msdn2.microsoft.com/en-us/library/ms177279.aspx

Cell Data (Role Designer) (SSAS)

Use the Cell Data page of Role Designer to specify cell permissions for
the role.
...
Enable read permissions

Allows the role read-only access to the cells in the selected cube.
...
Enable read-contingent permissions

Allows the role read-contingent access to the cells in the selected
cube.
...
Enable read/write permissions

Allows the role read-write access to the cells in the selected cube.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***