SSAS Tabular Mode – Installing the Sample Code

Download the sample file

You can find the sample code here. Download the file and extract the folder AdventureWorks DW PowerPivot CTP3

Creating a Tabular Database from XSLX (PowerPivot) File

SSAS "Denali" allows building BI solutions quickly with minimum coding. One of the ways to implement that is creating an Excel 2010 PowerPivot file and importing it to the SSAS (in Tabular Mode). The SSAS Server creates a database automatically.

More information about PowerPivot, including demos can be found at www.powerpivot.com. This short video PowerPivot Retail Sales Analysis Example might be useful too.

Let's see how it works.

Normal 0 false false false EN-US X-NONE HE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Arial; mso-bidi-theme-font:minor-bidi;}

Name the new Database

Right click on the new database (refresh the db list if necessary) , select Browse.

This is it. The db is ready for analysis.

Add a new calculated Member

Users can easily add Calculated Members

Please notice this is a temporary Calculated Member which doesn't saved anywhere. To create a new measure you'll have to add it to model using Visual Studio.