| Analysis Services Data Connections and SharePoint – One Solution to “Connection Cannot Be Made” |
| Written by Stacia Misner |
| Sunday, 27 June 2010 23:14 |
|
Recently I came across a problem with an Analysis Services data connection when I was trying to create a status indicator in SharePoint 2010 (formerly known as a key performance indicator in SharePoint 2007). I had successfully created the data connection in Excel, verified that I could create a PivotTable with it, and then saved the connection to Excel Services as an Office Data Connection (ODC) file. However, when I tried to use the ODC to create a status indicator, the following error displayed:
|
