This is the third and last part in a small series on my adventures to get Excel Services working with SQL Server 2005 Analysis Services. In this part we will create and test an Excel sheet.
Part 1 – Preparing the AD for Kerberos
Part 2 – Preparing the MOSS server
Part 3 –  Create and test an Excel sheet
Step 1 – Set permissions
The first thing to do is make sure that your user account has acces to the Analysis Services cube.
Step 2 – Create a data connection file
The first step is to create an ODC file the holds the connection to the Analyses Services cube. In my test environment I used the Microsoft Adventure Works sample. Go to the ‘My Data Sources’ folder in My Documents and double click ‘+Connect to New Data Source’
