Analysis Services Role Disappears Following Nightly OLAP Cube Buil

C

Charles Simpson

Hello Everyone!

People are not able to access the Portfolio Analyzer in Project Server (cube
does not exists or you do not have permissions error) unless there is a role
created in Analysis Services. If I add a user role to Analysis Services,
then the users are able to connect.

The problem is that after the cube rebuilds (which happens every night), the
role that I created in Analysis Services disappears. If I recreate the role
the next day, the users are able to view the Portfolio Analyzer. But that
night, the role will disappear again.

Any ideas on how to get the role that I create in Analysis Services to stick
and/or what is causing it to disappear?

I have the following applications/versions:
Microsoft Windows 2003 Server R2 SP2
Microsoft Windows SharePoint Services v2.0 SP2
Microsoft Office Project Server 2003 SP2a
Microsoft SQL Server 2005 SP2 (with Analysis Services on the same SP level)

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Server 2003: Role in OLAP cube disappears after rebuilt 0
Problem with creating Data Analysis View 3
Failed to process the Analysis Services database XX_Cube on the se 3
Unable to access Microsoft Office Project Portfolio Analyzer OLAPcube 2
Cube database problems-Help me 4
Show Details is greyed out 1
Olap data views 3
Cube Build Error 0

Top