Solved

Project Server OLAP Cube

Posted on 2008-06-10
5
480 Views
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?
0
Comment
Question by:iulianchira
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:bobsegrest
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:

      http://yasirbutt.spaces.live.com/blog/cns!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
0
 

Author Comment

by:iulianchira
ID: 21757895
I was actually following the steps described in this guide http://technet.microsoft.com/en-us/library/cc197552(TechNet.10).aspx. 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?
0
 
LVL 13

Expert Comment

by:bobsegrest
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:

   http://technet.microsoft.com/en-us/library/cc197479(TechNet.10).aspx

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

Bob Segrest, PMP
Microsoft Project Blackbelt
0
 
LVL 13

Accepted Solution

by:
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
0
 

Author Comment

by:iulianchira
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.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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.
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now