Hi Ashok,

You could consider the Excel 2002/2003 Add-in for SQL Server Analysis
Services. Version 1.5 supports some AS 2005 features:

http://www.microsoft.com/downloads/d...AE82128-9F21-4
75D-88A4-4B6E6C069FF0&displaylang=en

With the Excel Add-in for Analysis Services, individual users can manage
the reporting cycle from beginning to end and eliminate the need to cut
and paste data from multiple systems.

Access: Easily create and maintain live data connections to multiple
Analysis Services cubes, ensuring data consistency and integrity, and
combine data from multiple sources into a single report.

Analyze: Conduct detailed analysis using native Excel capabilities.
Extend the richness of analysis through “what if” and drill through
capabilities.

Author: Easily personalize and refresh report layouts. Minimize end user
training and reduce reliance on IT due to Excel’s popularity and ease of
use.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***