Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Access cube levels in excel

Author  Topic 

scottichrosaviakosmos
Yak Posting Veteran

66 Posts

Posted - 2012-03-18 : 13:20:20
I have cubes which have dimesions. We have total 5 levels in hierachy and we have 2 users to access the cubes
user A and B. Both have same Roles and rights.

Now the issue is that when user A access the cube he is able to see upto level 4 in excel sheel even after
selecting level 5. But User B can see all the level( upto level 5 which is last level) in same sheet and with same
datasource.

I am not able to understand what is the matter since both users have same roles on all the objects.
Is there any setting in excel or we are missing something.?


scoo
   

- Advertisement -