ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Using Excel to test connection to IT Analytics cubes
Article ID: 181412
Updated On:
Products
IT Analytics
Issue/Introduction
Resolution
In the example we use Excel 2007 to access SSAS. This is to verify other programs can also access the SSAS.
The client machine must have OLEDB provider for SSAS 2005 installed. You can download the "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider " from the feature pack download page (about half way down) at http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
Input the name of the Microsoft Analysis Server
I am using Windows authentication. You can also input the username in Domain\User format.
Select the IT Analytics database.
After this you can click 'Next' and then finsh it.
You should be able to load the pivot table into the Excel if everywork works correctly.
Attachments
Feedback
Yes
No
Powered by
