2007 - Portfolio Analyzer

T

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.
 
J

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.
Click to expand...


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
 
Top