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...

Cube administration

What are the activities that a cube administrator does?
Cube has been designed by a developer.
Cube processing is taken care of by the ETL task.
Building partitions and setting permissions/access to cubes are a couple of
things that might need to be done by an administrtor.
Are there any other tasks?
Is it usual to take a back up of the cube? can it just not be rebuilt from
the data base if needed?
thanks
Message posted via http://www.droptable.com"Sara via droptable.com" <forum@.droptable.com> wrote in message
news:edab3fed237f47b8a60ec9aa06305e10@.SQ
droptable.com...
> What are the activities that a cube administrator does?
> Cube has been designed by a developer.
> Cube processing is taken care of by the ETL task.
>
> Building partitions and setting permissions/access to cubes are a couple
> of
> things that might need to be done by an administrtor.
> Are there any other tasks?
Read olapdmad.chm::/agadmintasks_50z7.htm in BOL.

> Is it usual to take a back up of the cube? can it just not be rebuilt from
> the data base if needed?
Yes if you make a "full process" every time you process the cube. Make only
a backup version of your cube so that you can easily rebuild it if a crash
occurs.
If you make an incremental update and some of your data may have benn
deleted from the data source (Old customers, or past years invoices for
example),then you can consider tto take a backup of your cube, even if I
prefer to take a backup of the tables instead of a backup of the cube.
Backup a cube may be useful if you want to transfer a cube from one analysis
server to another

> thanks
Bye
Francesco Anti