1307
Chapter 58: Creating and Deploying BI Semantic Models
58
Figure 58-8 shows the fi ltered list of products.FIGURE 58-8
Filtered list of products using slicers.- Expand DimReseller and drag ResellerName to the Report Filter area in the
PivotTable Field List. ResellerName is added as a fi lter on the PivotTable area. Click
the drop-down menu, and select the reseller named A Typical Bike Shop from the
list. The product list, sales amount, and order quantity is fi ltered to refl ect only the
sum of the orders placed by this particular reseller. - You have just created your fi rst BI Semantic Model using PowerPivot Excel add-in.
To save your PowerPivot analysis, click File ➪ Save and provide a name, for example
AWPowerPivot. The PowerPivot analysis is saved as part of the Excel workbook and
can be referred to as a PowerPivot workbook.
Extending a BI Semantic Model with PowerPivot
The SQL Server 2012 PowerPivot Excel add-in introduces new features to extend a basic BI
Semantic Model created in a PowerPivot workbook. These new features include:■ (^) Key Performance Indicators (KPI)
■ (^) Hierarchies
■ (^) Perspectives
c58.indd 1307c58.indd 1307 7/31/2012 10:36:01 AM7/31/2012 10:36:01 AM
http://www.it-ebooks.info