a00914d1-6ac0-4eae-afaa-a5e84e754e58 . AdventureWorks2012 true QmEvtm671whyw2kZhSr/xw== false false false b6260d74-8083-4402-9ada-a5e84e81c347 bdce0142-38de-49e6-9c85-a5e84e813add 2 AccountNumber AccountNumber varchar(10) AccountNumber varchar varchar(10) 10 0 0 true true false true false None 1 false false 8d6aa16a-23aa-45d8-b65e-a5e84e81c577 bdce0142-38de-49e6-9c85-a5e84e813add 4 CustomerID CustomerID int CustomerID int int 0 0 0 true true false true false None 2 false false 0adbaec7-97d9-44ca-88be-a5e84e81c5c7 bdce0142-38de-49e6-9c85-a5e84e813add 6 ModifiedDate ModifiedDate datetime ModifiedDate datetime datetime 0 0 0 true true false true false None 3 false false 65cbf870-3e5a-4cd0-86d6-a5e84e81c5c8 bdce0142-38de-49e6-9c85-a5e84e813add 8 PersonID PersonID int PersonID int int 0 0 0 true true false true false None 4 false false 1634b870-8533-45c1-a347-a5e84e81c5c9 bdce0142-38de-49e6-9c85-a5e84e813add 10 rowguid rowguid uniqueidentifier rowguid uniqueidentifier uniqueidentifier 0 0 0 true true false true false None 5 false false f267e8e0-e6a8-4c11-9476-a5e84e81c5ca bdce0142-38de-49e6-9c85-a5e84e813add 12 StoreID StoreID int StoreID int int 0 0 0 true true false true false None 6 false false 090da991-8c9d-4276-84be-a5e84e81c5ef bdce0142-38de-49e6-9c85-a5e84e813add 14 TerritoryID TerritoryID int TerritoryID int int 0 0 0 true true false true false None 7 false false df5c9283-2c57-4ee4-a0f1-a5e84e81c68f bdce0142-38de-49e6-9c85-a5e84e813add 15 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false a663ebf5-8605-4b8c-8e2d-a5e84e81c690 bdce0142-38de-49e6-9c85-a5e84e813add 16 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false e372c934-885e-4b51-b424-a5e84e81c691 bdce0142-38de-49e6-9c85-a5e84e813add 17 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 28282af7-70da-4dac-8c3b-a5e84e81c692 bdce0142-38de-49e6-9c85-a5e84e813add 18 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 632ff5e9-cb72-4695-8bd8-a5e84e887d18 12db7eab-646a-425b-9bb4-a5e84e887cf0 2 AdditionalContactInfo AdditionalContactInfo xml AdditionalContactInfo xml xml 0 0 0 true true false true false None 1 false false 3e63df33-f643-40ea-b8fc-a5e84e887d19 12db7eab-646a-425b-9bb4-a5e84e887cf0 4 BusinessEntityID BusinessEntityID int BusinessEntityID int int 0 0 0 true true false true false None 2 false false bacf1184-4389-4e61-b848-a5e84e887d1a 12db7eab-646a-425b-9bb4-a5e84e887cf0 6 Demographics Demographics xml Demographics xml xml 0 0 0 true true false true false None 3 false false e6905271-051f-4af6-ab24-a5e84e887d40 12db7eab-646a-425b-9bb4-a5e84e887cf0 8 EmailPromotion EmailPromotion int EmailPromotion int int 0 0 0 true true false true false None 4 false false 9ca2268f-fe09-4e88-b0d5-a5e84e887d68 12db7eab-646a-425b-9bb4-a5e84e887cf0 10 FirstName FirstName nvarchar(50) FirstName nvarchar nvarchar(50) 50 0 0 true true false true false None 5 false false 0f8d7b9a-99dd-4e9a-b999-a5e84e887d69 12db7eab-646a-425b-9bb4-a5e84e887cf0 12 LastName LastName nvarchar(50) LastName nvarchar nvarchar(50) 50 0 0 true true false true false None 6 false false b86c551b-5116-4aab-a876-a5e84e887d6a 12db7eab-646a-425b-9bb4-a5e84e887cf0 14 MiddleName MiddleName nvarchar(50) MiddleName nvarchar nvarchar(50) 50 0 0 true true false true false None 7 false false fc534e9e-3122-4558-88a2-a5e84e887d6b 12db7eab-646a-425b-9bb4-a5e84e887cf0 16 ModifiedDate ModifiedDate datetime ModifiedDate datetime datetime 0 0 0 true true false true false None 8 false false 4a46a9c5-d5f8-44c2-8496-a5e84e887d6c 12db7eab-646a-425b-9bb4-a5e84e887cf0 18 NameStyle NameStyle bit NameStyle bit bit 0 0 0 true true false true false None 9 false false 7d5d475f-543a-48f5-9714-a5e84e887d90 12db7eab-646a-425b-9bb4-a5e84e887cf0 20 PersonType PersonType nchar(2) PersonType nchar nchar(2) 2 0 0 true true false true false None 10 false false 852ab96a-7e6d-433d-a604-a5e84e887d91 12db7eab-646a-425b-9bb4-a5e84e887cf0 22 rowguid rowguid uniqueidentifier rowguid uniqueidentifier uniqueidentifier 0 0 0 true true false true false None 11 false false 34956e6f-767c-4d5e-aba5-a5e84e887d92 12db7eab-646a-425b-9bb4-a5e84e887cf0 24 Suffix Suffix nvarchar(10) Suffix nvarchar nvarchar(10) 10 0 0 true true false true false None 12 false false 5505c6d4-42cd-40eb-9c77-a5e84e887d93 12db7eab-646a-425b-9bb4-a5e84e887cf0 26 Title Title nvarchar(8) Title nvarchar nvarchar(8) 8 0 0 true true false true false None 13 false false 9748a846-356c-4f73-84d2-a5e84e887d94 12db7eab-646a-425b-9bb4-a5e84e887cf0 27 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 6071a19b-f57f-4d14-81a8-a5e84e887d95 12db7eab-646a-425b-9bb4-a5e84e887cf0 28 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false ea721fe7-1b8e-44b1-965b-a5e84e887d96 12db7eab-646a-425b-9bb4-a5e84e887cf0 29 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 9e8947ba-5c35-4078-9c68-a5e84e887d97 12db7eab-646a-425b-9bb4-a5e84e887cf0 30 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 12db7eab-646a-425b-9bb4-a5e84e887cf0 32 CustomerID CustomerID int CustomerID int int 0 0 0 true true false true true None 14 false false 066e8367-88ac-4246-9a2c-a5e84f74159b 12db7eab-646a-425b-9bb4-a5e84e887cf0 33 CustomerFullName CustomerFullName varchar(250) CustomerFullName varchar varchar(250) 250 0 0 true true false true true None 15 false false 98e5e125-bd17-446b-a2fc-a5e84e8ff21c fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 2 AccountNumber AccountNumber nvarchar(15) AccountNumber nvarchar nvarchar(15) 15 0 0 true true false true false None 1 false false fe78abf8-a1a4-4f20-a3f9-a5e84e8ff21d fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 4 BillToAddressID BillToAddressID int BillToAddressID int int 0 0 0 true true false true false None 2 false false a2226e1e-38bc-4f9b-a911-a5e84e8ff21e fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 6 Comment Comment nvarchar(128) Comment nvarchar nvarchar(128) 128 0 0 true true false true false None 3 false false 3fc91483-635f-4d7b-8464-a5e84e8ff21f fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 8 CreditCardApprovalCode CreditCardApprovalCode varchar(15) CreditCardApprovalCode varchar varchar(15) 15 0 0 true true false true false None 4 false false 17dff912-8203-48df-9414-a5e84e8ff220 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 10 CreditCardID CreditCardID int CreditCardID int int 0 0 0 true true false true false None 5 false false 0d08d3d2-e30a-4d46-8941-a5e84e8ff221 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 12 CurrencyRateID CurrencyRateID int CurrencyRateID int int 0 0 0 true true false true false None 6 false false 9b6f0dc0-e692-48fb-9e70-a5e84e8ff244 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 14 CustomerID CustomerID int CustomerID int int 0 0 0 true true false true false None 7 false false 06a6a286-1fbb-41ce-8893-a5e84e8ff245 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 16 DueDate DueDate datetime DueDate datetime datetime 0 0 0 true true false true false None 8 false false 7082e03a-a9df-4f39-be1c-a5e84e8ff294 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 18 Freight Freight decimal(38,4) Freight decimal money 0 4 38 true true false true false None 9 false false eddb7c00-dd62-43ca-b4a8-a5e84e8ff2bc fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 20 ModifiedDate ModifiedDate datetime ModifiedDate datetime datetime 0 0 0 true true false true false None 10 false false fcf275f3-e623-437e-9fc1-a5e84e8ff2e4 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 22 OnlineOrderFlag OnlineOrderFlag bit OnlineOrderFlag bit bit 0 0 0 true true false true false None 11 false false 20439883-a286-43f5-8feb-a5e84e8ff2e5 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 24 OrderDate OrderDate datetime OrderDate datetime datetime 0 0 0 true true false true false None 12 false false 2bc089c4-a3a3-4203-8e97-a5e84e8ff2e6 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 26 PurchaseOrderNumber PurchaseOrderNumber nvarchar(25) PurchaseOrderNumber nvarchar nvarchar(25) 25 0 0 true true false true false None 13 false false 7f6310a3-a2db-47e5-9a90-a5e84e8ff2e7 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 28 RevisionNumber RevisionNumber tinyint RevisionNumber tinyint tinyint 0 0 0 true true false true false None 14 false false fac5fe75-0a22-49df-bc6a-a5e84e8ff2e8 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 30 rowguid rowguid uniqueidentifier rowguid uniqueidentifier uniqueidentifier 0 0 0 true true false true false None 15 false false fc569c5d-b4de-4aaf-8a25-a5e84e8ff2e9 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 32 SalesOrderID SalesOrderID int SalesOrderID int int 0 0 0 true true false true false None 16 false false 45be529d-1692-43ba-88c9-a5e84e8ff30c fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 34 SalesOrderNumber SalesOrderNumber nvarchar(25) SalesOrderNumber nvarchar nvarchar(25) 25 0 0 true true false true false None 17 false false f705fc44-52e8-450a-881b-a5e84e8ff30d fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 36 SalesPersonID SalesPersonID int SalesPersonID int int 0 0 0 true true false true false None 18 false false 325f8505-cf08-4662-8f5e-a5e84e8ff30e fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 38 ShipDate ShipDate datetime ShipDate datetime datetime 0 0 0 true true false true false None 19 false false 7c49f7e0-7e76-42f3-a16e-a5e84e8ff30f fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 40 ShipMethodID ShipMethodID int ShipMethodID int int 0 0 0 true true false true false None 20 false false 56c11453-d8ea-4976-b868-a5e84e8ff310 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 42 ShipToAddressID ShipToAddressID int ShipToAddressID int int 0 0 0 true true false true false None 21 false false 8164a39b-e0c8-4e7b-857d-a5e84e8ff311 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 44 Status Status tinyint Status tinyint tinyint 0 0 0 true true false true false None 22 false false 9d19eb28-0ae7-4fb4-aa7a-a5e84e8ff312 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 46 SubTotal SubTotal decimal(38,4) SubTotal decimal money 0 4 38 true true false true false None 23 false false 6dda19f9-1132-432a-b209-a5e84e8ff313 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 48 TaxAmt TaxAmt decimal(38,4) TaxAmt decimal money 0 4 38 true true false true false None 24 false false e21c59ed-dc08-4353-b176-a5e84e8ff314 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 50 TerritoryID TerritoryID int TerritoryID int int 0 0 0 true true false true false None 25 false false 67a09dc6-f110-469d-b3a5-a5e84e8ff334 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 52 TestColumn TestColumn varchar(50) TestColumn varchar varchar(50) 50 0 0 true true false true false None 26 false false 3b74c951-b3a9-4f26-b38c-a5e84e8ff335 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 54 TestColumn2 TestColumn2 varchar(50) TestColumn2 varchar varchar(50) 50 0 0 true true false true false None 27 false false b16e08bd-01cd-48cb-bd08-a5e84e8ff336 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 56 TotalDue TotalDue decimal(38,4) TotalDue decimal money 0 4 38 true true false true false None 28 false false 1c87537a-8f67-4ac6-8731-a5e84e8ff337 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 57 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false b4bb0ffd-6075-45d4-9b2c-a5e84e8ff338 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 58 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false eb08aa5f-5cb5-4b20-98a3-a5e84e8ff339 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 59 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false e64aaaff-dbf5-490d-9dff-a5e84e8ff33a fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 60 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 2fb5dbe9-d849-47f5-9194-a5e854abe983 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 62 CustomerKey CustomerKey bigint CustomerKey bigint bigint 0 0 0 true true false true true None 29 false false ca00638d-d0c7-4da6-b701-a5e84e904105 7db58a4d-6d38-48f2-8638-a5e84e9040b5 2 CarrierTrackingNumber CarrierTrackingNumber nvarchar(25) CarrierTrackingNumber nvarchar nvarchar(25) 25 0 0 true true false true false None 1 false false ca8bd5a5-7531-4830-a909-a5e84e904106 7db58a4d-6d38-48f2-8638-a5e84e9040b5 4 LineTotal LineTotal decimal(38,6) LineTotal decimal numeric(38,6) 0 6 38 true true false true false None 2 false false 219a93c0-d48d-48d3-a2ce-a5e84e904107 7db58a4d-6d38-48f2-8638-a5e84e9040b5 6 ModifiedDate ModifiedDate datetime ModifiedDate datetime datetime 0 0 0 true true false true false None 3 false false fab606ba-ae69-47c2-93ba-a5e84e904108 7db58a4d-6d38-48f2-8638-a5e84e9040b5 8 OrderQty OrderQty smallint OrderQty smallint smallint 0 0 0 true true false true false None 4 false false 502a986b-962d-4059-b27e-a5e84e904109 7db58a4d-6d38-48f2-8638-a5e84e9040b5 10 ProductID ProductID int ProductID int int 0 0 0 true true false true false None 5 false false ada0fd11-a6d0-49c3-b8fe-a5e84e90410a 7db58a4d-6d38-48f2-8638-a5e84e9040b5 12 rowguid rowguid uniqueidentifier rowguid uniqueidentifier uniqueidentifier 0 0 0 true true false true false None 6 false false 88a7b228-4d29-46a2-a254-a5e84e90410b 7db58a4d-6d38-48f2-8638-a5e84e9040b5 14 SalesOrderDetailID SalesOrderDetailID int SalesOrderDetailID int int 0 0 0 true true false true false None 7 false false 10f3471c-2a63-45a9-bc25-a5e84e90410c 7db58a4d-6d38-48f2-8638-a5e84e9040b5 16 SalesOrderID SalesOrderID int SalesOrderID int int 0 0 0 true true false true false None 8 false false d9675b6f-48e4-4482-99e8-a5e84e90412d 7db58a4d-6d38-48f2-8638-a5e84e9040b5 18 SpecialOfferID SpecialOfferID int SpecialOfferID int int 0 0 0 true true false true false None 9 false false dc8e915a-d4c4-4e30-a55a-a5e84e90412e 7db58a4d-6d38-48f2-8638-a5e84e9040b5 20 UnitPrice UnitPrice decimal(38,4) UnitPrice decimal money 0 4 38 true true false true false None 10 false false 024aa44e-aed9-4a55-9a11-a5e84e90412f 7db58a4d-6d38-48f2-8638-a5e84e9040b5 22 UnitPriceDiscount UnitPriceDiscount decimal(38,4) UnitPriceDiscount decimal money 0 4 38 true true false true false None 11 false false ad46ff59-f964-4f27-8a8d-a5e84e904130 7db58a4d-6d38-48f2-8638-a5e84e9040b5 23 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false f90a88c7-2560-4c4e-ba16-a5e84e904131 7db58a4d-6d38-48f2-8638-a5e84e9040b5 24 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false c2c3de70-76e8-4578-bebc-a5e84e904132 7db58a4d-6d38-48f2-8638-a5e84e9040b5 25 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false b57ec0c0-3644-4182-8e8f-a5e84e904133 7db58a4d-6d38-48f2-8638-a5e84e9040b5 26 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false 23f187e8-0b15-4a6b-a150-a5e84eaa8d98 7db58a4d-6d38-48f2-8638-a5e84e9040b5 28 CustomerID CustomerID int CustomerID int int 0 0 0 true true false true true None 13 false false d3404425-4529-4638-87bd-a5e84eaf0f91 7db58a4d-6d38-48f2-8638-a5e84e9040b5 30 CustomerKey CustomerKey bigint CustomerKey bigint bigint 0 0 0 true true false true true None 14 false false e0ffeaa1-c1aa-465e-9fb9-a5e84ebe21c1 7db58a4d-6d38-48f2-8638-a5e84e9040b5 32 OrderDate OrderDate datetime OrderDate datetime datetime 0 0 0 true true false true true None 12 false false d5358dd5-93bd-440b-bebb-a5e850638075 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 1 DW_Id DW_Id bigint DW_Id bigint bigint 0 0 0 true true false true true None 0 DW_Id false false 0cdf07f5-da7b-4d83-9f95-a5e85063809d bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 2 DW_Batch DW_Batch bigint DW_Batch bigint bigint 0 0 0 true true false true true None 0 DW_Batch false false d75387d7-4bfb-498c-8bb1-a5e85063809e bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 3 DW_SourceCode DW_SourceCode varchar(15) DW_SourceCode varchar varchar(15) 15 0 0 true true false true true None 0 DW_SourceCode false false 584f5a56-e935-4bcf-a70e-a5e85063809f bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 4 DW_TimeStamp DW_TimeStamp datetime DW_TimeStamp datetime datetime 0 0 0 true true false true true None 0 DW_TimeStamp false false ac3dc771-efa0-42a5-959b-a5e850638115 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 5 CustomerKey CustomerKey bigint CustomerKey bigint bigint 0 0 0 true true false true true None 1 Aggregate_Field false false 36f5cfde-f5fc-4b80-b4ed-a5e8506381b5 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 6 TotalSales TotalSales decimal(38,6) TotalSales decimal decimal(38,6) 0 6 38 true true false true true Sum 3 Aggregate_Field false false 04432abd-dd8f-4cff-bb48-a5e8506aca08 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 8 CustomerFullName CustomerFullName varchar(250) CustomerFullName varchar varchar(250) 250 0 0 true true false true true None 2 false false 3aafdbcf-8378-4ea7-9dae-a5e854ef0b7e bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 9 FirstOrder FirstOrder datetime FirstOrder datetime datetime 0 0 0 true true false true true Min 4 Aggregate_Field false false 67aa9c4c-5236-486a-ab40-a5e854ef0c96 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 10 LastOrder LastOrder datetime LastOrder datetime datetime 0 0 0 true true false true true Max 5 Aggregate_Field false false 50685953-cc5c-433e-a5d1-a5e854fcf042 bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 12 SalesCount SalesCount int SalesCount int int 0 0 0 true true false true true None 6 false false bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 99220842-31e1-4333-89cf-a5e84e122e85 CustomerSales CustomerSales CustomerSales false Aggregation AsProject AsProject false false true true false false true false bdce0142-38de-49e6-9c85-a5e84e813add a00914d1-6ac0-4eae-afaa-a5e84e754e58 Customer Sales AW_Sales_Customer Customer true DataSource AsProject AsProject false false true true false false true false 12db7eab-646a-425b-9bb4-a5e84e887cf0 a00914d1-6ac0-4eae-afaa-a5e84e754e58 Person Person AW_Person_Person Person true DataSource AsProject AsProject false false true true false false true false 7db58a4d-6d38-48f2-8638-a5e84e9040b5 a00914d1-6ac0-4eae-afaa-a5e84e754e58 SalesOrderDetail Sales AW_Sales_SalesOrderDetail SalesOrderDetail true DataSource AsProject AsProject false false true true false false true false fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 a00914d1-6ac0-4eae-afaa-a5e84e754e58 SalesOrderHeader Sales AW_Sales_SalesOrderHeader SalesOrderHeader true DataSource AsProject AsProject false false true true false false true false 8b85df9f-034f-4a9a-b7f6-a5e84e9a0c82 bdce0142-38de-49e6-9c85-a5e84e813add 12db7eab-646a-425b-9bb4-a5e84e887cf0 AW_Sales_Customer false Relation false a24599df-dc62-43f2-8590-a5e84eeb4f1b fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 7db58a4d-6d38-48f2-8638-a5e84e9040b5 AW_Sales_SalesOrderHeader false Relation false de420187-de7a-475c-a0d7-a5e84f7da53f 066e8367-88ac-4246-9a2c-a5e84f74159b 1 Custom [FirstName] + ' ' + [LastName] false d0dcf649-c4e5-4c28-a655-a5e854b69062 9a5e690a-4bba-48d8-b35c-044fdf279495 9b6f0dc0-e692-48fb-9e70-a5e84e8ff244 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 1 Equal false 7f391e8d-278d-47fb-97ab-a5e850747324 47357f66-e9ba-4f20-a173-07c63737f785 ac3dc771-efa0-42a5-959b-a5e850638115 9748a846-356c-4f73-84d2-a5e84e887d94 1 Equal false eae72027-d929-4b97-9753-a5e84e9d601e c5eb760d-df93-4a90-97b8-0b8eb04ac855 3e63df33-f643-40ea-b8fc-a5e84e887d19 65cbf870-3e5a-4cd0-86d6-a5e84e81c5c8 1 Equal false d017cd58-7d33-4b47-968f-a5e85504606e 235648c4-af99-4585-9201-170021f81059 ac3dc771-efa0-42a5-959b-a5e850638115 2fb5dbe9-d849-47f5-9194-a5e854abe983 1 Equal false bf7b3bf5-1d23-4817-8ded-a5e84eff7fae ffee7a8d-3ebe-4f9f-8ec8-e4640f20829d 23f187e8-0b15-4a6b-a150-a5e84eaa8d98 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 1 Equal false 9811afc2-9ced-48ac-a3d1-a5e84dd0edf8 ac805570-ddb7-474c-bee1-a5e84dd0e970 Default FailPackage 1 1 1 true ExecutionNumber 1 true true true true ac805570-ddb7-474c-bee1-a5e84dd0e970 Aggregate Demo true Normal 0 true false false 16.7.3.32 16.2.3.64 0 9999-12-31T23:59:59.997-08:00 Relation true false true yO1oSUC+GHzCFjbUpzpD2k2k1MeXwwTFWLGXwF6hnTRqkcEW4pOKXAisI7jdOljJEVFp7SFLarlP4MDGHUo5p18+0lth2iIFJCrbEmYbHW+ZMaNwCrCN95WqblnbcLXQhMizCMH/kJA1YRwr2z3LALLCuPLarFU7ePA8YllOYVoYWQ5JKNhCOVvNBKt6O/5E+Ml1Sn086LtYaxC8p7O42VS6fupqID83exFGsVaaALlhKzcffMS7jM2GrKPc/qNqzohWctlE6eEySXEYlbRUV0Y1adrguFiD3gZLdAftO3zmtX4Kv/y93xCvvNbv/5Cl false Error false false false Automatic 3 AFY/BwvvULs5r9GNTvbLa+6jfDhYzCtMtRTr/zLYOMmBAE3jma9Bz6q7eTf4X0lC false false fc1a2bac-662f-4cdd-b3b9-a5e84e122e0d ac805570-ddb7-474c-bee1-a5e84dd0e970 AggregateDemo false 1 99220842-31e1-4333-89cf-a5e84e122e85 fc1a2bac-662f-4cdd-b3b9-a5e84e122e0d 00000000-0000-0000-0000-000000000000 false AggDem . AggDem true QmEvtm671whyw2kZhSr/xw== false 1800 15 As_Parent 300000 Not_Set a00914d1-6ac0-4eae-afaa-a5e84e754e58 fc1a2bac-662f-4cdd-b3b9-a5e84e122e0d 00000000-0000-0000-0000-000000000000 false AW false false 100 15 As_Parent true Default 0 Fail_Stop_Execution 62799fe6-6456-4c90-b75c-a5e84e9a0d4a 8b85df9f-034f-4a9a-b7f6-a5e84e9a0c82 65cbf870-3e5a-4cd0-86d6-a5e84e81c5c8 3e63df33-f643-40ea-b8fc-a5e84e887d19 e4f2dcac-3dff-4e10-a0da-a5e84eeb4f6b a24599df-dc62-43f2-8590-a5e84eeb4f1b fc569c5d-b4de-4aaf-8a25-a5e84e8ff2e9 10f3471c-2a63-45a9-bc25-a5e84e90410c c5eb760d-df93-4a90-97b8-0b8eb04ac855 8d6aa16a-23aa-45d8-b65e-a5e84e81c577 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 CustomerID MAX false Group_by 1 ffee7a8d-3ebe-4f9f-8ec8-e4640f20829d 9748a846-356c-4f73-84d2-a5e84e887d94 d3404425-4529-4638-87bd-a5e84eaf0f91 DW_Id MAX false Group_by 1 9a5e690a-4bba-48d8-b35c-044fdf279495 9748a846-356c-4f73-84d2-a5e84e887d94 2fb5dbe9-d849-47f5-9194-a5e854abe983 DW_Id MAX false Group_by 1 4da69108-b30a-456d-a563-5b61aa816c7c 9b6f0dc0-e692-48fb-9e70-a5e84e8ff244 23f187e8-0b15-4a6b-a150-a5e84eaa8d98 CustomerID MAX false Group_by 1 2714f8c1-45df-4d92-ad60-0723bba9b353 20439883-a286-43f5-8feb-a5e84e8ff2e5 e0ffeaa1-c1aa-465e-9fb9-a5e84ebe21c1 OrderDate MAX false Group_by 1 235648c4-af99-4585-9201-170021f81059 fc569c5d-b4de-4aaf-8a25-a5e84e8ff2e9 50685953-cc5c-433e-a5d1-a5e854fcf042 SalesOrderID COUNT false Group_by 1 47357f66-e9ba-4f20-a173-07c63737f785 066e8367-88ac-4246-9a2c-a5e84f74159b 04432abd-dd8f-4cff-bb48-a5e8506aca08 CustomerFullName MAX false Group_by 1 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 2fb5dbe9-d849-47f5-9194-a5e854abe983 false false false false false 23f187e8-0b15-4a6b-a150-a5e84eaa8d98 d3404425-4529-4638-87bd-a5e84eaf0f91 false false false false false e0ffeaa1-c1aa-465e-9fb9-a5e84ebe21c1 04432abd-dd8f-4cff-bb48-a5e8506aca08 50685953-cc5c-433e-a5d1-a5e854fcf042 false false false false false fdd5dc97-7480-4fa9-bb82-a5e84e9d728f bdce0142-38de-49e6-9c85-a5e84e813add AutoIndex NonClustered true false false 8845dea7-825e-47a5-8661-a5e84eff804e 12db7eab-646a-425b-9bb4-a5e84e887cf0 AutoIndex NonClustered true false false d237a0bc-e8f3-4302-97f3-a5e850747554 12db7eab-646a-425b-9bb4-a5e84e887cf0 AutoIndex1 NonClustered true false false 467e28b8-dc8d-454e-841e-a5e8550462ee fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 AutoIndex1 NonClustered true false false a8ec8342-cd6f-4695-850f-a5e84eeb50fb fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 AutoIndex NonClustered true false false a54f0569-6a36-4bfc-a726-a5e84e9d732f fdd5dc97-7480-4fa9-bb82-a5e84e9d728f 65cbf870-3e5a-4cd0-86d6-a5e84e81c5c8 Ascending 0 false 48031ddd-598d-48db-ba46-a5e8507475f4 d237a0bc-e8f3-4302-97f3-a5e850747554 9748a846-356c-4f73-84d2-a5e84e887d94 Ascending 0 false 27bbdba0-3e25-4109-a7fa-a5e84eeb50fc a8ec8342-cd6f-4695-850f-a5e84eeb50fb fc569c5d-b4de-4aaf-8a25-a5e84e8ff2e9 Ascending 0 false 40c472e1-bc49-4638-b7b7-a5e84eff804f 8845dea7-825e-47a5-8661-a5e84eff804e 8a1399f4-ca4d-4900-8d49-a5e84e9c00d9 Ascending 0 false 48b2dfa8-8c33-4d6c-87d9-a5e855046316 467e28b8-dc8d-454e-841e-a5e8550462ee 2fb5dbe9-d849-47f5-9194-a5e854abe983 Ascending 0 false 98d95b01-d031-4248-8734-020a25f43cf5 bdce0142-38de-49e6-9c85-a5e84e813add Dimension_Table false false false false true true false As_Project false As_Project None false false None false false 100000 193ae0d5-6b3f-431f-a5e9-7ec20fee0072 12db7eab-646a-425b-9bb4-a5e84e887cf0 Dimension_Table false false false false true true false As_Project false As_Project None false false None false false 100000 8a0b3bd9-f07e-4078-a827-378f251f7cb5 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 Dimension_Table false false false false true true false As_Project false As_Project None false false None false false 100000 e5e6137f-d036-4159-a284-bf60de7e9a49 7db58a4d-6d38-48f2-8638-a5e84e9040b5 Dimension_Table false false false false true true false As_Project false As_Project None false false None false false 100000 524e8b01-42c7-4581-88e4-339ff3571d7f bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d Dimension_Table false false false false true true false As_Project false As_Project None false false None false false 100000 485ec7e4-8907-41d0-8e64-6e3261252f9e fdd5dc97-7480-4fa9-bb82-a5e84e9d728f 8d6aa16a-23aa-45d8-b65e-a5e84e81c577 4057fcc2-04ac-42c3-afd8-b099c6811d82 a8ec8342-cd6f-4695-850f-a5e84eeb50fb 9b6f0dc0-e692-48fb-9e70-a5e84e8ff244 ccff414c-9a0f-4ef1-b295-12d8096e43e6 a8ec8342-cd6f-4695-850f-a5e84eeb50fb 20439883-a286-43f5-8feb-a5e84e8ff2e5 15be6948-6c67-4d77-92e1-f44c2692bca5 8845dea7-825e-47a5-8661-a5e84eff804e 9748a846-356c-4f73-84d2-a5e84e887d94 817e6cae-81a9-47b6-adb4-ff24f4622bfe d237a0bc-e8f3-4302-97f3-a5e850747554 066e8367-88ac-4246-9a2c-a5e84f74159b 7a42039a-dca1-49e8-a71d-058e6a5d2f39 467e28b8-dc8d-454e-841e-a5e8550462ee fc569c5d-b4de-4aaf-8a25-a5e84e8ff2e9 29374033-6975-4675-860c-217c8106e55c ac805570-ddb7-474c-bee1-a5e84dd0e970 de420187-de7a-475c-a0d7-a5e84f7da53f 9ca2268f-fe09-4e88-b0d5-a5e84e887d68 [FirstName] 1 1 1 eb61796c-76fa-4083-9002-6b832caac700 ac805570-ddb7-474c-bee1-a5e84dd0e970 de420187-de7a-475c-a0d7-a5e84f7da53f 0f8d7b9a-99dd-4e9a-b999-a5e84e887d69 [LastName] 1 1 2 3dc355b2-ccb1-48f5-b69d-a5e84e122f9d 99220842-31e1-4333-89cf-a5e84e122e85 false 1 1 60 120 62db38f8-e035-4a74-a918-a5e84e813b05 bdce0142-38de-49e6-9c85-a5e84e813add 1 d579858c-8ca1-4851-9556-a5e84e887cf1 12db7eab-646a-425b-9bb4-a5e84e887cf0 2 c3ea0951-1b5e-4342-9fac-a5e84e8ff1f5 fefb869c-b4ae-47f5-85b5-a5e84e8ff1f4 3 8bcf8b18-0401-4611-b4be-a5e84e9040b6 7db58a4d-6d38-48f2-8638-a5e84e9040b5 4 f5662c5f-4b2a-4c4d-a7b1-a5e850637f0e bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 5 e832d315-dbcb-4bab-b6f2-a5e8506381b6 36f5cfde-f5fc-4b80-b4ed-a5e8506381b5 ca8bd5a5-7531-4830-a909-a5e84e904106 None c465c58e-573e-4ad9-9508-a5e850638165 ac3dc771-efa0-42a5-959b-a5e850638115 d3404425-4529-4638-87bd-a5e84eaf0f91 Value 2a951a04-cbfb-47d1-a5fb-a5e854ef0c1e 3aafdbcf-8378-4ea7-9dae-a5e854ef0b7e e0ffeaa1-c1aa-465e-9fb9-a5e84ebe21c1 None ff634185-97b1-40bd-9d1e-a5e854ef0cbe 67aa9c4c-5236-486a-ab40-a5e854ef0c96 e0ffeaa1-c1aa-465e-9fb9-a5e84ebe21c1 None e4a39314-bdc9-4c34-9837-a5e850637ffd bfdd8a3a-bc6e-4f74-8da7-a5e850637f0d 7db58a4d-6d38-48f2-8638-a5e84e9040b5 5c2cb6e3-9cf9-4086-b4a0-a5e84dd0edf9 9811afc2-9ced-48ac-a3d1-a5e84dd0edf8 1