报表服务入门（实验5）创建共享数据集

SELECT

       st.SalesTerritoryGroup,

       st.SalesTerritoryCountry,

       r.BusinessType,

       d.CalendarYear,

       SUM(s.SalesAmount) SalesAmount

FROM

       FactResellerSales s

       JOIN DimReseller r on r.ResellerKey=s.ResellerKey

       JOIN DimDate d on d.DateKey=s.OrderDateKey

       JOIN DimSalesTerritory st on st.SalesTerritoryKey=s.SalesTerritoryKey

WHERE

       d.CalendarYear=‘2008‘

GROUP BY

       st.SalesTerritoryGroup,

       st.SalesTerritoryCountry,

       r.BusinessType,

       d.CalendarYear