OLAP Cube - Add Dimension Question

[Brent99Admin]

In a recent posting by Hughes he stated to use some code from the Project Server Experts site that he developed to add weeks as a time dimension to the OLAP Cube.

Can anyone tell me how to get the connection string in Project Server 2003? The info from Hughes posting I would assume is for PS2002 since I don't see the "Command and Option..." option on any pivot tables when I perform a right-click.

I need this info because my parameters are incorrect based on the response I receive when clicking the 'initialize' button when running OLAPDemoGroup.vbg.

 

[Hugues Perron]

Hi,

As far as I know, the connection string should be the same for both Project
Server 2002 and 2003. The connection string should look like this one :

Provider=sqloledb;Data source=ServerName;Initial
Catalog=ProjectServer;Integrated Security=SSPI

Just change the "Data source" and the "Initial catalog" to suit your
environemnt

Also, I've noticed that when running the example on the same computer where
is installed the Analysis service, it does not always run. You could try
running on a remote computer

Hope this helps.

Hugues

In a recent posting by Hughes he stated to use some code from the Project

Server Experts site that he developed to add weeks as a time dimension to
the OLAP Cube.

Can anyone tell me how to get the connection string in Project Server

2003? The info from Hughes posting I would assume is for PS2002 since I
don't see the "Command and Option..." option on any pivot tables when I
perform a right-click.

I need this info because my parameters are incorrect based on the response

I receive when clicking the 'initialize' button when running
OLAPDemoGroup.vbg.

 

[Brent99Admin]

Hughes,

Thank you so much for your time and reply. Ironically enough this is all on one machine for testing purposes and using the Sample Data. Therefore running the script remotely is a great idea. Thanks again!