Monday, December 3, 2007

BI (4) Client tools for end users

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)
blog comments powered by Disqus