How to access second OLAP cube via Access?

[Stephen.black]

We have built several cubes on a production server based on various
data from our stage server. The cubes are fine and can be accessed from
the views on all Project Server Servers with no issues. Data is there
and looks fine.

We need to hit these secondary OLAP cubes via Access for some
additional reporting. I am sure this is possible but I have a very
limited skillset in SQL and dB. Can someone direct me to some
instructions on how to configure the ODBC on Access to refrence this
new data? We are able to access the default cube but not sure how to
modify that connection to use the new olap cube.

 

[Mike]

Stephen

You can use these steps to connect via Excel. I am sure Acces will be
similar:

Select Data!Import External Data|New Database Query
Select Olap Cubes tab
Select New Data Source
Enter data source name
Select Microsoft OLE DB Provider for OLAP Services
Click Connect
Enter user ID and password
Select Cube - e.g. MSP_Portfolio_Analyser - then ok
Build Pivot table
save spreadsheet

regards

Mike