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 [...]

Another session I did at PASS addressed data mining. Here are the steps I followed during the demonstration and the view I added to the AdventureWorksDW database: Data Mining for the Rest of Us. You will need access to Analysis Services 2005 (either on your own machine or on your network) and you will need [...]

Q. Is it possible to load ratios at each level of a dimension and avoid cube aggregations? In this case, the components of the ratios are unknown and cannot be decomposed, but the ratios at each level are known. A. Take a look at Richard Tkachuk’s article at http://sqlserveranalysisservices.com/OLAPPapers/Loading%20Aggregate%20Data%20in%20AS2005v2.htm. The first part of this article [...]