Skip to content

Instantly share code, notes, and snippets.

@m4ttbrock

m4ttbrock/fiddle.response.xml

Last active February 21, 2017 23:39
Show Gist options
  • Save m4ttbrock/ec48578b8fe7bab5741eba65c64b7338 to your computer and use it in GitHub Desktop.
Save m4ttbrock/ec48578b8fe7bab5741eba65c64b7338 to your computer and use it in GitHub Desktop.
Download ZIP
sample xml
Raw
fiddle.response.xml
<grains>
<g compGrain="false" degen="false" global="false" hide="-1" id="100" inDimMaint="false" insert="0" keyfield="dDay" name="Day" table="d_Days">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="145" editable="true">
<dName dataType="nvarchar">Bi Month</dName>
<dColumn>CBiMonthName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="150" editable="true">
<dName dataType="nvarchar">Calendar Month</dName>
<dColumn>CMonthName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="160" editable="true">
<dName dataType="nvarchar">Calendar Quarter</dName>
<dColumn>CQtrName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="170" editable="true">
<dName dataType="int">Calendar Year</dName>
<dColumn>CYearName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="100" editable="true">
<dName dataType="nvarchar">Day</dName>
<dColumn>DayName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="180" editable="true">
<dName dataType="nvarchar">Day Of Week Name</dName>
<dColumn>Dayofweekname</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="120" editable="true">
<dName dataType="nvarchar">Fiscal Period</dName>
<dColumn>FMonthName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="130" editable="true">
<dName dataType="nvarchar">Fiscal Quarter</dName>
<dColumn>FQtrName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="140" editable="true">
<dName dataType="int">Fiscal Year</dName>
<dColumn>FYearName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="181" editable="true">
<dName dataType="nvarchar">Order Day</dName>
<dColumn>OrderDay</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="110" editable="true">
<dName dataType="nvarchar">Week</dName>
<dColumn>WeekName</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="145" inDimMaint="false" insert="0" keyfield="bCBiMonth" name="BiMonth" table="d_BiMonths">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="145" editable="true">
<dName dataType="nvarchar">Bi Month</dName>
<dColumn>CBiMonthName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="150" editable="true">
<dName dataType="nvarchar">Calendar Month</dName>
<dColumn>CMonthName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="160" editable="true">
<dName dataType="nvarchar">Calendar Quarter</dName>
<dColumn>CQtrName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="170" editable="true">
<dName dataType="int">Calendar Year</dName>
<dColumn>CYearName</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="true" hide="-1" id="200" inDimMaint="true" insert="2" keyfield="sStore" name="Store" table="d_Stores_Toppers">
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="210" editable="true">
<dName dataType="nvarchar">Address</dName>
<dColumn>Address</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000900" editable="true">
<dName dataType="nvarchar">Area</dName>
<dColumn>[Area]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2001" editable="false">
<dName dataType="nvarchar">Area Supervisor Email</dName>
<dColumn>AreaSupervisorEmail</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2002" editable="false">
<dName dataType="nvarchar">Area Supervisor First Name</dName>
<dColumn>AreaSupervisorFirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2003" editable="false">
<dName dataType="nvarchar">Area Supervisor Full Name</dName>
<dColumn>AreaSupervisorFullName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2004" editable="false">
<dName dataType="float">Area Supervisor Initials</dName>
<dColumn>AreaSupervisorInitials</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2005" editable="false">
<dName dataType="nvarchar">Area Supervisor Last Name</dName>
<dColumn>AreaSupervisorLastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2006" editable="false">
<dName dataType="nvarchar">Area Supervisor Mobile</dName>
<dColumn>AreaSupervisorMobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2007" editable="false">
<dName dataType="nvarchar">Area Supervisor Phone</dName>
<dColumn>AreaSupervisorPhone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2008" editable="false">
<dName dataType="nvarchar">Area Supervisor Type</dName>
<dColumn>AreaSupervisorType</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2009" editable="false">
<dName dataType="nvarchar">Business Address1</dName>
<dColumn>BusinessAddress1</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2010" editable="false">
<dName dataType="nvarchar">Business Address2</dName>
<dColumn>BusinessAddress2</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2011" editable="false">
<dName dataType="nvarchar">Business City</dName>
<dColumn>BusinessCity</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2012" editable="false">
<dName dataType="nvarchar">Business Country</dName>
<dColumn>BusinessCountry</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2013" editable="false">
<dName dataType="nvarchar">Business Email</dName>
<dColumn>BusinessEmail</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="260" editable="true">
<dName dataType="nvarchar">Business Name</dName>
<dColumn>BusinessName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210061" editable="true">
<dName>Business Partner</dName>
<dColumn>[BusinessPartner]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2015" editable="false">
<dName dataType="nvarchar">Business Phone</dName>
<dColumn>BusinessPhone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2016" editable="false">
<dName dataType="nvarchar">Business State</dName>
<dColumn>BusinessState</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2017" editable="false">
<dName dataType="nvarchar">Business Zip</dName>
<dColumn>Zip</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="220" editable="true">
<dName dataType="nvarchar">City</dName>
<dColumn>City</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000460" editable="true">
<dName>Comp</dName>
<dColumn>[Comp]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000840" editable="true">
<dName dataType="nvarchar">Comp Status</dName>
<dColumn>[CompStatus]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210041" editable="true">
<dName>Company</dName>
<dColumn>[Company]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000820" editable="true">
<dName dataType="nvarchar">Corp or Franch</dName>
<dColumn>[CorporFranch]</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="240" editable="true">
<dName dataType="nvarchar">County</dName>
<dColumn>County</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000640" editable="true">
<dName>DE dim</dName>
<dColumn>[DEdim]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000440" editable="true">
<dName>Dallas Group</dName>
<dColumn>[DallasGroup]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000610" editable="true">
<dName>DidThisChange</dName>
<dColumn>[sddssdfa]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000870" editable="true">
<dName dataType="tinyint">Dina Test Dimension</dName>
<dColumn>[DinaTestDimension]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210051" editable="true">
<dName>District</dName>
<dColumn>[District]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000650" editable="true">
<dName>FireDim</dName>
<dColumn>[FireDim]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2018" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor Email</dName>
<dColumn>FranchAreaSupervisorEmail</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2019" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor First Name</dName>
<dColumn>FranchAreaSupervisorFirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2020" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor Full Name</dName>
<dColumn>FranchAreaSupervisorFullName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2021" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor Last Name</dName>
<dColumn>FranchAreaSupervisorLastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2022" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor Mobile</dName>
<dColumn>FranchAreaSupervisorMobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2023" editable="false">
<dName dataType="nvarchar">Franch Area Supervisor Phone</dName>
<dColumn>FranchAreaSupervisorPhone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="false" dDimMaintColOrder="0" dNum="230">
<dName>General Manager</dName>
<dColumn>[General Manager]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000470" editable="true">
<dName>LTO</dName>
<dColumn>[LTO]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2024" editable="false">
<dName dataType="float">Location ID</dName>
<dColumn>LocationID</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2025" editable="false">
<dName dataType="float">Old Location ID</dName>
<dColumn>OldLocationID</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2026" editable="false">
<dName dataType="nvarchar">Owner1 Email Address</dName>
<dColumn>Owner1EmailAddress</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2027" editable="false">
<dName dataType="nvarchar">Owner1 Fax</dName>
<dColumn>Owner1Fax</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2028" editable="false">
<dName dataType="nvarchar">Owner1 First Name</dName>
<dColumn>Owner1FirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2029" editable="false">
<dName dataType="nvarchar">Owner1 Last Name</dName>
<dColumn>Owner1LastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2030" editable="false">
<dName dataType="nvarchar">Owner1 Mobile</dName>
<dColumn>Owner1Mobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2031" editable="false">
<dName dataType="float">Owner1 Ownership</dName>
<dColumn>[Owner1%Ownership]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2032" editable="false">
<dName dataType="nvarchar">Owner1 Phone</dName>
<dColumn>Owner1Phone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2033" editable="false">
<dName dataType="nvarchar">Owner2 Email Address</dName>
<dColumn>Owner2EmailAddress</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2034" editable="false">
<dName dataType="nvarchar">Owner2 Fax</dName>
<dColumn>Owner2Fax</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2035" editable="false">
<dName dataType="nvarchar">Owner2 First Name</dName>
<dColumn>Owner2FirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2036" editable="false">
<dName dataType="nvarchar">Owner2 Last Name</dName>
<dColumn>Owner2LastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2037" editable="false">
<dName dataType="nvarchar">Owner2 Mobile</dName>
<dColumn>Owner2Mobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2038" editable="false">
<dName dataType="float">Owner2 Ownership</dName>
<dColumn>[Owner2%Ownership]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2039" editable="false">
<dName dataType="nvarchar">Owner2 Phone</dName>
<dColumn>Owner2Phone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2040" editable="false">
<dName dataType="nvarchar">Owner3 Email Address</dName>
<dColumn>Owner3EmailAddress</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2041" editable="false">
<dName dataType="nvarchar">Owner3 Fax</dName>
<dColumn>Owner3Fax</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2042" editable="false">
<dName dataType="nvarchar">Owner3 First Name</dName>
<dColumn>Owner3FirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2043" editable="false">
<dName dataType="nvarchar">Owner3 Last Name</dName>
<dColumn>Owner3LastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2044" editable="false">
<dName dataType="nvarchar">Owner3 Mobile</dName>
<dColumn>Owner3Mobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2045" editable="false">
<dName dataType="nvarchar">Owner3 Ownership</dName>
<dColumn>[Owner3%Ownership]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2046" editable="false">
<dName dataType="nvarchar">Owner3 Phone</dName>
<dColumn>Owner3Phone</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="235" editable="true">
<dName dataType="nvarchar">PM</dName>
<dColumn>PM</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210081" editable="true">
<dName>POS</dName>
<dColumn>[POS]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="261" editable="true">
<dName dataType="nvarchar">Parent Company</dName>
<dColumn>ParentCompany</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000680" editable="true">
<dName>Patio</dName>
<dColumn>[Patio]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000910" editable="true">
<dName dataType="nvarchar">Payroll Code</dName>
<dColumn>[PayrollCode]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210031" editable="true">
<dName>Phone Number</dName>
<dColumn>[Phone Number]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000480" editable="true">
<dName>Radio Promotion</dName>
<dColumn>[RadioPromotion]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2048" editable="false">
<dName dataType="float">Reference ID</dName>
<dColumn>ReferenceID</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000620" editable="true">
<dName>Regional Manager</dName>
<dColumn>[RegionalManager]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210071" editable="true">
<dName>Remodel</dName>
<dColumn>[Remodel]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000810" editable="true">
<dName dataType="nvarchar">Revenue Band</dName>
<dColumn>[RevenueBand]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2049" editable="false">
<dName dataType="datetime">Same Store Date</dName>
<dColumn>SameStoreDate</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2050" editable="false">
<dName dataType="nvarchar">Same Store Reporting</dName>
<dColumn>SameStoreReporting</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2051" editable="false">
<dName dataType="nvarchar">Site Address 1</dName>
<dColumn>SiteAddress1</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2052" editable="false">
<dName dataType="nvarchar">Site Address 2</dName>
<dColumn>SiteAddress2</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2053" editable="false">
<dName dataType="nvarchar">Site City</dName>
<dColumn>SiteCity</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2054" editable="false">
<dName dataType="nvarchar">Site Contract Type</dName>
<dColumn>SiteContractType</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2055" editable="false">
<dName dataType="nvarchar">Site Contract Year</dName>
<dColumn>SiteContractYear</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2056" editable="false">
<dName dataType="nvarchar">Site Country</dName>
<dColumn>SiteCountry</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2057" editable="false">
<dName dataType="nvarchar">Site DMA</dName>
<dColumn>SiteDMA</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2058" editable="false">
<dName dataType="nvarchar">Site Fax</dName>
<dColumn>SiteFax</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2059" editable="false">
<dName dataType="nvarchar">Site Long Name</dName>
<dColumn>SiteLongName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2060" editable="false">
<dName dataType="nvarchar">Site Manaager Last Name</dName>
<dColumn>SiteManaagerLastName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2061" editable="false">
<dName dataType="nvarchar">Site Manager Email</dName>
<dColumn>SiteManagerEmail</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2062" editable="false">
<dName dataType="nvarchar">Site Manager First Name</dName>
<dColumn>SiteManagerFirstName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2063" editable="false">
<dName dataType="nvarchar">Site Manager Full Name</dName>
<dColumn>SiteManagerFullName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2064" editable="false">
<dName dataType="nvarchar">Site Manager Mobile</dName>
<dColumn>SiteManagerMobile</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2065" editable="false">
<dName dataType="nvarchar">Site Manager Phone</dName>
<dColumn>SiteManagerPhone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2066" editable="false">
<dName dataType="datetime">Site Opening Date</dName>
<dColumn>SiteOpeningDate</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2067" editable="false">
<dName dataType="nvarchar">Site Phone</dName>
<dColumn>SitePhone</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2068" editable="false">
<dName dataType="nvarchar">Site Short Name</dName>
<dColumn>SiteShortName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2069" editable="false">
<dName dataType="nvarchar">Site State</dName>
<dColumn>SiteState</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2070" editable="false">
<dName dataType="nvarchar">Site Zip</dName>
<dColumn>SiteZip</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="225" editable="true">
<dName dataType="nvarchar">State</dName>
<dColumn>State</dColumn>
</d>
<d_dm SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="204" editable="false">
<dName dataType="smalldatetime">Store Effdate</dName>
<dColumn>EffDate</dColumn>
</d_dm>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="2" dNum="200" editable="true">
<dName dataType="nvarchar">Store Name</dName>
<dColumn>StoreName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="205" editable="false">
<dName dataType="int">Store Num</dName>
<dColumn>StoreNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000540" editable="true">
<dName>Store Test Date</dName>
<dColumn>[StoreTestDate]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000450" editable="true">
<dName>TEST</dName>
<dColumn>[TEST]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000690" editable="true">
<dName>TEST2</dName>
<dColumn>[TEST2]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000570" editable="true">
<dName>Test Date Four</dName>
<dColumn>[TestDateFour]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000560" editable="true">
<dName>Test Date Three</dName>
<dColumn>[TestDateThree]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000550" editable="true">
<dName>Test Date Two</dName>
<dColumn>[TestDateTwo]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000590" editable="true">
<dName>True False</dName>
<dColumn>[TrueFalse]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000580" editable="true">
<dName>Zinburger</dName>
<dColumn>[Zinburger]</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="215" editable="true">
<dName dataType="nvarchar">Zip</dName>
<dColumn>Zip</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000660" editable="true">
<dName>espresso</dName>
<dColumn>[espresso]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000800" editable="true">
<dName dataType="tinyint">test3</dName>
<dColumn>[test3]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000860" editable="true">
<dName dataType="tinyint">testing new dimension add</dName>
<dColumn>[testingnewdimensionadd]</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="205" inDimMaint="false" insert="0" keyfield="pPmNum" name="PM" table="vd_PM">
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="235" editable="true">
<dName dataType="nvarchar">PM</dName>
<dColumn>PM</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="300" inDimMaint="true" insert="2" keyfield="iItem" name="Item" table="d_Items">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000890" editable="true">
<dName dataType="tinyint">AC5481 Dina</dName>
<dColumn>[AC5481Dina]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000710" editable="true">
<dName dataType="int">CHTest</dName>
<dColumn>[CHTest]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000830" editable="true">
<dName dataType="nvarchar">Entree</dName>
<dColumn>[Entree]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000880" editable="true">
<dName dataType="tinyint">For AC 5481</dName>
<dColumn>[ForAC5481]</dColumn>
</d>
<d_dm SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="304" editable="false">
<dName dataType="smalldatetime">Item Effdate</dName>
<dColumn>EffDate</dColumn>
</d_dm>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="2" dNum="300" editable="false">
<dName dataType="nvarchar">Item Name</dName>
<dColumn>ItemName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="305" editable="false">
<dName dataType="int">Item Number</dName>
<dColumn>ItemNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000670" editable="true">
<dName dataType="nvarchar">LTO</dName>
<dColumn>[LTO]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000630" editable="true">
<dName dataType="tinyint">Ltest</dName>
<dColumn>[Ltest]</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="310" editable="false">
<dName dataType="nvarchar">Major Name</dName>
<dColumn>MajorName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="320" editable="false">
<dName dataType="tinyint">Major Num</dName>
<dColumn>MajorNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000850" editable="true">
<dName dataType="nvarchar">Master Item</dName>
<dColumn>[MasterItem]</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="315" editable="true">
<dName dataType="nvarchar">Minor Name</dName>
<dColumn>MinorName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="330" editable="true">
<dName dataType="tinyint">Minor Num</dName>
<dColumn>MinorNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000700" editable="true">
<dName dataType="nvarchar">Plates</dName>
<dColumn>[Plates]</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="400" inDimMaint="true" insert="0" keyfield="dpDaypart" name="Daypart" table="vd_Dayparts">
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="430" editable="false">
<dName dataType="int">DayPart Num</dName>
<dColumn>DaypartNumClient</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="400" editable="false">
<dName dataType="nvarchar">Daypart</dName>
<dColumn>DaypartName</dColumn>
</d>
<d_dm SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="404" editable="false">
<dName dataType="smalldatetime">Daypart Effdate</dName>
<dColumn>EffDate</dColumn>
</d_dm>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="500" inDimMaint="false" insert="0" keyfield="cCostCenter" name="Cost Center" table="vd_CostCenters">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="2" dNum="500" editable="true">
<dName dataType="nvarchar">Cost Center</dName>
<dColumn>CostCenterName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="510" editable="true">
<dName dataType="int">Cost Center Num</dName>
<dColumn>CostCenterNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="600" inDimMaint="false" insert="0" keyfield="eEmpl" name="Employee" table="vd_Employees">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="620" editable="true">
<dName dataType="nvarchar">Alt Empl Num</dName>
<dColumn>AltEmplNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="2" dNum="600" editable="true">
<dName dataType="nvarchar">Employee Name</dName>
<dColumn>FullName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="605" editable="true">
<dName dataType="int">Employee Number</dName>
<dColumn>eEmplNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="650" inDimMaint="false" insert="0" keyfield="eEmpl" name="sEmployee" table="d_Employees_Sched">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="670" editable="true">
<dName dataType="nvarchar">sAlt Empl Num</dName>
<dColumn>AltEmplNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="660" editable="true">
<dName dataType="varchar">sEmpl Active Status</dName>
<dColumn>ActiveInactiveStatus</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="655" editable="true">
<dName dataType="int">sEmpl Number</dName>
<dColumn>eEmplNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="2" dNum="650" editable="true">
<dName dataType="nvarchar">sEmployee Name</dName>
<dColumn>FullName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="6065" editable="true">
<dName dataType="nvarchar">sUnknown Emp</dName>
<dColumn>[UnknownEmp]</dColumn>
</d>
</g>
<g compGrain="false" degen="true" global="false" hide="-1" id="800" inDimMaint="false" insert="0" keyfield="cCheck" name="Check" table="d_Checks">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="800" editable="true">
<dName>Check Number</dName>
<dColumn>CheckNumber</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="900" inDimMaint="false" insert="0" keyfield="tTender" name="Tender" table="vd_Tenders">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="900" editable="true">
<dName dataType="varchar">Tender Name</dName>
<dColumn>TenderName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="910" editable="true">
<dName dataType="int">Tender Num</dName>
<dColumn>TenderNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1100" inDimMaint="false" insert="0" keyfield="dDiscount" name="Discount" table="d_Discounts">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="1100" editable="true">
<dName dataType="nvarchar">Discount Name</dName>
<dColumn>DiscName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1107" editable="true">
<dName dataType="int">Discount Num</dName>
<dColumn>DiscNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1200" inDimMaint="false" insert="0" keyfield="aGLAcct" name="GLAccount" table="vd_GLAccts">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1210" editable="true">
<dName dataType="nvarchar">GLAccount Name</dName>
<dColumn>GLAcctName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1200" editable="true">
<dName dataType="char">GLAccount Num</dName>
<dColumn>GLAcctNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1300" inDimMaint="true" insert="3" keyfield="jJob" name="Job" table="d_Jobs">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000430" editable="true">
<dName dataType="int">Add Dimension in Chrome</dName>
<dColumn>[AddDimensioninChrome]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000410" editable="true">
<dName dataType="nvarchar">Add Dimension in FireFox 10</dName>
<dColumn>[AddDimensioninFireFox10]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000420" editable="true">
<dName dataType="nvarchar">Add Dimension in IE 8</dName>
<dColumn>[AddDimensioninIE8]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000500" editable="true">
<dName dataType="nvarchar">City</dName>
<dColumn>[City]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000720" editable="true">
<dName dataType="nvarchar">Delyth</dName>
<dColumn>[Delyth]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000790" editable="true">
<dName dataType="nvarchar">Delythie9</dName>
<dColumn>[Delythie9]</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1315" editable="false">
<dName dataType="nvarchar">Department Name</dName>
<dColumn>DeptName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1310" editable="false">
<dName dataType="int">Department Num</dName>
<dColumn>DeptNumClient</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1320" editable="true">
<dName dataType="nvarchar">Employee Type</dName>
<dColumn>JobType</dColumn>
</d>
<d_dm SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1304" editable="false">
<dName dataType="smalldatetime">Job Effdate</dName>
<dColumn>EffDate</dColumn>
</d_dm>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1305" editable="false">
<dName dataType="nvarchar">Job Name</dName>
<dColumn>JobName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1300" editable="false">
<dName dataType="int">Job Num</dName>
<dColumn>JobNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210091" editable="true">
<dName dataType="nvarchar">Job Rotation</dName>
<dColumn>[JobRotation]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="5130" editable="true">
<dName dataType="nvarchar">Job Testing</dName>
<dColumn>[Job Testing]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000490" editable="true">
<dName dataType="nvarchar">Job Testing 1</dName>
<dColumn>[JobTesting]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000510" editable="true">
<dName dataType="nvarchar">Job Testing 2</dName>
<dColumn>[JobTesting2]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000730" editable="true">
<dName dataType="nvarchar">Sarah</dName>
<dColumn>[Sarah]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000740" editable="true">
<dName dataType="decimal">SarahTest</dName>
<dColumn>[SarahTest]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000750" editable="true">
<dName dataType="decimal">SarahTest2</dName>
<dColumn>[SarahTest2]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000760" editable="true">
<dName dataType="decimal">SarahTest3</dName>
<dColumn>[SarahTest3]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000770" editable="true">
<dName dataType="int">SarahTest4</dName>
<dColumn>[SarahTest4]</dColumn>
</d>
<d_dm SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1325" editable="false">
<dName dataType="int">Store Num</dName>
<dColumn>jStoreNumClient</dColumn>
</d_dm>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000520" editable="true">
<dName dataType="nvarchar">Test Date</dName>
<dColumn>[TestDate]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000530" editable="true">
<dName dataType="date">Test Date 2</dName>
<dColumn>[TestDate2]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210101" editable="true">
<dName dataType="nvarchar">Testing Multiple Changes</dName>
<dColumn>[TestingMultipleChanges]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000600" editable="true">
<dName dataType="tinyint">TrueFalse</dName>
<dColumn>[TrueFalse]</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000780" editable="true">
<dName dataType="nvarchar">prycetest</dName>
<dColumn>[prycetest]</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1350" inDimMaint="false" insert="0" keyfield="jJob" name="sJob" table="d_Jobs_Sched">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1365" editable="true">
<dName dataType="nvarchar">sDepartment Name</dName>
<dColumn>DeptName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1360" editable="false">
<dName dataType="int">sDepartment Number</dName>
<dColumn>DeptNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1370" editable="true">
<dName dataType="varchar">sFOHBOH</dName>
<dColumn>FOHBOH</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1355" editable="true">
<dName dataType="nvarchar">sJob Name</dName>
<dColumn>JobName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="0" dNum="1350" editable="false">
<dName dataType="int">sJob Number</dName>
<dColumn>JobNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1380" editable="true">
<dName dataType="varchar">sPlanned</dName>
<dColumn>Planned</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1410" inDimMaint="false" insert="0" keyfield="hHour" name="Hour" table="vd_Hours">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="1410" editable="true">
<dName dataType="nvarchar">Hour</dName>
<dColumn>HourNameWhole</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1411" editable="false">
<dName dataType="varchar">Shift</dName>
<dColumn>Shift</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1430" inDimMaint="false" insert="0" keyfield="qhQuarterHour" name="Quarter Hour" table="vd_QuarterHours">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1420" editable="true">
<dName dataType="nvarchar">Half Hour</dName>
<dColumn>HalfHourNameWhole</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1430" editable="true">
<dName dataType="nvarchar">Quarter Hour</dName>
<dColumn>QuarterHourNameWhole</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1440" inDimMaint="false" insert="0" keyfield="mMinute" name="Minute" table="vd_Minutes">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1440" editable="true">
<dName dataType="nvarchar">Minute</dName>
<dColumn>MinuteNameWhole</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="1700" inDimMaint="false" insert="0" keyfield="soseSpeedOfServiceEvent" name="SOS Event" table="vd_SpeedOfServiceEvents">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="1700" editable="true">
<dName dataType="varchar">SOS Event Name</dName>
<dColumn>SpeedOfServiceEventName</dColumn>
</d>
</g>
<g compGrain="true" degen="false" global="false" hide="-1" id="3000" inDimMaint="false" insert="0" keyfield="tNum" name="Time Selection" table="m_TimeSelections">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000" editable="true">
<dName>Time Selection</dName>
<dColumn>TimeSelection</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="5000" inDimMaint="false" insert="0" keyfield="iIngredient" name="Ingredients" table="d_RawMatIngredients">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="5020" editable="true">
<dName dataType="varchar">Ingredient Name</dName>
<dColumn>RawMaterialItemNameClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="5010" editable="true">
<dName dataType="varchar">Ingredient Num</dName>
<dColumn>IngredientIDClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="5100" inDimMaint="false" insert="0" keyfield="RawMatCatNumClient" name="RawMat Categories" table="vd_RawMatCategories">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="5120" editable="true">
<dName dataType="varchar">Raw Mat Name</dName>
<dColumn>RawMatCatNameClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="5110" editable="true">
<dName dataType="int">Raw Mat Num</dName>
<dColumn>RawMatCatNumClient</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="35000" inDimMaint="false" insert="0" keyfield="iIngred" name="Ingredient" table="d_Ingreds">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="37000" editable="true">
<dName dataType="nvarchar">Expense Group</dName>
<dColumn>ExpenseGroup</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="35500" editable="true">
<dName dataType="char">GL Acct</dName>
<dColumn>ExpAcct</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="36500" editable="true">
<dName dataType="nvarchar">Group Name</dName>
<dColumn>GroupName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="38500" editable="true">
<dName dataType="smallint">Group Num</dName>
<dColumn>GroupNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="35000" editable="true">
<dName dataType="nvarchar">Ingredient Name</dName>
<dColumn>IngName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="34500" editable="true">
<dName dataType="smallint">Ingredient Number</dName>
<dColumn>IngredNumClient</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="37500" editable="true">
<dName dataType="nvarchar">PNL Budget Group</dName>
<dColumn>pnlbudgetgroup</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="38510" editable="true">
<dName dataType="nvarchar">Pappas COS Major Cat</dName>
<dColumn>PappasCOSMajorCat</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="38520" editable="true">
<dName dataType="nvarchar">Pappas COS Minor Cat</dName>
<dColumn>PappasCOSMinorCat</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="36000" editable="true">
<dName dataType="nvarchar">Sales Category Name</dName>
<dColumn>SalesCatName</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="110011" inDimMaint="false" insert="0" keyfield="mMethod" name="Forecast Type" table="d_ForecastMethods">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="110011" editable="true">
<dName dataType="varchar">Method Type</dName>
<dColumn>MethodType</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="150000" inDimMaint="false" insert="0" keyfield="iInvoice" name="Invoice" table="d_Invoices">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="150000" editable="true">
<dName dataType="nvarchar">Invoice Number</dName>
<dColumn>InvoiceNum</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="160000" inDimMaint="false" insert="0" keyfield="vVendor" name="Vendors" table="d_Vendors">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="160000" editable="true">
<dName dataType="nvarchar">Vendor</dName>
<dColumn>[Name]</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="210010" inDimMaint="false" insert="0" keyfield="aAcct" name="Account" table="d_Accounts_PL_Input">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210012" editable="true">
<dName dataType="nvarchar">Account Name</dName>
<dColumn>AcctName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210011" editable="true">
<dName dataType="nvarchar">Account Name Corp</dName>
<dColumn>AcctNameCorp</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210013" editable="true">
<dName dataType="nvarchar">Major Group</dName>
<dColumn>MajorAcct</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210014" editable="true">
<dName dataType="nvarchar">Minor Group</dName>
<dColumn>MinorAcct</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="210020" inDimMaint="false" insert="0" keyfield="rRevGroup" name="Revenue Group" table="d_RevGroup">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="210021" editable="true">
<dName dataType="nvarchar">Revenue Band</dName>
<dColumn>AnualGroupName</dColumn>
</d>
</g>
<g compGrain="false" degen="true" global="false" hide="-1" id="3000200" inDimMaint="false" insert="0" keyfield="gTskSeq" name="Task Seq" table="d_Generate">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000200" editable="true">
<dName>Task Seq</dName>
<dColumn>gTskSeq</dColumn>
</d>
</g>
<g compGrain="false" degen="true" global="false" hide="-1" id="3000300" inDimMaint="false" insert="0" keyfield="gLogSeq" name="Log Seq" table="d_Generate">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000300" editable="true">
<dName>Log Seq</dName>
<dColumn>gLogSeq</dColumn>
</d>
</g>
<g compGrain="false" degen="true" global="false" hide="-1" id="3000400" inDimMaint="false" insert="0" keyfield="gShiftSeq" name="Shift Seq" table="d_Generate">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="3000400" editable="true">
<dName>Shift Seq</dName>
<dColumn>gShiftSeq</dColumn>
</d>
</g>
<g compGrain="false" degen="false" global="false" hide="-1" id="32000" inDimMaint="true" insert="2" keyfield="gGLChartofAccount" name="GL Accounts" table="d_GLChartofAccounts">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32020" editable="true">
<dName dataType="varchar">Debit-Credit</dName>
<dColumn>DebitCredit</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32010" editable="true">
<dName dataType="varchar">GL Acct Name</dName>
<dColumn>GLAcctName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="32000" editable="false">
<dName dataType="decimal">GL Acct Num</dName>
<dColumn>GLAcctNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32030" editable="true">
<dName dataType="varchar">GL Acct Type</dName>
<dColumn>GLAcctType</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32130" editable="true">
<dName dataType="int">GL Cash Flow Cat Num</dName>
<dColumn>GLCashFlowCatNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32140" editable="true">
<dName dataType="varchar">GL Main Group Name</dName>
<dColumn>GLMainGroupName</dColumn>
</d>
<d SCD="0" activeKey="1" dDimMaint="true" dDimMaintColOrder="1" dNum="32120" editable="true">
<dName dataType="decimal">GL Main Group Num</dName>
<dColumn>GLMainGroupNum</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32110" editable="true">
<dName dataType="varchar">GL Statement Cat Name</dName>
<dColumn>GLStatementCatName</dColumn>
</d>
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="1" dNum="32100" editable="true">
<dName dataType="int">GL Statement Cat Num</dName>
<dColumn>GLStatementCatNum</dColumn>
</d>
</g>
<g compGrain="false" degen="true" global="false" hide="-1" id="2000200" inDimMaint="false" insert="0" keyfield="gFileSeqNum" name="File Seq" table="d_Generate">
<d SCD="0" activeKey="0" dDimMaint="true" dDimMaintColOrder="0" dNum="2000200" editable="true">
<dName>File Seq</dName>
<dColumn>gFileSeqNum</dColumn>
</d>
</g>
</grains>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment