Cubes in Excel
- You can use Excel 2003 which allows user to use pivot tables to flatten the cubes.
- You must install the Office component called Microsoft Query for connecting to SSAS cubes in Excel 2003
- Microsoft Office 2007 fully supports data mining
Cubes in SSRS
- SSRS 2005 has deeply integrated support for generating reports using SSAS cube as a data source
- Visual query design of MDX (Multidimensional Expressions) language
Microsoft clients for SSAS
- Data Analyzer
- SharePoint - Web parts that include data generated from SSRS
- Performance Point Server
You can also develop custom clients
- Report Viewer controls in .NET 2.0 (win/web form)
