Project Server OLAP Cube

Posted on 2008-06-10
Last Modified: 2013-11-15
I want to process an create an OLAP for Project Server. The problem is that by default Project Server installed on SQL Server Express, but for the OLAP Cube i want to use another server with Analysis Services. How should I configure it, and how should I configure the OLAP Cube in Project Server?
Question by:iulianchira
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 13

Expert Comment

ID: 21756211
Hello iulianchira,

I haven't tried it, but I can't think of any reason it shouldn't work.

You will definitely need to install the DSO 9.0 components on the project server (and possibly on the SQL server if they are not already installed).  The following article should lead you through this:!A8677D5751E6B4DA!1020.entry

After this is done log into your PWA site, select Server Settings, select Cube Build Settings and fill in the name of your SQL Server and the database name you want to create.  Then start the cube build.

Bob Segrest, PMP
Microsoft Project Blackbelt

Author Comment

ID: 21757895
I was actually following the steps described in this guide My problem is adding the SSP account to the to the OLAP users local group. The SSP service runs on NT Authority\Network Service which of course is not available on the machine running SQL Server Analysis Services.
I would like some guidance on how to proceed to change the SSP user account and add it to the OLAP Cube users group?
LVL 13

Expert Comment

ID: 21758404
Hello iulianchira,

I apologize for my oversight.  Your current configuration will not work because there is no way for your SQL server to authenticate a local account on your project server.  No authentication, no trust, no work.  This is one of many reasons why you should not use the Basic project server installation option.

You can rebuild your Project Server and avoid this problem.

  First install Windows Server 2003, enable IIS and apply all of the updates.
  Then install Windows SharePoint Services (It is free with Windows Server).
  Then install Project Server; this time select the advanced rather than basic option
    and specify your database server when configuring PWA.

This should resolve several problems with the Basic installation.  

First, installing the WSS kit should install the Embedded version of SQL rather than the Express version.  A key difference being that your database doesn't die when you try to exceed 4 GB.  (For most people this is really a ticking time bomb.)  I think it may also be possible to simply use your SQL server instead.

Second, you will be able to specify which account is used to manage the Project Server and which is used to connect to your SQL database system.  You must use a domain account.  The account does NOT need any special domain priveledges, but it will need administrative privileges on the project server and to the SQL database.

The following page describes the installation process:

What you need is a "2-Tier" or "small farm" deployment.

Bob Segrest, PMP
Microsoft Project Blackbelt
LVL 13

Accepted Solution

bobsegrest earned 500 total points
ID: 21761080
Hello iulianchira,

I had some time so I tried a few things in my lab this morning and I am afraid the results were not very encouraging.  The WSS approach that I outlined in my previous entry isn't going to get you where you want to be.  The problem is that WSS is a single server only resource and you can not create a two server farm.

If you install WSS on a machine that is already running SQL Server Standard, it will use the existing SQL Server.  You should then be able to install Project Server and use analysis services on the local machine.  For lab work this is fine.  My experience has been that any organization that purchases a SQL server license is probably going to prohibit the installation of other services on the same machine.

What it boils down to is that you really need to deploy a proper SharePoint farm with Microsoft Office SharePoint Services.  Then install Project Server on this machine and use your existing SQL Server for database services.

Bob Segrest, PMP
Microsoft Project Blackbelt

Author Comment

ID: 21792658
You are right. The only way i was able to get the cube to build was by installing in a farm configuration and explicitly specifying the database server.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Project VBA - Date and time stamp the date column 10 1,265
MS Project 2002 Object Model 7 150
Old act to CRM 2 169
Todo/teamwork/project manager 5 40
Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question