2007 - Portfolio Analyzer

[TroyS]

In PS2003, we needed to migrate the olap cube from an MS Access file (*mdb)
to a SQL Server Database.

In PS2007, does that go away? OR do we still need to migrate the default MS
Access database to SQL Server?

If so, is there a link on how to do in the new 2007 environment?

I'm not seeing it addressed in the deployment guide for PS2007.
thx.

 

[James Fraser]

In PS2003, we needed to migrate the olap cube from an MS Access file (*mdb)
to a SQL Server Database.

In PS2007, does that go away? OR do we still need to migrate the default MS
Access database to SQL Server?

If so, is there a link on how to do in the new 2007 environment?

I'm not seeing it addressed in the deployment guide for PS2007.
thx.

The same issue exists in DSO with Analysis Services 2005. The link
below is the instructions for setting up AS / OLAP with Project Server
2007. Note that there is "Option 1" which uses the JET database
(Access) or "Option 2" which creates the repository in SQL.

http://technet2.microsoft.com/Offic...701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true


James Fraser

 

[TroyS]

Thanks for the link on this...

The same issue exists in DSO with Analysis Services 2005. The link
below is the instructions for setting up AS / OLAP with Project Server
2007. Note that there is "Option 1" which uses the JET database
(Access) or "Option 2" which creates the repository in SQL.

http://technet2.microsoft.com/Offic...701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true


James Fraser

 

[Gary L. Chefetz [MVP]]

I recommend using the SQL option for your repository.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com