1306
Part IX: Business Intelligence
- Select New Worksheet and Click OK. A new worksheet opens in the Excel window
with a PivotTable connected to the in-memory BI Semantic Model. The PivotTable
Field list displays on the right with the four dimension tables and the single fact
table selected. Notice that you are working in the Excel environment. - To interact with the data, expand FactResellerSales, and drag SalesAmount and
OrderQuantity to the Values area in the PivotTable Field List. The aggregated
SalesAmount and OrderQuantity displays. - To slice the data further, expand DimProduct, and drag EnglishProductName to the
Row Labels of the PivotTable Field List. The data is instantaneously broken down by
each product in the list, as shown in Figure 58-7.
FIGURE 58-7
Data sliced by products.- To analyze the data in an organized way, you can add fi lters and slicers. Expand
DimProductCategory and drag EnglishProductCategoryName to the Slicers Vertical
area in the PivotTable Field List. - Expand DimProductSubcategory and drag EnglishProductSubcategoryName to the
Slicers Vertical area in the PivotTable Field List, below EnglishProductCategoryName. - Click Accessories in the EnglishProductCategoryName slicer. The product list is fi l-
tered and shows only products categorized as Accessories. - Click Helmets in the EnglishProductSubcategoryName slicer. The product list is
fi ltered further and shows only products categorized as Accessories and subcatego-
rized Helmets.
c58.indd 1306c58.indd 1306 7/31/2012 10:36:01 AM7/31/2012 10:36:01 AM
http://www.it-ebooks.info