Browsing PowerPivot Generated Cubes in SQL Server Management Studio

When publishing Excel Workbooks that contains PowerPivot objects, a real Analysis Services cube is generated on the fly, you don’t believe me?

1. Install the PowerPivot Add-in for Excel 2010 and use it to create a workbook.

2. Publish the workbook to a document library which is marked as a trusted data source (Unlike MOSS 2007, All SharePoint sources are trusted by default in SharePoint 2010 as shown below).

3. Open SQL Server Management Studio, click Connect > Analysis Services and type the URL of the workbook you just published and click Connect.

 

Interesting, eh ?