SQL Server 2005 Analysis Services Step by Step CD光盘

use [SSAS Step by Step DW] --Add Mexico to DimSalesTerritory INSERT INTO [SSAS Step by Step DW].[dbo].[DimSalesTerritory] ([SalesTerritoryKey] ,[SalesTerritoryAlternateKey] ,[SalesTerritoryRegion] ,[SalesTerritoryCountry] ,[SalesTerritoryGroup]) VALUES (12 ,11 ,'Mexico' ,'Mexico' ,'North America') --Add a sales record for Mexico to fact table INSERT INTO [SSAS Step by Step DW].[dbo].[FactResellerSales] ([ProductKey] ,[OrderDateKey] ,[DueDateKey] ,[ShipDateKey] ,[ResellerKey] ,[EmployeeKey] ,[PromotionKey] ,[CurrencyKey] ,[SalesTerritoryKey] ,[SalesOrderNumber] ,[SalesOrderLineNumber] ,[RevisionNumber] ,[OrderQuantity] ,[UnitPrice] ,[ExtendedAmount] ,[UnitPriceDiscountPct] ,[DiscountAmount] ,[ProductStandardCost] ,[TotalProductCost] ,[SalesAmount] ,[TaxAmt] ,[Freight] ,[CarrierTrackingNumber] ,[CustomerPONumber]) VALUES (577 ,1097 ,1099 ,1098 ,104 ,295 ,1 ,61 ,12 ,'SO71953' ,1 ,1 ,1 ,380.000 ,380.000 ,0 ,0 ,360.9428 ,360.9428 ,380.0000 ,28.0000 ,17.84496 ,'C08-5212-9B' ,'PO5432266015') --Add a sales record for Australia to fact table INSERT INTO [SSAS Step by Step DW].[dbo].[FactResellerSales] ([ProductKey] ,[OrderDateKey] ,[DueDateKey] ,[ShipDateKey] ,[ResellerKey] ,[EmployeeKey] ,[PromotionKey] ,[CurrencyKey] ,[SalesTerritoryKey] ,[SalesOrderNumber] ,[SalesOrderLineNumber] ,[RevisionNumber] ,[OrderQuantity] ,[UnitPrice] ,[ExtendedAmount] ,[UnitPriceDiscountPct] ,[DiscountAmount] ,[ProductStandardCost] ,[TotalProductCost] ,[SalesAmount] ,[TaxAmt] ,[Freight] ,[CarrierTrackingNumber] ,[CustomerPONumber]) VALUES (577 ,1097 ,1099 ,1098 ,104 ,295 ,1 ,6 ,9 ,'SO71954' ,1 ,1 ,1 ,380.000 ,380.000 ,0 ,0 ,360.9428 ,360.9428 ,380.0000 ,72.0000 ,17.84496 ,'C08-5333-8A' ,'PO6922289118')