Enable Analysis Services

[Som]

I have a basic Project Server 2003 install. When I installed it, I have
chosen pretty much everything to be provided later, like the email alert
feature and the Analysis service etc.
Now, I want to prepare analysis demos by using OLAP cubes. Without having to
reinstall, how do I go about it?

 

[Marc S.]

Som,

all you need to do is provide the connection information to your SQL
Analysis Server. To do this, open the Admin section in Project Web Access
click 'Manage Enterprise features'. In the section 'OLAP cube name and
description' type in the server name of your Analysis Server and specify the
cube name, the two other fields are optional.

Make sure on your Analysis Server SQL Analysis Services SP3 or later is
installed.

Hope this helps...

Marc

 

[Som]

Thanks Marc. I am about to give this a shot and pretty sure will be able to
handle it. One quick question though:
"Make sure on your Analysis Server SQL Analysis Services SP3": how do I
check the SP of my SQL Server 2005 install is SP3? Can I download SP3 from
MSDN downloads? If so, where from I can download?