Solved

Project Server OLAP Cube

Posted on 2008-06-10
5
504 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
[X]
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
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

628 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