I am making an assumption that Analysis Services was already installed
during the standard SQL Server/Project Server installation. Have you done
the following after you finished the installation?
Step 1: Migrating the Analysis Services Repository
1) Expand the Enterprise Manager and the Databases folder underneath it.
2) Right click on the databases folder and choose new database
3) Enter ProjectServer_OLAP for the database name and click OK
4) Expand the Enterprise Manager and the Databases folder underneath it
5) Right click on the databases folder and choose new database
6) Expand the SECURITY folder, right click on the LOGINS icon and choose NEW
LOGIN from the menu
7) Click on the box with three dots, just next to the name field to bring up
the Server NT
user list
8) Select the OLAP Administrators group from the list, click ADD and OK once
9) Click on the Database Access tab and place a check in the box for the
database
PROJECTSERVER_OLAP
10) Place a check in the db_owner box and click OK to close
11) Open the Analysis Services Manager MMC
12) Right click on the server and choose Migrate Repository from the list
13) Leave the default (Analysis Services Native Format) selected and click
NEXT
14) Enter the SQL server name
15) Choose Windows Authentication
16) Select the database PROJECTSERVER_OLAP from the drop down list
Step 2: Building an OLAP Cube and granting Access
1) From the Administration page Project Web Access go to the Manage
Enterprise Features
section.
2) Select the Update resource tables and OLAP Cube link
3) Under the Build the Cube section select the radio button for Yes, I want
to update
resource availability information and build an OLAP cube
4) Enter the name of the Analysis Services Machine, followed by an
appropriate name and
description.
5) Scroll down to the section of the page labeled Update Frequency, select
the radio button
to Update Now, and click the Update Now button.
6) Assuming that there is no data in the Project Server database the cube
building process
should not take any longer than 5 minutes. Continue to refresh the page
until under the
Cube Status section of the page it says the cube was successfully built.
7) Once the cube is built logon to the database server as a user with full
administrative rights
and open the Analysis Services Manager. (Located in the SQL Server directory
on the
Programs menu.)
8) Expand the server until you locate the Cube just created from Project Web
Access and
expand it.
9) Right click on the Database Roles icon and select Manage Roles from the
menu.
10) Select New, and enter ProjectServer as the Role name and a description
if desired.
11) Enforcement should be set to take place on the Server.
12) On the Membership tab select Add and from the drop down menu select the
primary logon
domain for your users, if the server is part of a domain.
13) Select the Domain Users group.
If you are in a workgroup setting select the Authenticated Users local
group.
If all authentication is managed using Project Server accounts the Everyone
local group
must be selected.
14) Select the Cubes tab and place a check mark in all three boxes
available, or press Check
all.
15) Click OK and Close.
