Cube Browser not filtering the data for the user having only read definition permission

Hi,

I am started working with SAS2005 recently. Using Adventure works sample database.

When I login to the Management Studio as administrator and browse the cube, the browser filters all the null value columns and rows.

Steps:

1. Add Product.Product Categories to filter area and select only Bikes

2. Add Date.Calendar.Date Calendar year to filter area and select year 2005

3. Add Product.Product to Row area

4. Add Measures.Internet Sales.Internet Sales Amount in the Total or detail area

5. Add [Date].[Month of Year] in the column area.

When I logged in as administrator or the user with the role Full control (administrator) and all the nessasary permission set on all the objects. The cube browser displays the data where only it has values. If the entire row or column are null then the row and columns are not displayed.

When I do the exactly same with the user has a role instead of full control using just read definition option (I do not want the user to get full permission, like to make a role as read only) , the browse cube shows all the rows and columns, even the row and columns where all the values are null.

The empty cells are displayed as #N/A.

Is it possible to make the browser behave for the read only user as exactly like administrator user.

Any suggestions and recommendations are great.

Thanks

I am stuck with this problem. Please somebody help...