3.3 CSDLBI 2.0 and CSDLBI 2.5
Note The CSDLBI 2.5 schema is the same as the CSDLBI 2.0 schema. However, when a client application requests CSDLBI 2.5 from a server, the server returns the ReferentialConstraint information for the Association object and the Role attribute on the Association End element. When the client application requests CSDLBI 2.0 from a server, these properties are not returned. For more details about these optional properties, see [MC-CSDL].
-
<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="2.0" Namespace="Sandbox"> <EntityContainer Name="Sandbox"> <Documentation> <Summary>A Unified Dimensional Model that encompasses the Adventure Works data warehouse.</Summary> </Documentation> <EntitySet Name="Measures" EntityType="Sandbox.Measures"> <bi:EntitySet Hidden="true" /> </EntitySet> <EntitySet Name="Date" EntityType="Sandbox.Date"> <bi:EntitySet /> </EntitySet> <EntitySet Name="Customer" EntityType="Sandbox.Customer"> <bi:EntitySet /> </EntitySet> <EntitySet Name="Product" EntityType="Sandbox.Product"> <bi:EntitySet /> </EntitySet> <EntitySet Name="Internet_Sales" EntityType="Sandbox.Internet_Sales"> <bi:EntitySet Caption="Internet Sales" ReferenceName="Internet Sales" /> </EntitySet> <AssociationSet Name="Internet_Sales_Product_Product_Product" Association="Sandbox.Internet_Sales_Product_Product_Product"> <End EntitySet="Internet_Sales" /> <End EntitySet="Product" /> <bi:AssociationSet /> </AssociationSet> <AssociationSet Name="Internet_Sales_Customer_Customer_Customer" Association="Sandbox.Internet_Sales_Customer_Customer_Customer"> <End EntitySet="Internet_Sales" /> <End EntitySet="Customer" /> <bi:AssociationSet /> </AssociationSet> <AssociationSet Name="Internet_Sales_Date_Date_Date" Association="Sandbox.Internet_Sales_Date_Date_Date"> <End EntitySet="Internet_Sales" /> <End EntitySet="Date" /> <bi:AssociationSet /> </AssociationSet> <bi:EntityContainer Caption="Adventure Works DW 2008" Culture="en-US"> <bi:CompareOptions IgnoreCase="true" IgnoreKanaType="true" IgnoreWidth="true" /> <bi:ModelCapabilities> <bi:CrossFilteringWithinTable>Always</bi:CrossFilteringWithinTable> <bi:GroupByValidation>Enforced</bi:GroupByValidation> <bi:FiveStateKPIRange>1</bi:FiveStateKPIRange> <bi:QueryAggregateUsage>Discourage</bi:QueryAggregateUsage> <bi:DiscourageCompositeModels>0</bi:DiscourageCompositeModels> <bi:EncourageIsEmptyDAXFunctionUsage>true</bi:EncourageIsEmptyDAXFunctionUsage> <bi:QueryBatching>1</bi:QueryBatching> <bi:Variables>1</bi:Variables> <bi:InOperator>1</bi:InOperator> <bi:TableConstructor>1</bi:TableConstructor> <bi:ExecutionMetrics>1</bi:ExecutionMetrics> <bi:VirtualColumns>1</bi:VirtualColumns> <bi:DAXFunctions> <bi:SummarizeColumns>1</bi:SummarizeColumns> <bi:SubstituteWithIndex>1</bi:SubstituteWithIndex> <bi:LeftOuterJoin>1</bi:LeftOuterJoin> <bi:StringMinMax>1</bi:StringMinMax> <bi:BinaryMinMax>1</bi:BinaryMinMax> <bi:TreatAs>1</bi:TreatAs> <bi:Error>1</bi:Error> <bi:SampleAxisWithLocalMinMax>1</bi:SampleAxisWithLocalMinMax> <bi:SampleCartesianPointsByCover>1</bi:SampleCartesianPointsByCover> <bi:OptimizedNotInOperator>1</bi:OptimizedNotInOperator> <bi:NonVisual>1</bi:NonVisual> <bi:IsAfter>1</bi:IsAfter> <bi:FormatByLocale>1</bi:FormatByLocale> </bi:DAXFunctions> </bi:ModelCapabilities> </bi:EntityContainer> </EntityContainer> <EntityType Name="Measures"> <Key> <PropertyRef Name="RowNumber" /> </Key> <Property Name="RowNumber" Type="Int64" Nullable="false"> <bi:Property Hidden="true" Stability="RowNumber" /> </Property> <bi:EntityType /> </EntityType> <EntityType Name="Date"> <Key> <PropertyRef Name="Date_Key0" /> </Key> <Property Name="Fiscal_Year_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Year.Key0" /> </Property> <Property Name="Fiscal_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Year" ReferenceName="Fiscal Year" Contents="FiscalYears"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Fiscal_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Fiscal_Year_Value" Type="Int64" Nullable="false"> <bi:Property Caption="Fiscal Year.Value" ReferenceName="Fiscal Year.Value" Contents="FiscalYears"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Fiscal_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Date_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Date.Key0" /> </Property> <Property Name="Date2" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Date" ReferenceName="Date" Contents="Date"> <bi:GroupBy> <bi:PropertyRef Name="Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Date_Key0" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Day_of_Week" /> <bi:PropertyRef Name="Day_Name" /> <bi:PropertyRef Name="Day_of_Month" /> <bi:PropertyRef Name="Day_of_Year" /> <bi:PropertyRef Name="Calendar_Week" /> <bi:PropertyRef Name="Month_Name" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Date_Value" Type="DateTime" Nullable="false"> <bi:Property Caption="Date.Value" ReferenceName="Date.Value" Contents="Date"> <bi:GroupBy> <bi:PropertyRef Name="Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Date_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Calendar_Quarter_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Quarter.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Quarter_Key0" /> <bi:PropertyRef Name="Calendar_Quarter_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Quarter_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Quarter.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Quarter_Key0" /> <bi:PropertyRef Name="Calendar_Quarter_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Quarter" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Quarter" Hidden="true" ReferenceName="Calendar Quarter" Contents="Quarters"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Quarter_Key0" /> <bi:PropertyRef Name="Calendar_Quarter_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Quarter_Key0" /> <bi:PropertyRef Name="Calendar_Quarter_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Fiscal_Quarter" /> <bi:PropertyRef Name="Calendar_Semester" /> <bi:PropertyRef Name="Calendar_Semester_of_Year" /> <bi:PropertyRef Name="Calendar_Quarter_of_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Fiscal_Quarter_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Quarter.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Quarter_Key0" /> <bi:PropertyRef Name="Fiscal_Quarter_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Fiscal_Quarter_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Quarter.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Quarter_Key0" /> <bi:PropertyRef Name="Fiscal_Quarter_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Fiscal_Quarter" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Quarter" Hidden="true" ReferenceName="Fiscal Quarter" Contents="FiscalQuarters"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Quarter_Key0" /> <bi:PropertyRef Name="Fiscal_Quarter_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Fiscal_Quarter_Key0" /> <bi:PropertyRef Name="Fiscal_Quarter_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Fiscal_Semester" /> <bi:PropertyRef Name="Fiscal_Semester_of_Year" /> <bi:PropertyRef Name="Fiscal_Quarter_of_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Calendar_Semester_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Semester.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Semester_Key0" /> <bi:PropertyRef Name="Calendar_Semester_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Semester_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Semester.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Semester_Key0" /> <bi:PropertyRef Name="Calendar_Semester_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Semester" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Semester" Hidden="true" ReferenceName="Calendar Semester" Contents="HalfYears"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Semester_Key0" /> <bi:PropertyRef Name="Calendar_Semester_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Semester_Key0" /> <bi:PropertyRef Name="Calendar_Semester_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Calendar_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Fiscal_Semester_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Semester.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Semester_Key0" /> <bi:PropertyRef Name="Fiscal_Semester_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Fiscal_Semester_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Semester.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Semester_Key0" /> <bi:PropertyRef Name="Fiscal_Semester_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Fiscal_Semester" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Semester" Hidden="true" ReferenceName="Fiscal Semester" Contents="FiscalHalfYears"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Semester_Key0" /> <bi:PropertyRef Name="Fiscal_Semester_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Fiscal_Semester_Key0" /> <bi:PropertyRef Name="Fiscal_Semester_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Fiscal_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Day_of_Week" Type="Int64" Nullable="false"> <bi:Property Caption="Day of Week" ReferenceName="Day of Week" Contents="DayOfWeek" /> </Property> <Property Name="Day_Name_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Day Name.Key0" /> </Property> <Property Name="Day_Name" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Day Name" ReferenceName="Day Name" Contents="Days" LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Day_Name_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Day_Name_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Day_Name_Value" Type="Int64" Nullable="false"> <bi:Property Caption="Day Name.Value" ReferenceName="Day Name.Value" Contents="Days"> <bi:GroupBy> <bi:PropertyRef Name="Day_Name_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Day_Name_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Day_of_Month" Type="Int64" Nullable="false"> <bi:Property Caption="Day of Month" ReferenceName="Day of Month" Contents="DayOfMonth" /> </Property> <Property Name="Day_of_Year" Type="Int64" Nullable="false"> <bi:Property Caption="Day of Year" ReferenceName="Day of Year" Contents="DayOfYear" /> </Property> <Property Name="Calendar_Week_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Week.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Week_Key0" /> <bi:PropertyRef Name="Calendar_Week_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Week_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Week.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Week_Key0" /> <bi:PropertyRef Name="Calendar_Week_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Calendar_Week" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Week" Hidden="true" ReferenceName="Calendar Week" Contents="Weeks"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Week_Key0" /> <bi:PropertyRef Name="Calendar_Week_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Week_Key0" /> <bi:PropertyRef Name="Calendar_Week_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Calendar_Week_of_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Month_Name_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Month Name.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Month_Name_Key1" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Month Name.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Month_Name" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Month Name" Hidden="true" ReferenceName="Month Name" Contents="Months"> <bi:GroupBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:OrderBy> <bi:RelatedTo> <bi:PropertyRef Name="Calendar_Quarter" /> <bi:PropertyRef Name="Month_of_Year" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Month_Name_Value" Type="DateTime" Nullable="false"> <bi:Property Caption="Month Name.Value" Hidden="true" ReferenceName="Month Name.Value" Contents="Months"> <bi:GroupBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Month_Name_Key0" /> <bi:PropertyRef Name="Month_Name_Key1" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Calendar_Year_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Year.Key0" /> </Property> <Property Name="Calendar_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Year" ReferenceName="Calendar Year" Contents="Years"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Calendar_Year_Value" Type="Int64" Nullable="false"> <bi:Property Caption="Calendar Year.Value" ReferenceName="Calendar Year.Value" Contents="Years"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Fiscal_Semester_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Semester of Year" ReferenceName="Fiscal Semester of Year" Contents="FiscalHalfYearOfYear" /> </Property> <Property Name="Calendar_Semester_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Semester of Year" ReferenceName="Calendar Semester of Year" Contents="HalfYearOfYear" /> </Property> <Property Name="Fiscal_Quarter_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Quarter of Year" ReferenceName="Fiscal Quarter of Year" Contents="FiscalQuarterOfYear" /> </Property> <Property Name="Calendar_Quarter_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Quarter of Year" ReferenceName="Calendar Quarter of Year" Contents="QuarterOfYear" /> </Property> <Property Name="Month_of_Year_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Month of Year.Key0" /> </Property> <Property Name="Month_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Month of Year" ReferenceName="Month of Year" LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Month_of_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Month_of_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Month_of_Year_Value" Type="Int64" Nullable="false"> <bi:Property Caption="Month of Year.Value" ReferenceName="Month of Year.Value"> <bi:GroupBy> <bi:PropertyRef Name="Month_of_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Month_of_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Calendar_Week_of_Year_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Calendar Week of Year.Key0" /> </Property> <Property Name="Calendar_Week_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Calendar Week of Year" ReferenceName="Calendar Week of Year" Contents="WeekOfYear"> <bi:GroupBy> <bi:PropertyRef Name="Calendar_Week_of_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Calendar_Week_of_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Fiscal_Week_of_Year_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Fiscal Week of Year.Key0" /> </Property> <Property Name="Fiscal_Week_of_Year" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Fiscal Week of Year" ReferenceName="Fiscal Week of Year" Contents="FiscalWeekOfYear"> <bi:GroupBy> <bi:PropertyRef Name="Fiscal_Week_of_Year_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Fiscal_Week_of_Year_Key0" /> </bi:OrderBy> </bi:Property> </Property> <bi:EntityType Contents="Time"> <bi:Hierarchy Name="Fiscal"> <bi:Level Name="Fiscal_Year" Caption="Fiscal Year" ReferenceName="Fiscal Year"> <bi:Source> <bi:PropertyRef Name="Fiscal_Year" /> </bi:Source> </bi:Level> <bi:Level Name="Fiscal_Semester" Caption="Fiscal Semester" ReferenceName="Fiscal Semester"> <bi:Source> <bi:PropertyRef Name="Fiscal_Semester" /> </bi:Source> </bi:Level> <bi:Level Name="Fiscal_Quarter" Caption="Fiscal Quarter" ReferenceName="Fiscal Quarter"> <bi:Source> <bi:PropertyRef Name="Fiscal_Quarter" /> </bi:Source> </bi:Level> <bi:Level Name="Month"> <bi:Source> <bi:PropertyRef Name="Month_Name" /> </bi:Source> </bi:Level> <bi:Level Name="Date"> <bi:Source> <bi:PropertyRef Name="Date2" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:Hierarchy Name="Calendar"> <bi:Level Name="Calendar_Year" Caption="Calendar Year" ReferenceName="Calendar Year"> <bi:Source> <bi:PropertyRef Name="Calendar_Year" /> </bi:Source> </bi:Level> <bi:Level Name="Calendar_Semester" Caption="Calendar Semester" ReferenceName="Calendar Semester"> <bi:Source> <bi:PropertyRef Name="Calendar_Semester" /> </bi:Source> </bi:Level> <bi:Level Name="Calendar_Quarter" Caption="Calendar Quarter" ReferenceName="Calendar Quarter"> <bi:Source> <bi:PropertyRef Name="Calendar_Quarter" /> </bi:Source> </bi:Level> <bi:Level Name="Month"> <bi:Source> <bi:PropertyRef Name="Month_Name" /> </bi:Source> </bi:Level> <bi:Level Name="Date"> <bi:Source> <bi:PropertyRef Name="Date2" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:Hierarchy Name="Calendar_Weeks" Caption="Calendar Weeks" ReferenceName="Calendar Weeks"> <bi:Level Name="Calendar_Year" Caption="Calendar Year" ReferenceName="Calendar Year"> <bi:Source> <bi:PropertyRef Name="Calendar_Year" /> </bi:Source> </bi:Level> <bi:Level Name="Calendar_Week" Caption="Calendar Week" ReferenceName="Calendar Week"> <bi:Source> <bi:PropertyRef Name="Calendar_Week" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:DisplayFolders> <bi:DisplayFolder Name="Fiscal"> <bi:PropertyRef Name="Fiscal_Year" /> <bi:PropertyRef Name="Fiscal_Year_Value" /> <bi:PropertyRef Name="Fiscal_Quarter" /> <bi:PropertyRef Name="Fiscal_Semester" /> <bi:PropertyRef Name="Fiscal_Semester_of_Year" /> <bi:PropertyRef Name="Fiscal_Quarter_of_Year" /> <bi:PropertyRef Name="Fiscal_Week_of_Year" /> <bi:HierarchyRef Name="Fiscal" /> </bi:DisplayFolder> <bi:DisplayFolder Name="Calendar"> <bi:PropertyRef Name="Calendar_Quarter" /> <bi:PropertyRef Name="Calendar_Semester" /> <bi:PropertyRef Name="Calendar_Week" /> <bi:PropertyRef Name="Calendar_Year" /> <bi:PropertyRef Name="Calendar_Year_Value" /> <bi:PropertyRef Name="Calendar_Semester_of_Year" /> <bi:PropertyRef Name="Calendar_Quarter_of_Year" /> <bi:PropertyRef Name="Calendar_Week_of_Year" /> <bi:HierarchyRef Name="Calendar" /> <bi:HierarchyRef Name="Calendar_Weeks" /> </bi:DisplayFolder> </bi:DisplayFolders> </bi:EntityType> </EntityType> <EntityType Name="Customer"> <Key> <PropertyRef Name="Customer_Key0" /> </Key> <Property Name="Customer_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Customer.Key0" /> </Property> <Property Name="Customer2" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Customer" ReferenceName="Customer" Contents="Customers"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="Postal_Code" /> <bi:PropertyRef Name="Yearly_Income" /> <bi:PropertyRef Name="Total_Children" /> <bi:PropertyRef Name="Number_of_Cars_Owned" /> <bi:PropertyRef Name="Number_of_Children_At_Home" /> <bi:PropertyRef Name="Education" /> <bi:PropertyRef Name="Occupation" /> <bi:PropertyRef Name="Marital_Status" /> <bi:PropertyRef Name="Gender" /> <bi:PropertyRef Name="Home_Owner" /> <bi:PropertyRef Name="Commute_Distance" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Customer_Date_of_First_Purchase" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Date of First Purchase" Hidden="true" ReferenceName="Customer.Date of First Purchase"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Customer_Date_of_First_Purchase_Key0" Type="DateTime" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Customer.Date of First Purchase.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Customer_Phone" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Phone" Hidden="true" ReferenceName="Customer.Phone" Contents="PersonContact"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Customer_Email_Address" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Email Address" Hidden="true" ReferenceName="Customer.Email Address" Contents="PersonContact"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Customer_Birth_Date" Type="DateTime" Nullable="false"> <bi:Property Caption="Birth Date" Hidden="true" ReferenceName="Customer.Birth Date"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Customer_Address" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Address" Hidden="true" ReferenceName="Customer.Address" Contents="Address"> <bi:GroupBy> <bi:PropertyRef Name="Customer_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Postal_Code_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Postal Code.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Postal_Code_Key0" /> <bi:PropertyRef Name="Postal_Code_Key1" /> <bi:PropertyRef Name="Postal_Code_Key2" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Postal_Code_Key1" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Postal Code.Key1"> <bi:GroupBy> <bi:PropertyRef Name="Postal_Code_Key0" /> <bi:PropertyRef Name="Postal_Code_Key1" /> <bi:PropertyRef Name="Postal_Code_Key2" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Postal_Code_Key2" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Postal Code.Key2"> <bi:GroupBy> <bi:PropertyRef Name="Postal_Code_Key0" /> <bi:PropertyRef Name="Postal_Code_Key1" /> <bi:PropertyRef Name="Postal_Code_Key2" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Postal_Code" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Postal Code" ReferenceName="Postal Code"> <bi:GroupBy> <bi:PropertyRef Name="Postal_Code_Key0" /> <bi:PropertyRef Name="Postal_Code_Key1" /> <bi:PropertyRef Name="Postal_Code_Key2" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="City" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Country_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Country.Key0" /> </Property> <Property Name="Country" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Country_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="State_Province_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="State-Province.Key0"> <bi:GroupBy> <bi:PropertyRef Name="State_Province_Key0" /> <bi:PropertyRef Name="State_Province_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="State_Province_Key1" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="State-Province.Key1"> <bi:GroupBy> <bi:PropertyRef Name="State_Province_Key0" /> <bi:PropertyRef Name="State_Province_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="State_Province" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="State-Province" ReferenceName="State-Province"> <bi:DefaultValue>WA</bi:DefaultValue> <bi:GroupBy> <bi:PropertyRef Name="State_Province_Key0" /> <bi:PropertyRef Name="State_Province_Key1" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="Country" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="City_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="City.Key0"> <bi:GroupBy> <bi:PropertyRef Name="City_Key0" /> <bi:PropertyRef Name="City_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="City_Key1" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="City.Key1"> <bi:GroupBy> <bi:PropertyRef Name="City_Key0" /> <bi:PropertyRef Name="City_Key1" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="City" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="City_Key0" /> <bi:PropertyRef Name="City_Key1" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="State_Province" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Yearly_Income_Key0" Type="Decimal" Precision="19" Scale="4" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Yearly Income.Key0" /> </Property> <Property Name="Yearly_Income" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Yearly Income" ReferenceName="Yearly Income"> <bi:GroupBy> <bi:PropertyRef Name="Yearly_Income_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Yearly_Income_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Total_Children_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Total Children.Key0" /> </Property> <Property Name="Total_Children" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Total Children" ReferenceName="Total Children"> <bi:GroupBy> <bi:PropertyRef Name="Total_Children_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Number_of_Cars_Owned_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Number of Cars Owned.Key0" /> </Property> <Property Name="Number_of_Cars_Owned" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Number of Cars Owned" ReferenceName="Number of Cars Owned"> <bi:GroupBy> <bi:PropertyRef Name="Number_of_Cars_Owned_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Number_of_Children_At_Home_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Number of Children At Home.Key0" /> </Property> <Property Name="Number_of_Children_At_Home" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Number of Children At Home" ReferenceName="Number of Children At Home"> <bi:GroupBy> <bi:PropertyRef Name="Number_of_Children_At_Home_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Education_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Education.Key0" /> </Property> <Property Name="Education" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Education_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Occupation_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Occupation.Key0" /> </Property> <Property Name="Occupation" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Occupation_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Marital_Status_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Marital Status.Key0" /> </Property> <Property Name="Marital_Status" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Marital Status" ReferenceName="Marital Status"> <bi:GroupBy> <bi:PropertyRef Name="Marital_Status_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Gender_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Gender.Key0" /> </Property> <Property Name="Gender" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Gender_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Home_Owner_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Home Owner.Key0" /> </Property> <Property Name="Home_Owner" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Home Owner" ReferenceName="Home Owner"> <bi:GroupBy> <bi:PropertyRef Name="Home_Owner_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Commute_Distance" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Commute Distance" ReferenceName="Commute Distance"> <bi:OrderBy> <bi:PropertyRef Name="Commute_Distance_Commute_Distance_Sort" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Commute_Distance_Commute_Distance_Sort" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Commute Distance Sort" Hidden="true" ReferenceName="Commute Distance.Commute Distance Sort"> <bi:GroupBy> <bi:PropertyRef Name="Commute_Distance" /> </bi:GroupBy> </bi:Property> </Property> <bi:EntityType Contents="Customers"> <bi:Hierarchy Name="Customer_Geography" Caption="Customer Geography" ReferenceName="Customer Geography"> <bi:Level Name="Country"> <bi:Source> <bi:PropertyRef Name="Country" /> </bi:Source> </bi:Level> <bi:Level Name="State_Province" Caption="State-Province" ReferenceName="State-Province"> <bi:Source> <bi:PropertyRef Name="State_Province" /> </bi:Source> </bi:Level> <bi:Level Name="City"> <bi:Source> <bi:PropertyRef Name="City" /> </bi:Source> </bi:Level> <bi:Level Name="Postal_Code" Caption="Postal Code" ReferenceName="Postal Code"> <bi:Source> <bi:PropertyRef Name="Postal_Code" /> </bi:Source> </bi:Level> <bi:Level Name="Customer"> <bi:Source> <bi:PropertyRef Name="Customer2" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:DisplayFolders> <bi:DisplayFolder Name="Location"> <bi:PropertyRef Name="Customer_Address" /> <bi:PropertyRef Name="Postal_Code" /> <bi:PropertyRef Name="Country" /> <bi:PropertyRef Name="State_Province" /> <bi:PropertyRef Name="City" /> </bi:DisplayFolder> <bi:DisplayFolder Name="Demographic"> <bi:PropertyRef Name="Yearly_Income" /> <bi:PropertyRef Name="Total_Children" /> <bi:PropertyRef Name="Number_of_Cars_Owned" /> <bi:PropertyRef Name="Number_of_Children_At_Home" /> <bi:PropertyRef Name="Education" /> <bi:PropertyRef Name="Occupation" /> <bi:PropertyRef Name="Marital_Status" /> <bi:PropertyRef Name="Gender" /> <bi:PropertyRef Name="Home_Owner" /> <bi:PropertyRef Name="Commute_Distance" /> </bi:DisplayFolder> </bi:DisplayFolders> </bi:EntityType> </EntityType> <EntityType Name="Product"> <Key> <PropertyRef Name="Product_Key0" /> </Key> <Property Name="Product_Key0" Type="Int64" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Product.Key0" /> </Property> <Property Name="Product2" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Product" ReferenceName="Product" Contents="Product" LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Product_Key0" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="Standard_Cost" /> <bi:PropertyRef Name="Color" /> <bi:PropertyRef Name="Safety_Stock_Level" /> <bi:PropertyRef Name="Reorder_Point" /> <bi:PropertyRef Name="List_Price" /> <bi:PropertyRef Name="Size" /> <bi:PropertyRef Name="Size_Range" /> <bi:PropertyRef Name="Weight" /> <bi:PropertyRef Name="Days_to_Manufacture" /> <bi:PropertyRef Name="Dealer_Price" /> <bi:PropertyRef Name="Class" /> <bi:PropertyRef Name="Style" /> <bi:PropertyRef Name="Model_Name" /> <bi:PropertyRef Name="Subcategory" /> <bi:PropertyRef Name="Status" /> <bi:PropertyRef Name="Start_Date" /> <bi:PropertyRef Name="End_Date" /> <bi:PropertyRef Name="Large_Photo" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Standard_Cost" Type="Decimal" Precision="19" Scale="4"> <bi:Property Caption="Standard Cost" ReferenceName="Standard Cost" /> </Property> <Property Name="Category_Key0" Type="Int64"> <bi:Property Hidden="true" ReferenceName="Category.Key0" /> </Property> <Property Name="Category" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Contents="ProductCategory" LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Category_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Color_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Color.UniqueName" /> </Property> <Property Name="Color" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Color_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Safety_Stock_Level" Type="Int64"> <bi:Property Caption="Safety Stock Level" ReferenceName="Safety Stock Level" /> </Property> <Property Name="Reorder_Point" Type="Int64"> <bi:Property Caption="Reorder Point" ReferenceName="Reorder Point" /> </Property> <Property Name="List_Price" Type="Decimal" Precision="19" Scale="4"> <bi:Property Caption="List Price" ReferenceName="List Price" /> </Property> <Property Name="Size_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Size.UniqueName" /> </Property> <Property Name="Size" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Size_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Size_Range_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Size Range.UniqueName" /> </Property> <Property Name="Size_Range" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Size Range" ReferenceName="Size Range"> <bi:GroupBy> <bi:PropertyRef Name="Size_Range_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Weight_Key0" Type="Double"> <bi:Property Hidden="true" ReferenceName="Weight.Key0" /> </Property> <Property Name="Weight" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Weight_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Weight_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Weight_Value" Type="Double"> <bi:Property Caption="Weight.Value" ReferenceName="Weight.Value"> <bi:GroupBy> <bi:PropertyRef Name="Weight_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Weight_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Days_to_Manufacture_Key0" Type="Int64"> <bi:Property Hidden="true" ReferenceName="Days to Manufacture.Key0" /> </Property> <Property Name="Days_to_Manufacture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Days to Manufacture" ReferenceName="Days to Manufacture"> <bi:GroupBy> <bi:PropertyRef Name="Days_to_Manufacture_Key0" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Dealer_Price" Type="Decimal" Precision="19" Scale="4"> <bi:Property Caption="Dealer Price" ReferenceName="Dealer Price" /> </Property> <Property Name="Class_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Class.UniqueName" /> </Property> <Property Name="Class_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Property Hidden="true" ReferenceName="Class.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Class_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Class" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Class_UniqueName" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Class_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Style_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Style.UniqueName" /> </Property> <Property Name="Style_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Property Hidden="true" ReferenceName="Style.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Style_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Style" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property> <bi:GroupBy> <bi:PropertyRef Name="Style_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Model_Name_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Model Name.UniqueName" /> </Property> <Property Name="Model_Name" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Model Name" ReferenceName="Model Name"> <bi:GroupBy> <bi:PropertyRef Name="Model_Name_UniqueName" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="Product_Line" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Product_Line_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Product Line.UniqueName" /> </Property> <Property Name="Product_Line_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Property Hidden="true" ReferenceName="Product Line.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Product_Line_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Product_Line" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Product Line" ReferenceName="Product Line"> <bi:GroupBy> <bi:PropertyRef Name="Product_Line_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Subcategory_Key0" Type="Int64"> <bi:Property Hidden="true" ReferenceName="Subcategory.Key0" /> </Property> <Property Name="Subcategory" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property LocaleImpact="true"> <bi:GroupBy> <bi:PropertyRef Name="Subcategory_Key0" /> </bi:GroupBy> <bi:RelatedTo> <bi:PropertyRef Name="Category" /> </bi:RelatedTo> </bi:Property> </Property> <Property Name="Status_UniqueName" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Hidden="true" ReferenceName="Status.UniqueName" /> </Property> <Property Name="Status_Key0" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Property Hidden="true" ReferenceName="Status.Key0"> <bi:GroupBy> <bi:PropertyRef Name="Status_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Status" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Contents="ScdStatus"> <bi:GroupBy> <bi:PropertyRef Name="Status_UniqueName" /> </bi:GroupBy> </bi:Property> </Property> <Property Name="Start_Date_Key0" Type="DateTime"> <bi:Property Hidden="true" ReferenceName="Start Date.Key0" /> </Property> <Property Name="Start_Date" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="Start Date" ReferenceName="Start Date" Contents="ScdStartDate"> <bi:GroupBy> <bi:PropertyRef Name="Start_Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Start_Date_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Start_Date_Value" Type="DateTime"> <bi:Property Caption="Start Date.Value" ReferenceName="Start Date.Value" Contents="ScdStartDate"> <bi:GroupBy> <bi:PropertyRef Name="Start_Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="Start_Date_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="End_Date_Key0" Type="DateTime"> <bi:Property Hidden="true" ReferenceName="End Date.Key0" /> </Property> <Property Name="End_Date" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" Nullable="false"> <bi:Property Caption="End Date" ReferenceName="End Date" Contents="ScdEndDate"> <bi:GroupBy> <bi:PropertyRef Name="End_Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="End_Date_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="End_Date_Value" Type="DateTime"> <bi:Property Caption="End Date.Value" ReferenceName="End Date.Value" Contents="ScdEndDate"> <bi:GroupBy> <bi:PropertyRef Name="End_Date_Key0" /> </bi:GroupBy> <bi:OrderBy> <bi:PropertyRef Name="End_Date_Key0" /> </bi:OrderBy> </bi:Property> </Property> <Property Name="Large_Photo" Type="Int64"> <bi:Property Caption="Large Photo" ReferenceName="Large Photo" /> </Property> <bi:EntityType Contents="Products"> <bi:Hierarchy Name="Product_Categories" Caption="Product Categories" ReferenceName="Product Categories"> <bi:Level Name="Category"> <bi:Source> <bi:PropertyRef Name="Category" /> </bi:Source> </bi:Level> <bi:Level Name="Subcategory"> <bi:Source> <bi:PropertyRef Name="Subcategory" /> </bi:Source> </bi:Level> <bi:Level Name="Product"> <bi:Source> <bi:PropertyRef Name="Product2" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:Hierarchy Name="Product_Model_Lines" Caption="Product Model Lines" ReferenceName="Product Model Lines"> <bi:Level Name="Product_Line" Caption="Product Line" ReferenceName="Product Line"> <bi:Source> <bi:PropertyRef Name="Product_Line" /> </bi:Source> </bi:Level> <bi:Level Name="Model"> <bi:Source> <bi:PropertyRef Name="Model_Name" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:Hierarchy Name="Stock_Level" Caption="Stock Level" ReferenceName="Stock Level"> <bi:Level Name="Safety_Stock_Level" Caption="Safety Stock Level" ReferenceName="Safety Stock Level"> <bi:Source> <bi:PropertyRef Name="Safety_Stock_Level" /> </bi:Source> </bi:Level> <bi:Level Name="Product"> <bi:Source> <bi:PropertyRef Name="Product2" /> </bi:Source> </bi:Level> </bi:Hierarchy> <bi:DisplayFolders> <bi:DisplayFolder Name="Financial"> <bi:PropertyRef Name="Standard_Cost" /> <bi:PropertyRef Name="List_Price" /> <bi:PropertyRef Name="Dealer_Price" /> </bi:DisplayFolder> <bi:DisplayFolder Name="Stocking"> <bi:PropertyRef Name="Color" /> <bi:PropertyRef Name="Safety_Stock_Level" /> <bi:PropertyRef Name="Reorder_Point" /> <bi:PropertyRef Name="Size" /> <bi:PropertyRef Name="Size_Range" /> <bi:PropertyRef Name="Weight" /> <bi:PropertyRef Name="Weight_Value" /> <bi:PropertyRef Name="Days_to_Manufacture" /> <bi:PropertyRef Name="Class" /> <bi:HierarchyRef Name="Stock_Level" /> </bi:DisplayFolder> <bi:DisplayFolder Name="History"> <bi:PropertyRef Name="Status" /> <bi:PropertyRef Name="Start_Date" /> <bi:PropertyRef Name="Start_Date_Value" /> <bi:PropertyRef Name="End_Date" /> <bi:PropertyRef Name="End_Date_Value" /> </bi:DisplayFolder> </bi:DisplayFolders> </bi:EntityType> </EntityType> <EntityType Name="Internet_Sales"> <Key> <PropertyRef Name="RowNumber" /> </Key> <Property Name="RowNumber" Type="Int64" Nullable="false"> <bi:Property Hidden="true" Stability="RowNumber" /> </Property> <Property Name="Internet_Gross_Profit" Type="Double"> <bi:Measure Caption="Internet Gross Profit" ReferenceName="Internet Gross Profit" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Gross_Profit_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Gross_Profit_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Gross_Profit_Margin" Type="Double"> <bi:Measure Caption="Internet Gross Profit Margin" ReferenceName="Internet Gross Profit Margin" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Gross_Profit_Margin_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Gross_Profit_Margin_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Average_Unit_Price" Type="Double"> <bi:Measure Caption="Internet Average Unit Price" ReferenceName="Internet Average Unit Price" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Average_Unit_Price_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Average_Unit_Price_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Average_Sales_Amount" Type="Double"> <bi:Measure Caption="Internet Average Sales Amount" ReferenceName="Internet Average Sales Amount" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Average_Sales_Amount_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Average_Sales_Amount_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Ratio_to_All_Products" Type="Double"> <bi:Measure Caption="Internet Ratio to All Products" ReferenceName="Internet Ratio to All Products" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Ratio_to_All_Products_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Ratio_to_All_Products_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Ratio_to_Parent_Product" Type="Double"> <bi:Measure Caption="Internet Ratio to Parent Product" ReferenceName="Internet Ratio to Parent Product" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Ratio_to_Parent_Product_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Ratio_to_Parent_Product_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Growth_in_Customer_Base" Type="Double"> <bi:Measure Caption="Growth in Customer Base" ReferenceName="Growth in Customer Base" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Growth_in_Customer_Base_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Growth_in_Customer_Base_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="v___Growth_in_Customer_Base_Value" Type="Double"> <bi:Measure Caption="Growth in Customer Base" ReferenceName="___Growth in Customer Base Value" ActualType="Any"> <bi:Kpi StatusGraphic="Road Signs" TrendGraphic="Standard Arrow"> <bi:Documentation> <bi:Summary>The ratio between the customer count in the current period to that of the previous period.</bi:Summary> </bi:Documentation> <bi:KpiGoal> <bi:PropertyRef Name="Growth_in_Customer_Base_Goal" /> </bi:KpiGoal> <bi:KpiStatus> <bi:PropertyRef Name="Growth_in_Customer_Base_Status" /> </bi:KpiStatus> <bi:KpiTrend> <bi:PropertyRef Name="Growth_in_Customer_Base_Trend" /> </bi:KpiTrend> </bi:Kpi> <bi:FormatBy> <bi:PropertyRef Name="v___Growth_in_Customer_Base_Value_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="v___Growth_in_Customer_Base_Value_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Growth_in_Customer_Base_Goal" Type="Double"> <bi:Measure Caption="Growth in Customer Base Goal" Hidden="true" ReferenceName="Growth in Customer Base Goal" ActualType="Any"> <bi:ApplyCulture> <bi:PropertyRef Name="Growth_in_Customer_Base_Goal_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Growth_in_Customer_Base_Status" Type="Double"> <bi:Measure Caption="Growth in Customer Base Status" Hidden="true" ReferenceName="Growth in Customer Base Status" ActualType="Any"> <bi:ApplyCulture> <bi:PropertyRef Name="Growth_in_Customer_Base_Status_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Growth_in_Customer_Base_Trend" Type="Double"> <bi:Measure Caption="Growth in Customer Base Trend" Hidden="true" ReferenceName="Growth in Customer Base Trend" ActualType="Any"> <bi:ApplyCulture> <bi:PropertyRef Name="Growth_in_Customer_Base_Trend_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Sales_Amount" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Sales Amount" ReferenceName="Internet Sales Amount" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Sales_Amount_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Sales_Amount_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Order_Quantity" Type="Int64"> <bi:Measure Caption="Internet Order Quantity" ReferenceName="Internet Order Quantity" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Order_Quantity_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Order_Quantity_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Extended_Amount" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Extended Amount" ReferenceName="Internet Extended Amount" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Extended_Amount_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Extended_Amount_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Tax_Amount" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Tax Amount" ReferenceName="Internet Tax Amount" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Tax_Amount_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Tax_Amount_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Freight_Cost" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Freight Cost" ReferenceName="Internet Freight Cost" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Freight_Cost_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Freight_Cost_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Unit_Price" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Unit Price" Hidden="true" ReferenceName="Internet Unit Price" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Unit_Price_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Unit_Price_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Total_Product_Cost" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Total Product Cost" ReferenceName="Internet Total Product Cost" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Total_Product_Cost_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Total_Product_Cost_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Standard_Product_Cost" Type="Decimal" Precision="19" Scale="4"> <bi:Measure Caption="Internet Standard Product Cost" ReferenceName="Internet Standard Product Cost" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Standard_Product_Cost_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Standard_Product_Cost_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Transaction_Count" Type="Int64"> <bi:Measure Caption="Internet Transaction Count" Hidden="true" ReferenceName="Internet Transaction Count" ActualType="Any"> <bi:FormatBy> <bi:PropertyRef Name="Internet_Transaction_Count_FormatString" /> </bi:FormatBy> <bi:ApplyCulture> <bi:PropertyRef Name="Internet_Transaction_Count_ApplyCulture" /> </bi:ApplyCulture> </bi:Measure> </Property> <Property Name="Internet_Gross_Profit_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Gross Profit.FormatString" /> </Property> <Property Name="Internet_Gross_Profit_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Gross Profit.ApplyCulture" /> </Property> <Property Name="Internet_Gross_Profit_Margin_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Gross Profit Margin.FormatString" /> </Property> <Property Name="Internet_Gross_Profit_Margin_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Gross Profit Margin.ApplyCulture" /> </Property> <Property Name="Internet_Average_Unit_Price_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Average Unit Price.FormatString" /> </Property> <Property Name="Internet_Average_Unit_Price_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Average Unit Price.ApplyCulture" /> </Property> <Property Name="Internet_Average_Sales_Amount_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Average Sales Amount.FormatString" /> </Property> <Property Name="Internet_Average_Sales_Amount_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Average Sales Amount.ApplyCulture" /> </Property> <Property Name="Internet_Ratio_to_All_Products_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Ratio to All Products.FormatString" /> </Property> <Property Name="Internet_Ratio_to_All_Products_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Ratio to All Products.ApplyCulture" /> </Property> <Property Name="Internet_Ratio_to_Parent_Product_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Ratio to Parent Product.FormatString" /> </Property> <Property Name="Internet_Ratio_to_Parent_Product_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Ratio to Parent Product.ApplyCulture" /> </Property> <Property Name="Growth_in_Customer_Base_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Growth in Customer Base.FormatString" /> </Property> <Property Name="Growth_in_Customer_Base_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Growth in Customer Base.ApplyCulture" /> </Property> <Property Name="v___Growth_in_Customer_Base_Value_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="___Growth in Customer Base Value.FormatString" /> </Property> <Property Name="v___Growth_in_Customer_Base_Value_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="___Growth in Customer Base Value.ApplyCulture" /> </Property> <Property Name="Growth_in_Customer_Base_Goal_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Growth in Customer Base Goal.ApplyCulture" /> </Property> <Property Name="Growth_in_Customer_Base_Status_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Growth in Customer Base Status.ApplyCulture" /> </Property> <Property Name="Growth_in_Customer_Base_Trend_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Growth in Customer Base Trend.ApplyCulture" /> </Property> <Property Name="Internet_Sales_Amount_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Sales Amount.FormatString" /> </Property> <Property Name="Internet_Sales_Amount_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Sales Amount.ApplyCulture" /> </Property> <Property Name="Internet_Order_Quantity_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Order Quantity.FormatString" /> </Property> <Property Name="Internet_Order_Quantity_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Order Quantity.ApplyCulture" /> </Property> <Property Name="Internet_Extended_Amount_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Extended Amount.FormatString" /> </Property> <Property Name="Internet_Extended_Amount_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Extended Amount.ApplyCulture" /> </Property> <Property Name="Internet_Tax_Amount_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Tax Amount.FormatString" /> </Property> <Property Name="Internet_Tax_Amount_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Tax Amount.ApplyCulture" /> </Property> <Property Name="Internet_Freight_Cost_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Freight Cost.FormatString" /> </Property> <Property Name="Internet_Freight_Cost_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Freight Cost.ApplyCulture" /> </Property> <Property Name="Internet_Unit_Price_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Unit Price.FormatString" /> </Property> <Property Name="Internet_Unit_Price_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Unit Price.ApplyCulture" /> </Property> <Property Name="Internet_Total_Product_Cost_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Total Product Cost.FormatString" /> </Property> <Property Name="Internet_Total_Product_Cost_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Total Product Cost.ApplyCulture" /> </Property> <Property Name="Internet_Standard_Product_Cost_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Standard Product Cost.FormatString" /> </Property> <Property Name="Internet_Standard_Product_Cost_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Standard Product Cost.ApplyCulture" /> </Property> <Property Name="Internet_Transaction_Count_FormatString" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Transaction Count.FormatString" /> </Property> <Property Name="Internet_Transaction_Count_ApplyCulture" Type="String" MaxLength="Max" Unicode="true" FixedLength="false"> <bi:Measure Hidden="true" ReferenceName="Internet Transaction Count.ApplyCulture" /> </Property> <NavigationProperty Name="Product_Product" Relationship="Sandbox.Internet_Sales_Product_Product_Product" FromRole="Internet_Sales_Product_Product" ToRole="Product_Product"> <bi:NavigationProperty /> </NavigationProperty> <NavigationProperty Name="Customer_Customer" Relationship="Sandbox.Internet_Sales_Customer_Customer_Customer" FromRole="Internet_Sales_Customer_Customer" ToRole="Customer_Customer"> <bi:NavigationProperty /> </NavigationProperty> <NavigationProperty Name="Date_Date" Relationship="Sandbox.Internet_Sales_Date_Date_Date" FromRole="Internet_Sales_Date_Date" ToRole="Date_Date"> <bi:NavigationProperty /> </NavigationProperty> <bi:EntityType Contents="Sales"> <bi:DisplayFolders> <bi:DisplayFolder Name="Customer_Perspective" Caption="Customer Perspective"> <bi:DisplayFolder Name="Expand_Customer_Base" Caption="Expand Customer Base"> <bi:PropertyRef Name="v___Growth_in_Customer_Base_Value" /> </bi:DisplayFolder> </bi:DisplayFolder> </bi:DisplayFolders> </bi:EntityType> </EntityType> <Association Name="Internet_Sales_Product_Product_Product"> <End Role="Internet_Sales_Product_Product" Type="Sandbox.Internet_Sales" Multiplicity="*" /> <End Role="Product_Product" Type="Sandbox.Product" Multiplicity="0..1" /> </Association> <Association Name="Internet_Sales_Customer_Customer_Customer"> <End Role="Internet_Sales_Customer_Customer" Type="Sandbox.Internet_Sales" Multiplicity="*" /> <End Role="Customer_Customer" Type="Sandbox.Customer" Multiplicity="0..1" /> </Association> <Association Name="Internet_Sales_Date_Date_Date"> <End Role="Internet_Sales_Date_Date" Type="Sandbox.Internet_Sales" Multiplicity="*" /> <End Role="Date_Date" Type="Sandbox.Date" Multiplicity="0..1" /> </Association> </Schema>