I’ve got a weird security issue. When I issue a very specific MDX statement
to a virtual cube using a single role I get 2 different results. On the
server where the cube resides I can drill down to a postal code of a Canadian
province and see a result. Yet when I issue the same MDX statement from my
Web server using the same MS Analysis service role the postal code has 0
values even though there are values at the city level.

For example I issue the following MDX Statement

The role being used is restricting the user to a specific manufacturer group
on cube: vManuafacturerTasks

SELECT ToggleDrillState({[Gender].[(All)].members},{[Gender].[All Gender]})
ON COLUMNS, NON EMPTY
ToggleDrillState(ToggleDrillState(ToggleDrillState ({[Pharmacy
Location].[(All)].members},{[Pharmacy Location].[All Pharmacy
Location]}),{[Pharmacy Location].[Province].&[NB]}),{[Pharmacy
Location].[Province].&[NB].&[Dieppe]}) ON ROWS
FROM [vManuafacturerTasks] WHERE ([Measures].[WorkerCount])

On the database server the following is returned
All Gender Female Male Unknown
1 All 100 40 40 20
2 NB 30 24 5 1
3 -Diep 30 24 5 1
4 --E1A4X5 30 24 5 1
5 Edm 60 6 35 19
6 Fred 10 10 0 0

Notice Row #4

The same MDX statement using the same role but issued from my Web Server
across the network to the database server.
All Gender Female Male Unknown
1 All 100 40 40 20
2 NB 30 24 5 1
3 -Diep 30 24 5 1
4 Edm 60 6 35 19
5 Fred 10 10 0 0

Notice the postal code is missing. If I show all empty rows the postal code
row contains zeros even though row 2 and 3 contain the correct values.

Does anybody have any ideas? The difference is somewhere between the 2
servers and I just can’t seem to see it.
Any help would be appreciated.
Thank You
Joel Isenstadt