Access isues to the OLAP cube

J

jlg

We had a problem where the cube rebuild aborted because of space. We
deleted some old files and then rebuilt the cube. Now it seems like
only admins on the windows system can now view cube data. Does anyone
know where the security may be for the cube data?

FYI, the project and resource databases are on a separate database
server the cubes are on the same server as sharepoint and project.

thanks!
jlg
 
J

James Fraser

We had a problem where the cube rebuild aborted because of space. We
deleted some old files and then rebuilt the cube. Now it seems like
only admins on the windows system can now view cube data. Does anyone
know where the security may be for the cube data?

FYI, the project and resource databases are on a separate database
server the cubes are on the same server as sharepoint and project.

thanks!
jlg
Click to expand...

The version here is pretty key. Project Server 2007 does a very good
job of managing the Cube permissions itself. 2003, not so much so.

If 2003, you will need to set the permissions manually through
Analysis Services Manager, usually installed with Analysis Services on
the SQL box.

Expand the cube in question and look in the "Roles" sub folder. If
there is a role there, you can add the needed users. Make sure the
role has permissions on all three cubes (I forget the exact term.)

If there is not a role, right click and create a new role. Then, as
above, add users, and make sure it has permissions.


James Fraser
 
J

jlg

The version here is pretty key. Project Server 2007 does a very good
job of managing the Cube permissions itself. 2003, not so much so.

If 2003, you will need to set the permissions manually through
Analysis Services Manager, usually installed with Analysis Services on
the SQL box.

Expand the cube in question and look in the "Roles" sub folder. If
there is a role there, you can add the needed users. Make sure the
role has permissions on all three cubes (I forget the exact term.)

If there is not a role, right click and create a new role. Then, as
above, add users, and make sure it has permissions.

James Fraser
Click to expand...

Thx, James, I think we found it - since we are on PS 2003 - we hit
the OLAP security was inadvertently updated / deleted. So we reset it
and are back up and running. thx for your input! ..jlg
 
Top