Saturday, November 02, 2013

Cant find Microsoft.AnalysisServices.AdomdClient in Add Reference window


I was working on SSAS Cube programmatically ( C#), the other night and I realized in Visual Studio required reference for SSAS Classes doesn’t come by default in Add Reference window.



They have to be located by browsing to their location
  
1)      To add Microsoft.AnalysisServices.dll
Browse to  C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.AnalysisServices.dll

2)    To add Microsoft.AnalysisServices.AdomdClient
Browse to  C:\Program Files\Microsoft.NET\ADOMD.NET\100\Microsoft.AnalysisServices.AdomdClient.dll