3.1 CSDLBI 1.0
-
<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>