<Schema xmlns="http://schemas.microsoft.com/ado/2008/09/edm" xmlns:edm_annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:bi="http://schemas.microsoft.com/sqlbi/2010/10/edm/extensions" bi:Version="1.0" Namespace="Sandbox">
<EntityContainer Name="Sandbox">
<Documentation>
<Summary>DescriptionRolePlayingDimensionsDB</Summary>
</Documentation>
<EntitySet Name="DimCustomer" EntityType="Sandbox.DimCustomer">
<Documentation>
<Summary>Description_Dimension_DimCustomer</Summary>
</Documentation>
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimEmployee" EntityType="Sandbox.DimEmployee">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimGeography" EntityType="Sandbox.DimGeography">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimProduct" EntityType="Sandbox.DimProduct">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimProductCategory" EntityType="Sandbox.DimProductCategory">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimProductSubcategory" EntityType="Sandbox.DimProductSubcategory">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimStore" EntityType="Sandbox.DimStore">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="DimTime" EntityType="Sandbox.DimTime">
<bi:EntitySet />
</EntitySet>
<EntitySet Name="FactInternetSales" EntityType="Sandbox.FactInternetSales">
<bi:EntitySet />
</EntitySet>
<AssociationSet Name="DimCustomer_DimGeography_Geography" Association="Sandbox.DimCustomer_DimGeography_Geography">
<End EntitySet="DimCustomer" />
<End EntitySet="DimGeography" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="DimProduct_DimProductSubcategory_Subcategory" Association="Sandbox.DimProduct_DimProductSubcategory_Subcategory">
<End EntitySet="DimProduct" />
<End EntitySet="DimProductSubcategory" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="DimProductSubcategory_DimProductCategory_Category" Association="Sandbox.DimProductSubcategory_DimProductCategory_Category">
<End EntitySet="DimProductSubcategory" />
<End EntitySet="DimProductCategory" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="DimStore_DimGeography_Geography2" Association="Sandbox.DimStore_DimGeography_Geography2">
<End EntitySet="DimStore" />
<End EntitySet="DimGeography" />
<bi:AssociationSet State="Inactive" />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimCustomer_Customer2" Association="Sandbox.FactInternetSales_DimCustomer_Customer2">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimCustomer" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimCustomer_Customer_2" Association="Sandbox.FactInternetSales_DimCustomer_Customer_2">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimCustomer" />
<bi:AssociationSet State="Inactive" />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimTime_Time" Association="Sandbox.FactInternetSales_DimTime_Time">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimTime" />
<bi:AssociationSet State="Inactive" />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimTime_Time_2" Association="Sandbox.FactInternetSales_DimTime_Time_2">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimTime" />
<bi:AssociationSet State="Inactive" />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimTime_Time_3" Association="Sandbox.FactInternetSales_DimTime_Time_3">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimTime" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimStore_Store2" Association="Sandbox.FactInternetSales_DimStore_Store2">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimStore" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimEmployee_Employee" Association="Sandbox.FactInternetSales_DimEmployee_Employee">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimEmployee" />
<bi:AssociationSet />
</AssociationSet>
<AssociationSet Name="FactInternetSales_DimProduct_Product2" Association="Sandbox.FactInternetSales_DimProduct_Product2">
<End EntitySet="FactInternetSales" />
<End EntitySet="DimProduct" />
<bi:AssociationSet />
</AssociationSet>
<bi:EntityContainer Caption="CaptionRolePlayingDimensionsDB" Culture="ja-JP">
<bi:CompareOptions IgnoreCase="true" IgnoreKanaType="true" IgnoreWidth="true" />
</bi:EntityContainer>
</EntityContainer>
<EntityType Name="DimCustomer">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="CustomerKey" Type="Int64" Nullable="false">
<Documentation>
<Summary>Description_Dimension_CustomerKey</Summary>
</Documentation>
<bi:Property Caption="Caption_Dimension_CustomerKey" Hidden="true">
<bi:OrderBy>
<bi:PropertyRef Name="GeographyKey" />
</bi:OrderBy>
</bi:Property>
</Property>
<Property Name="GeographyKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="CustomerAlternateKey" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Title" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property ContextualNameRule="Context" Alignment="Left" Units="money" SortDirection="Ascending" IsRightToLeft="true" DefaultAggregateFunction="Max" />
</Property>
<Property Name="FirstName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="MiddleName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="LastName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="NameStyle" Type="Boolean">
<bi:Property />
</Property>
<Property Name="BirthDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="MaritalStatus" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Suffix" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Gender" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EmailAddress" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="YearlyIncome" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="TotalChildren" Type="Int64">
<bi:Property />
</Property>
<Property Name="NumberChildrenAtHome" Type="Int64">
<bi:Property />
</Property>
<Property Name="EnglishEducation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishEducation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchEducation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EnglishOccupation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishOccupation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchOccupation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="HouseOwnerFlag" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="NumberCarsOwned" Type="Int64">
<bi:Property />
</Property>
<Property Name="AddressLine1" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="AddressLine2" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Phone" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="DateFirstPurchase" Type="DateTime">
<bi:Property />
</Property>
<Property Name="CommuteDistance" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<NavigationProperty Name="Geography" Relationship="Sandbox.DimCustomer_DimGeography_Geography" FromRole="Customer" ToRole="Geography">
<Documentation>
<Summary>DESCRIPTION_RelationshipEnd_Cust_Geog</Summary>
</Documentation>
<bi:NavigationProperty Caption="CAPTION_RelationshipEnd_Cust_Geog" ContextualNameRule="Context" />
</NavigationProperty>
<bi:EntityType Contents="Customers">
<bi:DisplayKey>
<bi:MemberRef Name="Geography" />
<bi:MemberRef Name="Title" />
</bi:DisplayKey>
<bi:DefaultDetails>
<bi:MemberRef Name="Title" />
<bi:MemberRef Name="Geography" />
</bi:DefaultDetails>
<bi:DefaultImage>
<bi:MemberRef Name="Title" />
</bi:DefaultImage>
<bi:SortMembers>
<bi:MemberRef Name="Title" />
</bi:SortMembers>
</bi:EntityType>
</EntityType>
<EntityType Name="DimEmployee">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="EmployeeKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="ParentEmployeeKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="EmployeeNationalIDAlternateKey" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ParentEmployeeNationalIDAlternateKey" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SalesTerritoryKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="FirstName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="LastName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="MiddleName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="NameStyle" Type="Boolean">
<bi:Property />
</Property>
<Property Name="Title" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="HireDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="BirthDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="LoginID" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EmailAddress" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Phone" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="MaritalStatus" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EmergencyContactName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EmergencyContactPhone" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SalariedFlag" Type="Boolean">
<bi:Property />
</Property>
<Property Name="Gender" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="PayFrequency" Type="Int64">
<bi:Property />
</Property>
<Property Name="BaseRate" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="VacationHours" Type="Int64">
<bi:Property />
</Property>
<Property Name="SickLeaveHours" Type="Int64">
<bi:Property />
</Property>
<Property Name="CurrentFlag" Type="Boolean">
<bi:Property />
</Property>
<Property Name="SalesPersonFlag" Type="Boolean">
<bi:Property />
</Property>
<Property Name="DepartmentName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="StartDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="EndDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="Status" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<bi:EntityType />
</EntityType>
<EntityType Name="DimGeography">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="GeographyKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="City" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="StateProvinceCode" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="StateProvinceName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="CountryRegionCode" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EnglishCountryRegionName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishCountryRegionName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchCountryRegionName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="PostalCode" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SalesTerritoryKey" Type="Int64">
<bi:Property />
</Property>
<bi:EntityType />
</EntityType>
<EntityType Name="DimProduct">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="ProductKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="ProductAlternateKey" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ProductSubcategoryKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="WeightUnitMeasureCode" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SizeUnitMeasureCode" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EnglishProductName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishProductName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchProductName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="StandardCost" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="FinishedGoodsFlag" Type="Boolean">
<bi:Property />
</Property>
<Property Name="Color" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SafetyStockLevel" Type="Int64">
<bi:Property />
</Property>
<Property Name="ReorderPoint" Type="Int64">
<bi:Property />
</Property>
<Property Name="ListPrice" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="Size" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SizeRange" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Weight" Type="Double">
<bi:Property />
</Property>
<Property Name="DaysToManufacture" Type="Int64">
<bi:Property />
</Property>
<Property Name="ProductLine" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="DealerPrice" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="Class" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Style" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ModelName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EnglishDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ChineseDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ArabicDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="HebrewDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ThaiDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="StartDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="EndDate" Type="DateTime">
<bi:Property />
</Property>
<Property Name="Status" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<NavigationProperty Name="Subcategory" Relationship="Sandbox.DimProduct_DimProductSubcategory_Subcategory" FromRole="Product" ToRole="Subcategory">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<bi:EntityType />
</EntityType>
<EntityType Name="DimProductCategory">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="ProductCategoryKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="ProductCategoryAlternateKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="EnglishProductCategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishProductCategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchProductCategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<bi:EntityType />
</EntityType>
<EntityType Name="DimProductSubcategory">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="ProductSubcategoryKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="ProductSubcategoryAlternateKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="EnglishProductSubcategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishProductSubcategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchProductSubcategoryName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="ProductCategoryKey" Type="Int64">
<bi:Property />
</Property>
<NavigationProperty Name="Category" Relationship="Sandbox.DimProductSubcategory_DimProductCategory_Category" FromRole="Subcategory2" ToRole="Category">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<bi:EntityType />
</EntityType>
<EntityType Name="DimStore">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="StoreKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="Geography_Key" Type="Int64">
<bi:Property Caption="Geography Key" ReferenceName="Geography Key" />
</Property>
<Property Name="StoreName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="Number_of_Employees" Type="Int64">
<bi:Property Caption="Number of Employees" ReferenceName="Number of Employees" />
</Property>
<Property Name="Sales" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<NavigationProperty Name="Geography2" Relationship="Sandbox.DimStore_DimGeography_Geography2" FromRole="Store" ToRole="Geography2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<bi:EntityType />
</EntityType>
<EntityType Name="DimTime">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="TimeKey" Type="Int64" Nullable="false">
<bi:Property />
</Property>
<Property Name="FullDateAlternateKey" Type="DateTime">
<bi:Property />
</Property>
<Property Name="DayNumberOfWeek" Type="Int64">
<bi:Property />
</Property>
<Property Name="EnglishDayNameOfWeek" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishDayNameOfWeek" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchDayNameOfWeek" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="DayNumberOfMonth" Type="Int64">
<bi:Property />
</Property>
<Property Name="DayNumberOfYear" Type="Int64">
<bi:Property />
</Property>
<Property Name="WeekNumberOfYear" Type="Int64">
<bi:Property />
</Property>
<Property Name="EnglishMonthName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SpanishMonthName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FrenchMonthName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="MonthNumberOfYear" Type="Int64">
<bi:Property />
</Property>
<Property Name="CalendarQuarter" Type="Int64">
<bi:Property />
</Property>
<Property Name="CalendarYear" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="CalendarSemester" Type="Int64">
<bi:Property />
</Property>
<Property Name="FiscalQuarter" Type="Int64">
<bi:Property />
</Property>
<Property Name="FiscalYear" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="FiscalSemester" Type="Int64">
<bi:Property />
</Property>
<bi:EntityType />
</EntityType>
<EntityType Name="FactInternetSales">
<Key>
<PropertyRef Name="RowNumber" />
</Key>
<Property Name="RowNumber" Type="Int64" Nullable="false">
<bi:Property Hidden="true" Contents="RowNumber" Stability="RowNumber" />
</Property>
<Property Name="ProductKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="OrderDateKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="DueDateKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="ShipDateKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="CustomerKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="PromotionKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="CurrencyKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="SalesTerritoryKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="SalesOrderNumber" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="SalesOrderLineNumber" Type="Int64">
<bi:Property />
</Property>
<Property Name="RevisionNumber" Type="Int64">
<bi:Property />
</Property>
<Property Name="OrderQuantity" Type="Int64">
<bi:Property />
</Property>
<Property Name="UnitPrice" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="ExtendedAmount" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="UnitPriceDiscountPct" Type="Double">
<bi:Property />
</Property>
<Property Name="DiscountAmount" Type="Double">
<bi:Property />
</Property>
<Property Name="ProductStandardCost" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="TotalProductCost" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="SalesAmount" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="TaxAmt" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="Freight" Type="Decimal" Precision="19" Scale="4">
<bi:Property />
</Property>
<Property Name="CarrierTrackingNumber" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="CustomerPONumber" Type="String" MaxLength="Max" Unicode="true" FixedLength="false">
<bi:Property />
</Property>
<Property Name="EmployeeKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="BillingCustomerKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="StoreKey" Type="Int64">
<bi:Property />
</Property>
<Property Name="TotalSales" Type="Int64">
<Documentation>
<Summary>DescriptionRolePlayingDimensionsDB</Summary>
</Documentation>
<bi:Measure Caption="CaptionRolePlayingDimensionsDB" ContextualNameRule="Context" Alignment="Right" FormatString=""$"#,0.00;("$"#,0.00);"$"#,0.00" Units="money" SortDirection="Ascending" IsRightToLeft="true" IsSimpleMeasure="true" />
</Property>
<NavigationProperty Name="Customer2" Relationship="Sandbox.FactInternetSales_DimCustomer_Customer2" FromRole="Sales" ToRole="Customer2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Customer_2" Relationship="Sandbox.FactInternetSales_DimCustomer_Customer_2" FromRole="Sales2" ToRole="Customer_2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Time" Relationship="Sandbox.FactInternetSales_DimTime_Time" FromRole="Sales3" ToRole="Time">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Time_2" Relationship="Sandbox.FactInternetSales_DimTime_Time_2" FromRole="Sales4" ToRole="Time_2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Time_3" Relationship="Sandbox.FactInternetSales_DimTime_Time_3" FromRole="Sales5" ToRole="Time_3">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Store2" Relationship="Sandbox.FactInternetSales_DimStore_Store2" FromRole="Sales6" ToRole="Store2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Employee" Relationship="Sandbox.FactInternetSales_DimEmployee_Employee" FromRole="Sales7" ToRole="Employee">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<NavigationProperty Name="Product2" Relationship="Sandbox.FactInternetSales_DimProduct_Product2" FromRole="FactInternetSales" ToRole="Product2">
<bi:NavigationProperty ContextualNameRule="Merge" />
</NavigationProperty>
<bi:EntityType>
<bi:DefaultDetails>
<bi:MemberRef Name="TotalSales" />
</bi:DefaultDetails>
<bi:DefaultMeasure>
<bi:MemberRef Name="TotalSales" />
</bi:DefaultMeasure>
</bi:EntityType>
</EntityType>
<Association Name="DimCustomer_DimGeography_Geography">
<End Role="Customer" Type="Sandbox.DimCustomer" Multiplicity="*" />
<End Role="Geography" Type="Sandbox.DimGeography" Multiplicity="0..1" />
</Association>
<Association Name="DimProduct_DimProductSubcategory_Subcategory">
<End Role="Product" Type="Sandbox.DimProduct" Multiplicity="*" />
<End Role="Subcategory" Type="Sandbox.DimProductSubcategory" Multiplicity="0..1" />
</Association>
<Association Name="DimProductSubcategory_DimProductCategory_Category">
<End Role="Subcategory2" Type="Sandbox.DimProductSubcategory" Multiplicity="*" />
<End Role="Category" Type="Sandbox.DimProductCategory" Multiplicity="0..1" />
</Association>
<Association Name="DimStore_DimGeography_Geography2">
<End Role="Store" Type="Sandbox.DimStore" Multiplicity="*" />
<End Role="Geography2" Type="Sandbox.DimGeography" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimCustomer_Customer2">
<End Role="Sales" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Customer2" Type="Sandbox.DimCustomer" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimCustomer_Customer_2">
<End Role="Sales2" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Customer_2" Type="Sandbox.DimCustomer" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimTime_Time">
<End Role="Sales3" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Time" Type="Sandbox.DimTime" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimTime_Time_2">
<End Role="Sales4" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Time_2" Type="Sandbox.DimTime" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimTime_Time_3">
<End Role="Sales5" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Time_3" Type="Sandbox.DimTime" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimStore_Store2">
<End Role="Sales6" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Store2" Type="Sandbox.DimStore" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimEmployee_Employee">
<End Role="Sales7" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Employee" Type="Sandbox.DimEmployee" Multiplicity="0..1" />
</Association>
<Association Name="FactInternetSales_DimProduct_Product2">
<End Role="FactInternetSales" Type="Sandbox.FactInternetSales" Multiplicity="*" />
<End Role="Product2" Type="Sandbox.DimProduct" Multiplicity="0..1" />
</Association>
</Schema>