Can't see any data when I browse the cube :(

Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ' I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.micr
osoft.com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ' I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.

Can't see any data when I browse the cube :(

Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ? I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.
Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.microsoft. com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ? I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.

Can't make database role a member of another database role in 2005.

In sql server 2000, I created some custom database roles called ProjectLeader and Developer. I would make these roles a member in the fixed database roles so that I would only have to add the user to the ProjectLeader or Developer role once and they would presto-magico have the security I wanted them to have with no unecessary mouse clicking. I'm not sure how to repeat this process in 2005? Management Studio doesn't seem to allow you to add a role as a member in another role. Is there a work around or solution for this?

You can always use T-SQL; see sp_addrolemember in Books Online. You can post on the Tools forum to see if there is a way to do this within the GUI.

Thanks
Laurentiu