<?xml version="1.0" encoding="utf-8"?>
<analysisDatabase version="2" name="" color="#FFD3D3D3" locked="false" standard="false">
  <designertabs>
    <tab name="Sales" />
    <tab name="Finance" />
    <tab name="Production" />
    <tab name="Inventory" />
    <tab name="HR" />
  </designertabs>
  <tablerelations>
    <table catalog="" schema="" name="fSalesInvoiceLine">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="32" y="37" width="198" height="438" />
      <join detailcatalog="" detailschema="" detailtable="dSalesInvoiceHeader" lastmodified="2020-03-09T08:13:04.5276297Z">
        <joincolumn master="dSalesInvoiceHeader_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dItem" lastmodified="2020-03-09T08:13:19.7565262Z">
        <joincolumn master="dItem_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="Return_Reason_view" lastmodified="2020-03-09T08:30:33.5010906Z">
        <joincolumn master="ReturnReason" detail="ReturnReason" />
      </join>
    </table>
    <table catalog="" schema="" name="dSalesInvoiceHeader">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="406" y="165" width="150" height="200" />
      <join detailcatalog="" detailschema="" detailtable="dCompany" lastmodified="2020-03-09T08:31:16.9299573Z">
        <joincolumn master="dCompany_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dCustomer" lastmodified="2020-03-09T08:32:52.2846229Z">
        <joincolumn master="dCustomer_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-09T08:33:05.5746082Z">
        <joincolumn master="dPostingDate_ID" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dSalesperson" lastmodified="2020-03-09T08:33:33.815663Z">
        <joincolumn master="dSalesPerson_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="ExpectedPeriod_view" lastmodified="2020-03-10T06:55:07.4745942Z">
        <joincolumn master="dPostingDate_ID" detail="TheDate" />
      </join>
    </table>
    <table catalog="" schema="" name="dItem">
      <bounds tab="Global" collapsed="false" x="9" y="12" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="727" y="680" width="150" height="180" />
      <bounds tab="Production" collapsed="false" x="721" y="307" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="723" y="245" width="150" height="200" />
      <join detailcatalog="" detailschema="" detailtable="dItemGroup" lastmodified="2020-03-09T08:37:09.6031712Z">
        <joincolumn master="dItemGroup_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="Return_Reason_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="400" y="651" width="207" height="64" />
    </table>
    <table catalog="" schema="" name="dCompany">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="725" y="40" width="150" height="67" />
      <bounds tab="Finance" collapsed="false" x="671" y="48" width="150" height="117" />
      <bounds tab="Production" collapsed="false" x="720" y="45" width="150" height="115" />
      <bounds tab="Inventory" collapsed="false" x="726" y="58" width="150" height="114" />
    </table>
    <table catalog="" schema="" name="dCustomer">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="724" y="395" width="150" height="188" />
      <join detailcatalog="" detailschema="" detailtable="dCountry" lastmodified="2020-03-09T08:34:41.136153Z">
        <joincolumn master="dCountry_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dRegion" lastmodified="2020-03-09T08:34:44.1288436Z">
        <joincolumn master="dRegion_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="dPostingPeriod">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="1138" y="900" width="186" height="130" />
      <bounds tab="Finance" collapsed="false" x="1066" y="689" width="150" height="200" />
      <bounds tab="Production" collapsed="false" x="1000" y="730" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="965" y="708" width="150" height="200" />
      <bounds tab="HR" collapsed="false" x="1049" y="659" width="150" height="200" />
    </table>
    <table catalog="" schema="" name="dSalesperson">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="724" y="158" width="150" height="204" />
      <bounds tab="HR" collapsed="false" x="188" y="381" width="150" height="200" />
    </table>
    <table catalog="" schema="" name="dCountry">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="947" y="369" width="150" height="180" />
      <join detailcatalog="" detailschema="" detailtable="dTerritory" lastmodified="2020-03-09T12:02:58.3168402Z">
        <joincolumn master="dTerritory_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="dRegion">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="948" y="563" width="150" height="69" />
    </table>
    <table catalog="" schema="" name="dItemGroup">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="948" y="679" width="150" height="71" />
      <bounds tab="Production" collapsed="false" x="940" y="314" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="938" y="247" width="150" height="113" />
    </table>
    <table catalog="" schema="" name="fSalesPipeline">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="42" y="586" width="185" height="530" />
      <join detailcatalog="" detailschema="" detailtable="dCompany" lastmodified="2020-03-09T11:45:05.0457953Z">
        <joincolumn master="dCompany_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dCustomer" lastmodified="2020-03-09T11:45:22.2414581Z">
        <joincolumn master="dCustomer_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dSalesperson" lastmodified="2020-03-09T11:45:50.2331461Z">
        <joincolumn master="dSalesPerson_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="Probability_view" lastmodified="2020-03-09T11:49:48.1424814Z">
        <joincolumn master="Probability" detail="Probability" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="Opportunity_view" lastmodified="2020-03-09T11:49:53.9306267Z">
        <joincolumn master="row number" detail="Opportunity Number" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="ExpectedPeriod_view" lastmodified="2020-03-10T06:55:18.6231492Z">
        <joincolumn master="Expected date" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="CreatedPeriod_view" lastmodified="2020-03-10T06:55:29.0613216Z">
        <joincolumn master="Created Date" detail="TheDate" />
      </join>
    </table>
    <table catalog="" schema="" name="Opportunity_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="390" y="983" width="189" height="72" />
    </table>
    <table catalog="" schema="" name="Probability_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="391" y="875" width="179" height="68" />
    </table>
    <table catalog="" schema="" name="dTerritory">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="1162" y="458" width="150" height="71" />
    </table>
    <table catalog="" schema="" name="CreatedPeriod_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="1140" y="1197" width="188" height="111" />
    </table>
    <table catalog="" schema="" name="ExpectedPeriod_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Sales" collapsed="false" x="1138" y="1059" width="189" height="112" />
    </table>
    <table catalog="" schema="" name="fGLEntry">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Finance" collapsed="false" x="51" y="48" width="150" height="451" />
      <join detailcatalog="" detailschema="" detailtable="dCompany" lastmodified="2020-03-10T07:09:58.3400125Z">
        <joincolumn master="dCompany_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-10T07:10:06.7620426Z">
        <joincolumn master="dPostingPeriod_ID" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dDepartment" lastmodified="2020-03-10T07:10:16.6780761Z">
        <joincolumn master="dDepartment_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dGLAccount" lastmodified="2020-03-10T07:10:26.3640333Z">
        <joincolumn master="dGLAccount_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dtranstype" lastmodified="2020-03-10T07:10:32.6782223Z">
        <joincolumn master="dTransType_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="dDepartment">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Finance" collapsed="false" x="670" y="209" width="150" height="118" />
    </table>
    <table catalog="" schema="" name="dtranstype">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Finance" collapsed="false" x="671" y="382" width="150" height="99" />
    </table>
    <table catalog="" schema="" name="dGLAccount">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Finance" collapsed="false" x="262" y="641" width="150" height="269" />
    </table>
    <table catalog="" schema="" name="fProduction">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Production" collapsed="false" x="48" y="41" width="172" height="429" />
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-10T07:59:30.2967742Z">
        <joincolumn master="dPostingDate_ID" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dCompany" lastmodified="2020-03-10T07:59:51.4767701Z">
        <joincolumn master="dCompany_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dItem" lastmodified="2020-03-10T08:00:12.5238267Z">
        <joincolumn master="dItem_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="fItemLedgerEntry">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="40" y="54" width="150" height="351" />
      <join detailcatalog="" detailschema="" detailtable="dCompany" lastmodified="2020-03-10T08:46:26.5836195Z">
        <joincolumn master="dCompanyID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dItem" lastmodified="2020-03-10T08:46:30.1689158Z">
        <joincolumn master="dItem_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-10T08:46:42.9971526Z">
        <joincolumn master="dPostingPeriod_ID" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dLocation" lastmodified="2020-03-10T08:47:11.8153278Z">
        <joincolumn master="dLocation_ID" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dItemEntryType" lastmodified="2020-03-10T08:47:52.1440645Z">
        <joincolumn master="dItemEntryType_ID" detail="ID" />
      </join>
    </table>
    <table catalog="" schema="" name="dLocation">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="327" y="557" width="150" height="117" />
    </table>
    <table catalog="" schema="" name="dItemEntryType">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="Inventory" collapsed="false" x="323" y="359" width="150" height="110" />
    </table>
    <table catalog="" schema="" name="fAbsence">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="HR" collapsed="false" x="46" y="57" width="150" height="278" />
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-10T09:11:16.8626651Z">
        <joincolumn master="Date" detail="TheDate" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="dSalesperson" lastmodified="2020-03-10T09:11:45.3237703Z">
        <joincolumn master="Employee No" detail="ID" />
      </join>
      <join detailcatalog="" detailschema="" detailtable="Absence_view" lastmodified="2020-03-10T09:17:14.1320744Z">
        <joincolumn master="Absence Reason Code" detail="Absence Reason Code" />
      </join>
    </table>
    <table catalog="" schema="" name="Staff_Turnover">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="HR" collapsed="false" x="51" y="642" width="150" height="200" />
      <join detailcatalog="" detailschema="" detailtable="dPostingPeriod" lastmodified="2020-03-10T09:11:22.9801927Z">
        <joincolumn master="TheDate" detail="TheDate" />
      </join>
    </table>
    <table catalog="" schema="" name="Absence_view">
      <bounds tab="Global" collapsed="false" x="10" y="10" width="150" height="200" />
      <bounds tab="HR" collapsed="false" x="548" y="65" width="150" height="200" />
    </table>
  </tablerelations>
  <shareddimensions>
    <dimension name="Item Name" visible="true" type="regular" lastmodified="2021-10-08T12:37:16.8762806Z">
      <hierarchy name="Item Name" visible="true" displayfolder="Item" lastmodified="2021-10-08T12:37:16.8762806Z">
        <table catalog="" schema="">dItem</table>
        <level name="Item.Name" order="key" type="regular" lastmodified="2020-03-10T08:01:09.8726327Z">
          <namecolumn datatype="string" datasize="0">Itemname</namecolumn>
          <keycolumn datatype="string" datasize="0">Itemname</keycolumn>
          <table catalog="" schema="">dItem</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Item Google Search URL" visible="true" type="regular" lastmodified="2021-10-08T12:31:08.813005Z">
      <hierarchy name="Item Google Search URL" visible="true" displayfolder="Item" lastmodified="2021-10-08T12:31:08.813005Z">
        <table catalog="" schema="">dItem</table>
        <level name="Google Search URL" order="name" type="regular" lastmodified="2020-03-09T08:54:16.6827482Z">
          <namecolumn datatype="string" datasize="0">GoogleSearchURL</namecolumn>
          <keycolumn datatype="string" datasize="0">GoogleSearchURL</keycolumn>
          <table catalog="" schema="">dItem</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Date" visible="true" type="time" lastmodified="2020-03-09T10:22:29.403241Z">
      <hierarchy name="Date" visible="true" displayfolder="Period" lastmodified="2020-03-09T10:22:29.403241Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:23:45.4233979Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Day of Month" visible="true" type="time" lastmodified="2020-03-09T10:22:38.5100143Z">
      <hierarchy name="Day of Month" visible="true" displayfolder="Period" lastmodified="2020-03-09T10:22:38.5100143Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <level name="Day of Month" order="key" type="timedays" lastmodified="2020-03-13T09:13:24.4248497Z">
          <namecolumn datatype="integer" datasize="0">DayofMonth</namecolumn>
          <keycolumn datatype="string" datasize="0">DayofMonthname</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Month" visible="true" type="time" lastmodified="2020-03-13T09:17:42.2271248Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Month" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:17:42.2271248Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:24:16.6933985Z">
          <namecolumn datatype="string" datasize="0">MonthName2</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Month Short" visible="true" type="time" lastmodified="2020-03-13T09:17:45.915195Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Month Short" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:17:45.915195Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month Short" order="key" type="timemonths" lastmodified="2020-03-13T09:13:41.8214355Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Quarter" visible="true" type="time" lastmodified="2020-03-13T09:17:59.9932691Z">
      <timedef>&amp;[&lt;&gt;]</timedef>
      <hierarchy name="Quarter" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:17:59.9932691Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;&gt;]</timedef>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-13T09:13:45.3638829Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">QuarterNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Weekday" visible="true" type="time" lastmodified="2020-03-09T10:22:57.3599548Z">
      <hierarchy name="Weekday" visible="true" displayfolder="Period" lastmodified="2020-03-09T10:22:57.3599548Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-13T09:13:47.2583592Z">
          <namecolumn datatype="string" datasize="0">Weekdayname2</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Weekday Short" visible="true" type="time" lastmodified="2020-03-09T10:23:00.704281Z">
      <hierarchy name="Weekday Short" visible="true" displayfolder="Period" lastmodified="2020-03-09T10:23:00.704281Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <level name="Weekday Short" order="key" type="timedays" lastmodified="2020-03-13T09:13:49.1378031Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Weeknumber" visible="true" type="time" lastmodified="2020-03-13T09:18:39.0171827Z">
      <timedef>&amp;[&lt;WW&gt;]</timedef>
      <hierarchy name="Weeknumber" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:18:39.0171827Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;WW&gt;]</timedef>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-13T09:13:51.0723739Z">
          <namecolumn datatype="string" datasize="0">Weekname</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weeknumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Year" visible="true" type="time" lastmodified="2020-03-13T09:19:17.5344843Z">
      <timedef>[&lt;&gt;]</timedef>
      <hierarchy name="Year" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:19:17.5344843Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>[&lt;&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:26:17.8313116Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="YQMD" visible="true" type="time" lastmodified="2020-03-13T09:14:52.9816802Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="YQMD" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:14:52.9816802Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-13T09:14:02.4308166Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-13T09:14:03.1206957Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">Quarter</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-13T09:14:04.0089328Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-13T09:14:04.528267Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="YWD" visible="true" type="time" lastmodified="2020-03-13T09:19:44.8757167Z">
      <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
      <hierarchy name="YWD" visible="true" displayfolder="Period" lastmodified="2020-03-13T09:19:44.8757167Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-13T09:14:07.9357578Z">
          <namecolumn datatype="string" datasize="0">Weekyear</namecolumn>
          <keycolumn datatype="string" datasize="0">Weekyear</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-13T09:14:08.5597607Z">
          <namecolumn datatype="integer" datasize="0">Weeknumber</namecolumn>
          <keycolumn datatype="integer" datasize="0">Week</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-13T09:14:09.520743Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="YMD" visible="true" type="time" lastmodified="2020-03-13T13:24:40.037817Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="YMD" visible="true" displayfolder="Period" lastmodified="2020-03-13T13:24:40.037817Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="name" type="timeyears" lastmodified="2020-03-09T10:36:06.905675Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-13T09:13:58.3227827Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-13T09:13:59.2588182Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Fiscal YMD" visible="true" type="time" lastmodified="2021-10-08T11:40:02.2417371Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Fiscal YMD" visible="true" displayfolder="Fiscal Period" lastmodified="2021-10-08T11:40:02.2417371Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-13T09:13:27.7913776Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-13T09:13:29.1411595Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-13T09:13:30.0698168Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Fiscal YQMD" visible="true" type="time" lastmodified="2021-10-08T11:46:42.2792187Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Fiscal YQMD" visible="true" displayfolder="Fiscal Period" lastmodified="2021-10-08T11:46:42.2792187Z">
        <table catalog="" schema="">dPostingPeriod</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:47:23.8083163Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-13T09:13:34.4439089Z">
          <namecolumn datatype="string" datasize="0">FiscalQuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalQuarterNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-13T09:13:35.1968102Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-13T09:13:35.8540981Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">dPostingPeriod</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Date" visible="true" type="time" lastmodified="2020-03-09T10:22:29.403241Z">
      <hierarchy name="Created Date.Date" visible="true" displayfolder="Created Date" lastmodified="2020-03-09T10:22:29.403241Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:23:45.4233979Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Day of Month" visible="true" type="time" lastmodified="2020-03-09T10:22:38.5100143Z">
      <hierarchy name="Created Date.Day of Month" visible="true" displayfolder="Created Date" lastmodified="2020-03-09T10:22:38.5100143Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <level name="Day of Month" order="key" type="timedays" lastmodified="2020-03-09T10:24:10.5288535Z">
          <namecolumn datatype="integer" datasize="0">DayofMonth</namecolumn>
          <keycolumn datatype="string" datasize="0">DayofMonthname</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Month" visible="true" type="time" lastmodified="2020-03-13T09:17:19.6783821Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Created Date.Month" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:17:19.6783821Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:24:16.6933985Z">
          <namecolumn datatype="string" datasize="0">MonthName2</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Month Short" visible="true" type="time" lastmodified="2020-03-13T09:17:22.2073281Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Created Date.Month Short" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:17:22.2073281Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month Short" order="key" type="timemonths" lastmodified="2020-03-09T10:24:23.6703548Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Quarter" visible="true" type="time" lastmodified="2020-03-13T09:18:10.7405935Z">
      <timedef>&amp;[&lt;&gt;]</timedef>
      <hierarchy name="Created Date.Quarter" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:18:10.7405935Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;]</timedef>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:24:27.2171023Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">QuarterNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Weekday" visible="true" type="time" lastmodified="2020-03-09T10:22:57.3599548Z">
      <hierarchy name="Created Date.Weekday" visible="true" displayfolder="Created Date" lastmodified="2020-03-09T10:22:57.3599548Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-09T10:24:41.2326471Z">
          <namecolumn datatype="string" datasize="0">Weekdayname2</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Weekday Short" visible="true" type="time" lastmodified="2020-03-09T10:23:00.704281Z">
      <hierarchy name="Created Date.Weekday Short" visible="true" displayfolder="Created Date" lastmodified="2020-03-09T10:23:00.704281Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <level name="Weekday Short" order="key" type="timedays" lastmodified="2020-03-09T10:24:47.3496328Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Weeknumber" visible="true" type="time" lastmodified="2020-03-13T09:18:46.4460991Z">
      <timedef>&amp;[&lt;WW&gt;]</timedef>
      <hierarchy name="Created Date.Weeknumber" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:18:46.4460991Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;WW&gt;]</timedef>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-09T10:26:12.986936Z">
          <namecolumn datatype="string" datasize="0">Weekname</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weeknumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Year" visible="true" type="time" lastmodified="2020-03-13T09:19:05.6893661Z">
      <timedef>[&lt;&gt;]</timedef>
      <hierarchy name="Created Date.Year" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:19:05.6893661Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>[&lt;&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:26:17.8313116Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.YQMD" visible="true" type="time" lastmodified="2020-03-13T09:16:52.7954389Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="Created Date.YQMD" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:16:52.7954389Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:38:01.5064355Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:38:00.839224Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">Quarter</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:38:31.7072428Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:30:39.5425085Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.YWD" visible="true" type="time" lastmodified="2020-03-13T09:19:58.1410235Z">
      <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
      <hierarchy name="Created Date.YWD" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:19:58.1410235Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:39:18.7779211Z">
          <namecolumn datatype="string" datasize="0">Weekyear</namecolumn>
          <keycolumn datatype="string" datasize="0">Weekyear</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-09T10:39:47.6594943Z">
          <namecolumn datatype="integer" datasize="0">Weeknumber</namecolumn>
          <keycolumn datatype="integer" datasize="0">Week</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-09T10:40:07.1291874Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.YMD" visible="true" type="time" lastmodified="2020-03-13T13:24:51.9647226Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="Created Date.YMD" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T13:24:51.9647226Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="name" type="timeyears" lastmodified="2020-03-09T10:36:06.905675Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:40:39.972351Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:36:07.5638539Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Fiscal YMD" visible="true" type="time" lastmodified="2020-03-13T09:20:37.8375969Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Created Date.Fiscal YMD" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:20:37.8375969Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:45:17.3321751Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:45:21.4050023Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-09T10:45:22.0077348Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Created Date.Fiscal YQMD" visible="true" type="time" lastmodified="2020-03-13T09:20:53.5899354Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Created Date.Fiscal YQMD" visible="true" displayfolder="Created Date" lastmodified="2020-03-13T09:20:53.5899354Z">
        <table catalog="" schema="">CreatedPeriod_view</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:47:23.8083163Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:47:27.8546213Z">
          <namecolumn datatype="string" datasize="0">FiscalQuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalQuarterNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:47:36.1885014Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-09T10:47:35.2704295Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">CreatedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Date" visible="true" type="time" lastmodified="2020-03-09T10:22:29.403241Z">
      <hierarchy name="Expected Date.Date" visible="true" displayfolder="Expected Date" lastmodified="2020-03-09T10:22:29.403241Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:23:45.4233979Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Day of Month" visible="true" type="time" lastmodified="2020-03-09T10:22:38.5100143Z">
      <hierarchy name="Expected Date.Day of Month" visible="true" displayfolder="Expected Date" lastmodified="2020-03-09T10:22:38.5100143Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <level name="Day of Month" order="key" type="timedays" lastmodified="2020-03-09T10:24:10.5288535Z">
          <namecolumn datatype="integer" datasize="0">DayofMonth</namecolumn>
          <keycolumn datatype="string" datasize="0">DayofMonthname</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Month" visible="true" type="time" lastmodified="2020-03-13T09:17:34.4474821Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Expected Date.Month" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:17:34.4474821Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:24:16.6933985Z">
          <namecolumn datatype="string" datasize="0">MonthName2</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Month Short" visible="true" type="time" lastmodified="2020-03-13T09:17:37.2302222Z">
      <timedef>&amp;[&lt;MM&gt;]</timedef>
      <hierarchy name="Expected Date.Month Short" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:17:37.2302222Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;MM&gt;]</timedef>
        <level name="Month Short" order="key" type="timemonths" lastmodified="2020-03-09T10:24:23.6703548Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">MonthNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Quarter" visible="true" type="time" lastmodified="2020-03-13T09:18:05.9432869Z">
      <timedef>&amp;[&lt;&gt;]</timedef>
      <hierarchy name="Expected Date.Quarter" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:18:05.9432869Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;]</timedef>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:24:27.2171023Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">QuarterNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Weekday" visible="true" type="time" lastmodified="2020-03-09T10:22:57.3599548Z">
      <hierarchy name="Expected Date.Weekday" visible="true" displayfolder="Expected Date" lastmodified="2020-03-09T10:22:57.3599548Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-09T10:24:41.2326471Z">
          <namecolumn datatype="string" datasize="0">Weekdayname2</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Weekday Short" visible="true" type="time" lastmodified="2020-03-09T10:23:00.704281Z">
      <hierarchy name="Expected Date.Weekday Short" visible="true" displayfolder="Expected Date" lastmodified="2020-03-09T10:23:00.704281Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <level name="Weekday Short" order="key" type="timedays" lastmodified="2020-03-09T10:24:47.3496328Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Weeknumber" visible="true" type="time" lastmodified="2020-03-13T09:18:43.8852811Z">
      <timedef>&amp;[&lt;WW&gt;]</timedef>
      <hierarchy name="Expected Date.Weeknumber" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:18:43.8852811Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;WW&gt;]</timedef>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-09T10:26:12.986936Z">
          <namecolumn datatype="string" datasize="0">Weekname</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weeknumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Year" visible="true" type="time" lastmodified="2020-03-13T09:19:10.5907849Z">
      <timedef>[&lt;&gt;]</timedef>
      <hierarchy name="Expected Date.Year" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:19:10.5907849Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>[&lt;&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:26:17.8313116Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.YQMD" visible="true" type="time" lastmodified="2020-03-13T09:16:48.7516859Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="Expected Date.YQMD" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:16:48.7516859Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYQ&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:38:01.5064355Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:38:00.839224Z">
          <namecolumn datatype="string" datasize="0">QuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">Quarter</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:38:31.7072428Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:30:39.5425085Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.YWD" visible="true" type="time" lastmodified="2020-03-13T09:19:48.1460373Z">
      <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
      <hierarchy name="Expected Date.YWD" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:19:48.1460373Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;XXXX&gt;].&amp;[&lt;XXXXWW&gt;].&amp;[&lt;DD&gt;]</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:39:18.7779211Z">
          <namecolumn datatype="string" datasize="0">Weekyear</namecolumn>
          <keycolumn datatype="string" datasize="0">Weekyear</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Weeknumber" order="key" type="timeweeks" lastmodified="2020-03-09T10:39:47.6594943Z">
          <namecolumn datatype="integer" datasize="0">Weeknumber</namecolumn>
          <keycolumn datatype="integer" datasize="0">Week</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Weekday" order="key" type="timedays" lastmodified="2020-03-09T10:40:07.1291874Z">
          <namecolumn datatype="string" datasize="0">Weekdayname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Weekdaynumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.YMD" visible="true" type="time" lastmodified="2020-03-13T13:24:57.434805Z">
      <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
      <hierarchy name="Expected Date.YMD" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T13:24:57.434805Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;&gt;].&amp;[&lt;YYYYMM&gt;].&amp;[&lt;YYYYMMDD&gt;]</timedef>
        <level name="Year" order="name" type="timeyears" lastmodified="2020-03-09T10:36:06.905675Z">
          <namecolumn datatype="string" datasize="0">YearName</namecolumn>
          <keycolumn datatype="string" datasize="0">YearName</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:40:39.972351Z">
          <namecolumn datatype="string" datasize="0">MonthName1</namecolumn>
          <keycolumn datatype="integer" datasize="0">Month</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Date" order="key" type="timedays" lastmodified="2020-03-09T10:36:07.5638539Z">
          <namecolumn datatype="string" datasize="0">Datename</namecolumn>
          <keycolumn datatype="integer" datasize="0">Datenumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Fiscal YMD" visible="true" type="time" lastmodified="2020-03-13T09:20:32.3101014Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Expected Date.Fiscal YMD" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:20:32.3101014Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:45:17.3321751Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:45:21.4050023Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-09T10:45:22.0077348Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Expected Date.Fiscal YQMD" visible="true" type="time" lastmodified="2020-03-13T09:21:00.7209964Z">
      <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
      <hierarchy name="Expected Date.Fiscal YQMD" visible="true" displayfolder="Expected Date" lastmodified="2020-03-13T09:21:00.7209964Z">
        <table catalog="" schema="">ExpectedPeriod_view</table>
        <timedef>&amp;[&lt;YYYY&gt;].&amp;[&lt;Q&gt;].&amp;[&lt;MM&gt;].&amp;[&lt;DD&gt;],Offset:-3</timedef>
        <level name="Year" order="key" type="timeyears" lastmodified="2020-03-09T10:47:23.8083163Z">
          <namecolumn datatype="string" datasize="0">FiscalYearName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalYearNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Quarter" order="key" type="timequarters" lastmodified="2020-03-09T10:47:27.8546213Z">
          <namecolumn datatype="string" datasize="0">FiscalQuarterName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalQuarterNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Month" order="key" type="timemonths" lastmodified="2020-03-09T10:47:36.1885014Z">
          <namecolumn datatype="string" datasize="0">FiscalMonthname1</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalMonthNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
        <level name="Day" order="key" type="timedays" lastmodified="2020-03-09T10:47:35.2704295Z">
          <namecolumn datatype="string" datasize="0">FiscalDayName</namecolumn>
          <keycolumn datatype="integer" datasize="0">FiscalDayNumber</keycolumn>
          <table catalog="" schema="">ExpectedPeriod_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Company" visible="true" type="regular" lastmodified="2020-03-09T11:56:02.088121Z">
      <hierarchy name="Company" visible="true" displayfolder="Company" lastmodified="2020-03-09T11:56:02.088121Z">
        <table catalog="" schema="">dCompany</table>
        <level name="Company" order="name" type="regular" lastmodified="2020-03-09T11:56:02.088121Z">
          <namecolumn datatype="string" datasize="0">Company</namecolumn>
          <keycolumn datatype="string" datasize="0">Company</keycolumn>
          <table catalog="" schema="">dCompany</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Customer Country" visible="true" type="regular" lastmodified="2021-10-08T11:57:03.7872616Z">
      <hierarchy name="Customer Country" visible="true" displayfolder="Customer" lastmodified="2021-10-08T11:57:03.7872616Z">
        <table catalog="" schema="">dCountry</table>
        <level name="Customer.Country" order="name" type="regular" lastmodified="2020-03-09T12:20:41.4885215Z">
          <namecolumn datatype="string" datasize="0">CountryName</namecolumn>
          <keycolumn datatype="string" datasize="0">CountryName</keycolumn>
          <table catalog="" schema="">dCountry</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Customer Name" visible="true" type="regular" lastmodified="2021-10-08T11:57:31.428078Z">
      <hierarchy name="Customer Name" visible="true" displayfolder="Customer" lastmodified="2021-10-08T11:57:31.428078Z">
        <table catalog="" schema="">dCustomer</table>
        <level name="Customer.Customer" order="name" type="regular" lastmodified="2020-03-09T12:20:33.4930789Z">
          <namecolumn datatype="string" datasize="0">CustName</namecolumn>
          <keycolumn datatype="string" datasize="0">CustName</keycolumn>
          <table catalog="" schema="">dCustomer</table>
          <memberproperty name="Longitude">Longitude</memberproperty>
          <memberproperty name="Latitude">Latitude</memberproperty>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Customer Region" visible="true" type="regular" lastmodified="2021-10-08T11:58:58.7309931Z">
      <hierarchy name="Customer Region" visible="true" displayfolder="Customer" lastmodified="2021-10-08T11:58:58.7309931Z">
        <table catalog="" schema="">dRegion</table>
        <level name="Customer.Region" order="name" type="regular" lastmodified="2020-03-09T12:00:53.4277679Z">
          <namecolumn datatype="string" datasize="0">RegionName</namecolumn>
          <keycolumn datatype="string" datasize="0">RegionName</keycolumn>
          <table catalog="" schema="">dRegion</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Customer Territory" visible="true" type="regular" lastmodified="2021-10-08T11:59:16.4663474Z">
      <hierarchy name="Customer Territory" visible="true" displayfolder="Customer" lastmodified="2021-10-08T11:59:16.4663474Z">
        <table catalog="" schema="">dTerritory</table>
        <level name="Customer.Territory" order="name" type="regular" lastmodified="2020-03-09T12:03:20.3556738Z">
          <namecolumn datatype="string" datasize="0">TerritoryName</namecolumn>
          <keycolumn datatype="string" datasize="0">TerritoryName</keycolumn>
          <table catalog="" schema="">dTerritory</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Customer Hierarchy" visible="true" type="regular" lastmodified="2021-10-08T11:58:31.4918191Z">
      <hierarchy name="Customer Hierarchy" visible="true" displayfolder="Customer" lastmodified="2021-10-08T11:58:31.4918191Z">
        <table catalog="" schema="">dTerritory</table>
        <level name="Territory" order="name" type="regular" lastmodified="2020-03-09T12:06:14.2861162Z">
          <namecolumn datatype="string" datasize="0">TerritoryName</namecolumn>
          <keycolumn datatype="integer" datasize="0">ID</keycolumn>
          <table catalog="" schema="">dTerritory</table>
        </level>
        <level name="Country" order="name" type="regular" lastmodified="2020-03-09T12:07:41.5770142Z">
          <namecolumn datatype="string" datasize="0">CountryName</namecolumn>
          <keycolumn datatype="integer" datasize="0">ID</keycolumn>
          <table catalog="" schema="">dCountry</table>
        </level>
        <level name="Region" order="name" type="regular" lastmodified="2020-03-09T12:08:14.2947956Z">
          <namecolumn datatype="string" datasize="0">RegionName</namecolumn>
          <keycolumn datatype="integer" datasize="0">ID</keycolumn>
          <table catalog="" schema="">dRegion</table>
        </level>
        <level name="Customer" order="name" type="regular" lastmodified="2020-03-09T12:08:18.2058468Z">
          <namecolumn datatype="string" datasize="0">CustName</namecolumn>
          <keycolumn datatype="integer" datasize="0">ID</keycolumn>
          <table catalog="" schema="">dCustomer</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Age" visible="true" type="regular" lastmodified="2021-10-08T12:42:51.4761681Z">
      <hierarchy name="Salesperson Age" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:42:51.4761681Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Age" order="key" type="regular" lastmodified="2020-03-13T08:38:00.7614152Z">
          <namecolumn datatype="integer" datasize="0">Age</namecolumn>
          <keycolumn datatype="integer" datasize="0">Age</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Agegroup" visible="true" type="regular" lastmodified="2021-10-08T12:43:24.0526837Z">
      <hierarchy name="Salesperson Agegroup" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:43:24.0526837Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Agegroup" order="name" type="regular" lastmodified="2020-03-09T12:19:40.5578679Z">
          <namecolumn datatype="string" datasize="0">Agegroup</namecolumn>
          <keycolumn datatype="string" datasize="0">Agegroup</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Department" visible="true" type="regular" lastmodified="2021-10-08T12:43:51.4942783Z">
      <hierarchy name="Salesperson Department" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:43:51.4942783Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Department" order="name" type="regular" lastmodified="2020-03-09T12:19:46.5968662Z">
          <namecolumn datatype="string" datasize="0">Department</namecolumn>
          <keycolumn datatype="string" datasize="0">Department</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Gender" visible="true" type="regular" lastmodified="2021-10-08T12:44:16.7179208Z">
      <hierarchy name="Salesperson Gender" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:44:16.7179208Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Gender" order="name" type="regular" lastmodified="2020-03-09T12:19:51.8190412Z">
          <namecolumn datatype="string" datasize="0">Gender</namecolumn>
          <keycolumn datatype="string" datasize="0">Gender</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Job Satisfaction" visible="true" type="regular" lastmodified="2021-10-08T12:45:36.1005869Z">
      <hierarchy name="Salesperson Job Satisfaction" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:45:36.1005869Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Job Satisfaction" order="key" type="regular" lastmodified="2020-03-09T12:19:58.2288129Z">
          <namecolumn datatype="integer" datasize="0">Job Satisfaction</namecolumn>
          <keycolumn datatype="integer" datasize="0">Job Satisfaction</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Paylevel" visible="true" type="regular" lastmodified="2021-10-08T12:46:33.9325351Z">
      <hierarchy name="Salesperson Paylevel" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:46:33.9325351Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Paylevel" order="key" type="regular" lastmodified="2020-03-09T12:20:04.8295402Z">
          <namecolumn datatype="integer" datasize="0">Paylevel</namecolumn>
          <keycolumn datatype="integer" datasize="0">Paylevel</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Name" visible="true" type="regular" lastmodified="2021-10-08T12:46:54.6929448Z">
      <hierarchy name="Salesperson Name" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:46:54.6929448Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Salesperson" order="name" type="regular" lastmodified="2020-03-13T08:38:17.3336874Z">
          <namecolumn datatype="string" datasize="0">SalespersonName</namecolumn>
          <keycolumn datatype="string" datasize="0">SalespersonName</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Seniority" visible="true" type="regular" lastmodified="2021-10-08T12:47:16.6232545Z">
      <hierarchy name="Salesperson Seniority" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:47:16.6232545Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Seniority" order="key" type="regular" lastmodified="2020-03-09T12:20:18.6131927Z">
          <namecolumn datatype="integer" datasize="0">Seniority</namecolumn>
          <keycolumn datatype="integer" datasize="0">Seniority</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Invoice No" visible="true" type="regular" lastmodified="2021-10-08T12:28:55.1512152Z">
      <hierarchy name="Invoice No" visible="true" displayfolder="Invoice" lastmodified="2021-10-08T12:28:55.1512152Z">
        <table catalog="" schema="">dSalesInvoiceHeader</table>
        <level name="Invoice.Invoice No" order="name" type="regular" lastmodified="2020-03-09T12:42:55.8904787Z">
          <namecolumn datatype="string" datasize="0">InvoiceNo</namecolumn>
          <keycolumn datatype="string" datasize="0">InvoiceNo</keycolumn>
          <table catalog="" schema="">dSalesInvoiceHeader</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Opportunity Number" visible="true" type="regular" lastmodified="2021-10-08T12:41:42.7903152Z">
      <hierarchy name="Opportunity Number" visible="true" displayfolder="Opportunity" lastmodified="2021-10-08T12:41:42.7903152Z">
        <table catalog="" schema="">Opportunity_view</table>
        <level name="Opportunity.Number" order="key" type="regular" lastmodified="2020-03-10T06:46:47.9822707Z">
          <namecolumn datatype="float" datasize="0">Opportunity Number</namecolumn>
          <keycolumn datatype="float" datasize="0">Opportunity Number</keycolumn>
          <table catalog="" schema="">Opportunity_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Opportunity Probability" visible="true" type="regular" lastmodified="2021-10-08T12:40:51.4891458Z">
      <hierarchy name="Opportunity Probability" visible="true" displayfolder="Opportunity" lastmodified="2021-10-08T12:40:51.4891458Z">
        <table catalog="" schema="">Probability_view</table>
        <level name="Opportunity.Probability" order="key" type="regular" lastmodified="2020-03-10T06:46:49.3688696Z">
          <namecolumn datatype="string" datasize="0">Probability</namecolumn>
          <keycolumn datatype="string" datasize="0">Probability</keycolumn>
          <table catalog="" schema="">Probability_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Finance Transaction Type" visible="true" type="regular" lastmodified="2021-10-08T11:33:11.6216266Z">
      <hierarchy name="Finance Transaction Type" visible="true" displayfolder="Finance Transaction" lastmodified="2021-10-08T11:33:11.6216266Z">
        <table catalog="" schema="">dtranstype</table>
        <level name="Finance Transaction.Type" order="key" type="regular" lastmodified="2020-03-10T07:18:52.1190096Z">
          <namecolumn datatype="string" datasize="0">transdesc</namecolumn>
          <keycolumn datatype="string" datasize="0">transdesc</keycolumn>
          <table catalog="" schema="">dtranstype</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Department" visible="true" type="regular" lastmodified="2021-10-08T11:29:53.3253118Z">
      <hierarchy name="Department" visible="true" displayfolder="Department" lastmodified="2021-10-08T11:29:53.3253118Z">
        <table catalog="" schema="">dDepartment</table>
        <level name="Department.Name" order="name" type="regular" lastmodified="2020-03-10T07:18:16.6286963Z">
          <namecolumn datatype="string" datasize="0">DepartmentName</namecolumn>
          <keycolumn datatype="string" datasize="0">DepartmentName</keycolumn>
          <table catalog="" schema="">dDepartment</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Account Name" visible="true" type="regular" lastmodified="2021-10-08T11:24:37.4512057Z">
      <hierarchy name="Account Name" visible="true" displayfolder="Account" lastmodified="2021-10-08T11:24:37.4512057Z">
        <table catalog="" schema="">dGLAccount</table>
        <level name="Account.Account" order="key" type="regular" lastmodified="2020-03-13T07:21:07.4900052Z">
          <namecolumn datatype="string" datasize="0">AccountName2</namecolumn>
          <keycolumn datatype="string" datasize="0">AccountName2</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Account Group" visible="true" type="regular" lastmodified="2021-10-08T11:24:25.446928Z">
      <hierarchy name="Account Group" visible="true" displayfolder="Account" lastmodified="2021-10-08T11:24:25.446928Z">
        <table catalog="" schema="">dGLAccount</table>
        <level name="Account.Group" order="key" type="regular" lastmodified="2020-03-10T07:20:54.302951Z">
          <namecolumn datatype="string" datasize="0">AccountGroup</namecolumn>
          <keycolumn datatype="string" datasize="0">AccountGroup</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Item Status" visible="true" type="regular" lastmodified="2021-10-08T12:39:15.054982Z">
      <hierarchy name="Item Status" visible="true" displayfolder="Item" lastmodified="2021-10-08T12:39:15.054982Z">
        <table catalog="" schema="">dItemEntryType</table>
        <level name="Item Status" order="key" type="regular" lastmodified="2020-03-10T08:49:21.2706596Z">
          <namecolumn datatype="integer" datasize="0">EntryType</namecolumn>
          <keycolumn datatype="integer" datasize="0">EntryType</keycolumn>
          <table catalog="" schema="">dItemEntryType</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Stock Location" visible="true" type="regular" lastmodified="2020-03-10T08:50:47.3517234Z">
      <hierarchy name="Stock Location" visible="true" displayfolder="Stock Location" lastmodified="2020-03-10T08:50:47.3517234Z">
        <table catalog="" schema="">dLocation</table>
        <level name="Stock Location" order="key" type="regular" lastmodified="2020-03-10T08:51:13.2981746Z">
          <namecolumn datatype="string" datasize="0">LocationName</namecolumn>
          <keycolumn datatype="string" datasize="0">LocationName</keycolumn>
          <table catalog="" schema="">dLocation</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Return Reason" visible="true" type="regular" lastmodified="2020-03-10T08:55:57.1737405Z">
      <hierarchy name="Return Reason" visible="true" displayfolder="Return Reason" lastmodified="2020-03-10T08:55:57.1737405Z">
        <table catalog="" schema="">Return_Reason_view</table>
        <level name="Return Reason" order="name" type="regular" lastmodified="2020-03-10T08:55:57.1737405Z">
          <namecolumn datatype="string" datasize="0">ReturnReason</namecolumn>
          <keycolumn datatype="string" datasize="0">ReturnReason</keycolumn>
          <table catalog="" schema="">Return_Reason_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Absence Reason" visible="true" type="regular" lastmodified="2020-03-10T09:19:06.6095864Z">
      <hierarchy name="Absence Reason" visible="true" displayfolder="Absence Reason" lastmodified="2020-03-10T09:19:06.6095864Z">
        <table catalog="" schema="">Absence_view</table>
        <level name="Absence Reason" order="key" type="regular" lastmodified="2020-03-10T09:19:17.8884955Z">
          <namecolumn datatype="string" datasize="0">Absence Reason</namecolumn>
          <keycolumn datatype="string" datasize="0">Absence Reason</keycolumn>
          <table catalog="" schema="">Absence_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Absence Reason Group" visible="true" type="regular" lastmodified="2021-10-08T11:51:55.8884557Z">
      <hierarchy name="Absence Reason Group" visible="true" displayfolder="Absence Reason" lastmodified="2021-10-08T11:51:55.8884557Z">
        <table catalog="" schema="">Absence_view</table>
        <level name="Absence Reason.Group" order="key" type="regular" lastmodified="2020-03-10T09:19:21.2862528Z">
          <namecolumn datatype="string" datasize="0">Reason Group</namecolumn>
          <keycolumn datatype="string" datasize="0">Reason Group</keycolumn>
          <table catalog="" schema="">Absence_view</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Account Hierarchy" visible="true" type="regular" lastmodified="2021-10-08T11:24:55.1398089Z">
      <hierarchy name="Account Hierarchy" visible="true" displayfolder="Account" lastmodified="2021-10-08T11:24:55.1398089Z">
        <table catalog="" schema="">dGLAccount</table>
        <level name="Level 02" order="key" type="regular" lastmodified="2020-03-10T10:24:20.3486224Z">
          <namecolumn datatype="string" datasize="0">Level1</namecolumn>
          <keycolumn datatype="string" datasize="0">Level1</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 03" order="key" type="regular" lastmodified="2020-03-10T10:24:23.6298557Z">
          <namecolumn datatype="string" datasize="0">Level2</namecolumn>
          <keycolumn datatype="string" datasize="0">Level2</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 04" order="key" type="regular" lastmodified="2020-03-10T10:24:26.4822873Z">
          <namecolumn datatype="string" datasize="0">Level3</namecolumn>
          <keycolumn datatype="string" datasize="0">Level3</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 05" order="key" type="regular" lastmodified="2020-03-10T10:57:49.6821937Z">
          <namecolumn datatype="string" datasize="0">Level4</namecolumn>
          <keycolumn datatype="string" datasize="0">Level4</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 06" order="key" type="regular" lastmodified="2020-03-10T10:57:49.5181155Z">
          <namecolumn datatype="string" datasize="0">Level5</namecolumn>
          <keycolumn datatype="string" datasize="0">Level5</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 07" order="key" type="regular" lastmodified="2020-03-10T10:57:49.3526955Z">
          <namecolumn datatype="string" datasize="0">Level6</namecolumn>
          <keycolumn datatype="string" datasize="0">Level6</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 08" order="key" type="regular" lastmodified="2020-03-10T10:57:48.8652325Z">
          <namecolumn datatype="string" datasize="0">Level7</namecolumn>
          <keycolumn datatype="string" datasize="0">Level7</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
        <level name="Level 09" order="key" type="regular" lastmodified="2020-03-10T10:57:48.5381706Z">
          <namecolumn datatype="string" datasize="0">Level8</namecolumn>
          <keycolumn datatype="string" datasize="0">Level8</keycolumn>
          <table catalog="" schema="">dGLAccount</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Manager Hierarchy" visible="true" type="regular" lastmodified="2021-10-08T12:46:24.0201658Z">
      <hierarchy name="Salesperson Manager Hierarchy" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:46:24.0201658Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Managers" order="name" type="regular" lastmodified="2021-10-08T12:51:59.9303258Z">
          <namecolumn datatype="string" datasize="0">Level1</namecolumn>
          <keycolumn datatype="string" datasize="0">Level1</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
        <level name="Salespersons" order="name" type="regular" lastmodified="2021-10-08T12:52:08.218608Z">
          <namecolumn datatype="string" datasize="0">Level2</namecolumn>
          <keycolumn datatype="string" datasize="0">Level2</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
        <level name="Trainees" order="name" type="regular" lastmodified="2021-10-08T12:52:20.4259372Z">
          <namecolumn datatype="string" datasize="0">Level3</namecolumn>
          <keycolumn datatype="string" datasize="0">Level3</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Age Hierarchy" visible="true" type="regular" lastmodified="2021-10-08T12:45:10.3817449Z">
      <hierarchy name="Salesperson Age Hierarchy" visible="true" displayfolder="Salesperson" lastmodified="2021-10-08T12:45:10.3817449Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Agegroup" order="name" type="regular" lastmodified="2020-03-13T08:38:36.908836Z">
          <namecolumn datatype="string" datasize="0">Agegroup</namecolumn>
          <keycolumn datatype="string" datasize="0">Agegroup</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
        <level name="Age" order="key" type="regular" lastmodified="2020-03-13T08:38:08.7585075Z">
          <namecolumn datatype="integer" datasize="0">Age</namecolumn>
          <keycolumn datatype="integer" datasize="0">Age</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
        <level name="Salesperson" order="name" type="regular" lastmodified="2020-03-13T08:38:40.7560589Z">
          <namecolumn datatype="string" datasize="0">SalespersonName</namecolumn>
          <keycolumn datatype="string" datasize="0">SalespersonName</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Item Hierarchy" visible="true" type="regular" lastmodified="2021-10-08T12:32:23.3676127Z">
      <hierarchy name="Item Hierarchy" visible="true" displayfolder="Item" lastmodified="2021-10-08T12:32:23.3676127Z">
        <table catalog="" schema="">dItemGroup</table>
        <level name="Item Group" order="name" type="regular" lastmodified="2021-10-12T10:04:39.3048569Z">
          <namecolumn datatype="string" datasize="0">ItemgroupName</namecolumn>
          <keycolumn datatype="integer" datasize="0">ID</keycolumn>
          <table catalog="" schema="">dItemGroup</table>
        </level>
        <level name="Item" order="name" type="regular" lastmodified="2021-10-12T10:04:37.0554474Z">
          <namecolumn datatype="string" datasize="0">Itemname</namecolumn>
          <keycolumn datatype="string" datasize="0">Itemname</keycolumn>
          <table catalog="" schema="">dItem</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Longitude" visible="true" type="regular" lastmodified="2022-12-13T12:40:00.1354163Z">
      <hierarchy name="Longitude" visible="true" displayfolder="Customer" lastmodified="2022-12-13T12:40:00.1354163Z">
        <table catalog="" schema="">dCustomer</table>
        <level name="Longitude" order="name" type="regular" lastmodified="2022-12-13T12:40:00.1360787Z">
          <namecolumn datatype="string" datasize="0">Longitude</namecolumn>
          <keycolumn datatype="string" datasize="0">Longitude</keycolumn>
          <table catalog="" schema="">dCustomer</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Latitude" visible="true" type="regular" lastmodified="2022-12-13T12:40:04.2467624Z">
      <hierarchy name="Latitude" visible="true" displayfolder="Customer" lastmodified="2022-12-13T12:40:04.2467624Z">
        <table catalog="" schema="">dCustomer</table>
        <level name="Latitude" order="name" type="regular" lastmodified="2022-12-13T12:40:04.2474206Z">
          <namecolumn datatype="string" datasize="0">Latitude</namecolumn>
          <keycolumn datatype="string" datasize="0">Latitude</keycolumn>
          <table catalog="" schema="">dCustomer</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Salesperson Email" visible="true" type="regular" lastmodified="2025-05-12T07:40:00.8440051Z">
      <hierarchy name="Salesperson Email" visible="true" displayfolder="Salesperson" lastmodified="2025-05-12T07:44:42.0723013Z">
        <table catalog="" schema="">dSalesperson</table>
        <level name="Salesperson.Email" order="name" type="regular" lastmodified="2025-05-12T07:41:18.4524587Z">
          <namecolumn datatype="string" datasize="0">Email</namecolumn>
          <keycolumn datatype="string" datasize="0">Email</keycolumn>
          <table catalog="" schema="">dSalesperson</table>
        </level>
      </hierarchy>
    </dimension>
    <dimension name="Country Manager Email" visible="true" type="regular" lastmodified="2025-05-12T07:42:32.5717974Z">
      <hierarchy name="Country Manager Email" visible="true" displayfolder="Customer" lastmodified="2025-05-12T07:43:28.9214093Z">
        <table catalog="" schema="">dCountry</table>
        <level name="CountryManager.Email" order="name" type="regular" lastmodified="2025-05-12T07:42:50.9069063Z">
          <namecolumn datatype="string" datasize="0">Email</namecolumn>
          <keycolumn datatype="string" datasize="0">Email</keycolumn>
          <table catalog="" schema="">dCountry</table>
        </level>
      </hierarchy>
    </dimension>
  </shareddimensions>
  <cubes>
    <cube name="Sales Invoice Line" factcatalog="" factschema="" fact="fSalesInvoiceLine" lastmodified="2021-10-25T11:14:14.1030252Z" visible="false">
      <dimension shared="true" name="Item Name" />
      <dimension shared="true" name="Item Google Search URL" />
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Customer Country" />
      <dimension shared="true" name="Customer Name" />
      <dimension shared="true" name="Customer Region" />
      <dimension shared="true" name="Customer Territory" />
      <dimension shared="true" name="Customer Hierarchy" />
      <dimension shared="true" name="Salesperson Age" />
      <dimension shared="true" name="Salesperson Agegroup" />
      <dimension shared="true" name="Salesperson Department" />
      <dimension shared="true" name="Salesperson Gender" />
      <dimension shared="true" name="Salesperson Job Satisfaction" />
      <dimension shared="true" name="Salesperson Paylevel" />
      <dimension shared="true" name="Salesperson Name" />
      <dimension shared="true" name="Salesperson Seniority" />
      <dimension shared="true" name="Invoice No" />
      <dimension shared="true" name="Expected Date.Date" />
      <dimension shared="true" name="Expected Date.Day of Month" />
      <dimension shared="true" name="Expected Date.Month" />
      <dimension shared="true" name="Expected Date.Month Short" />
      <dimension shared="true" name="Expected Date.Quarter" />
      <dimension shared="true" name="Expected Date.Weekday" />
      <dimension shared="true" name="Expected Date.Weekday Short" />
      <dimension shared="true" name="Expected Date.Weeknumber" />
      <dimension shared="true" name="Expected Date.Year" />
      <dimension shared="true" name="Expected Date.YQMD" />
      <dimension shared="true" name="Expected Date.YWD" />
      <dimension shared="true" name="Expected Date.YMD" />
      <dimension shared="true" name="Expected Date.Fiscal YMD" />
      <dimension shared="true" name="Expected Date.Fiscal YQMD" />
      <dimension shared="true" name="Salesperson Manager Hierarchy" />
      <dimension shared="true" name="Salesperson Age Hierarchy" />
      <dimension shared="true" name="Item Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <dimension shared="true" name="Longitude" />
      <dimension shared="true" name="Latitude" />
      <dimension shared="true" name="Salesperson Email" />
      <dimension shared="true" name="Country Manager Email" />
      <measure name="InvoiceQuantity" visible="false" lastmodified="2020-03-09T12:29:26.7996287Z" format="#,#" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Quantity</measure>
      <measure name="InvoiceAmount" visible="false" lastmodified="2020-03-09T13:50:51.1758601Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Amount</measure>
      <measure name="InvoiceCost" visible="false" lastmodified="2020-03-09T12:29:24.9556183Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">UnitCost</measure>
      <measure name="CreditMemoQuantity" visible="false" lastmodified="2020-03-09T12:29:21.1190745Z" format="#,#" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">QuantityCM</measure>
      <measure name="CreditMemoAmount" visible="false" lastmodified="2020-03-09T12:29:16.6895142Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">AmountCM</measure>
      <measure name="CreditMemoCost" visible="false" lastmodified="2020-03-09T12:29:18.5704962Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">UnitCostCM</measure>
      <measure name="Budget Amount" visible="true" lastmodified="2020-03-09T08:46:34.2864284Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">BudgetAmount</measure>
      <measure name="SalesCount" visible="false" lastmodified="2020-03-11T07:46:30.7122821Z" format="#,#" aggregate="sum" datatype="integer" datasize="0">SalesCount</measure>
      <measure name="CreditMemoCount" visible="false" lastmodified="2020-03-11T07:46:42.0329537Z" format="#,#" aggregate="sum" datatype="integer" datasize="0">CreditMemoCount</measure>
      <calculation name="Invoice Quantity" visible="true" lastmodified="2020-03-09T12:31:26.8943674Z" format="#,##0">IIF([InvoiceQuantity]=0,null,[InvoiceQuantity])</calculation>
      <calculation name="Invoice Amount" visible="true" lastmodified="2020-03-09T14:07:40.4793541Z" format="#,##0">IIF([InvoiceAmount]=0,null,[InvoiceAmount])</calculation>
      <calculation name="Invoice Cost" visible="true" lastmodified="2020-03-09T12:31:55.0198738Z" format="#,##0">IIF([InvoiceCost]=0,null,[InvoiceCost])</calculation>
      <calculation name="Credit Memo Quantity" visible="true" lastmodified="2020-03-09T12:32:32.9870678Z" format="#,##0">IIF([CreditMemoQuantity]=0,null,[CreditMemoQuantity])</calculation>
      <calculation name="Credit Memo Amount" visible="true" lastmodified="2020-03-09T14:07:45.7326731Z" format="#,##0">IIF([CreditMemoAmount]=0,null,[CreditMemoAmount])</calculation>
      <calculation name="Credit Memo Cost" visible="true" lastmodified="2020-03-09T12:33:26.016475Z" format="#,##0">IIF([CreditMemoCost]=0,null,[CreditMemoCost])</calculation>
      <calculation name="Revenue" visible="true" lastmodified="2020-03-09T14:08:33.6795412Z" format="#,##0">IIF([InvoiceAmount]-[CreditMemoAmount]=0,null,
[InvoiceAmount]-[CreditMemoAmount])</calculation>
      <calculation name="Units Sold" visible="true" lastmodified="2020-03-09T12:34:53.178103Z" format="#,##0">IIF(([InvoiceQuantity]&lt;&gt;0) or ([CreditMemoQuantity]&lt;&gt;0),[InvoiceQuantity]-[CreditMemoQuantity],null)</calculation>
      <calculation name="Costs" visible="true" lastmodified="2020-03-09T12:35:25.1983805Z" format="#,##0">IIF(([InvoiceCost]&lt;&gt;0) or ([CreditMemoCost]&lt;&gt;0),[InvoiceCost]-[CreditMemoCost],null)</calculation>
      <calculation name="Profit" visible="true" lastmodified="2021-10-25T11:14:14.0574492Z" format="#,##0">IIF(ISNULL([Revenue]),0,[Revenue])-IIF(ISNULL([Costs]),0,[Costs])</calculation>
      <calculation name="Profit Margin" visible="true" lastmodified="2020-03-10T07:24:15.0900225Z" format="#,##0">IIF([Revenue]=0,null,[Profit]/[Revenue]*100)</calculation>
      <calculation name="Budget Variance" visible="true" lastmodified="2021-10-25T11:11:34.8172895Z" format="#,##0">IIF(ISNULL([Revenue]),0,[Revenue])-IIF(ISNULL([Budget Amount]),0,[Budget Amount])</calculation>
      <calculation name="Budget Variance %" visible="true" lastmodified="2021-10-12T09:45:54.0310584Z" format="#,#.0&quot;%&quot;">IIF([Budget Amount]=0,null,([Budget Variance]/[Budget Amount])*100)</calculation>
      <calculation name="No of Sales" visible="true" lastmodified="2021-10-25T11:09:38.5518245Z">IIF(ISNULL([SalesCount]),0,[SalesCount])+IIF(ISNULL([CreditMemoCount]),0,[CreditMemoCount])</calculation>
    </cube>
    <cube name="Sales Pipeline" factcatalog="" factschema="" fact="fSalesPipeline" lastmodified="2021-10-08T12:47:16.6183359Z" visible="false">
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Customer Country" />
      <dimension shared="true" name="Customer Name" />
      <dimension shared="true" name="Customer Region" />
      <dimension shared="true" name="Customer Territory" />
      <dimension shared="true" name="Customer Hierarchy" />
      <dimension shared="true" name="Salesperson Age" />
      <dimension shared="true" name="Salesperson Agegroup" />
      <dimension shared="true" name="Salesperson Department" />
      <dimension shared="true" name="Salesperson Gender" />
      <dimension shared="true" name="Salesperson Job Satisfaction" />
      <dimension shared="true" name="Salesperson Paylevel" />
      <dimension shared="true" name="Salesperson Name" />
      <dimension shared="true" name="Salesperson Seniority" />
      <dimension shared="true" name="Opportunity Number" />
      <dimension shared="true" name="Opportunity Probability" />
      <dimension shared="true" name="Created Date.Date" />
      <dimension shared="true" name="Created Date.Day of Month" />
      <dimension shared="true" name="Created Date.Month" />
      <dimension shared="true" name="Created Date.Month Short" />
      <dimension shared="true" name="Created Date.Quarter" />
      <dimension shared="true" name="Created Date.Weekday" />
      <dimension shared="true" name="Created Date.Weekday Short" />
      <dimension shared="true" name="Created Date.Weeknumber" />
      <dimension shared="true" name="Created Date.Year" />
      <dimension shared="true" name="Created Date.YQMD" />
      <dimension shared="true" name="Created Date.YWD" />
      <dimension shared="true" name="Created Date.YMD" />
      <dimension shared="true" name="Created Date.Fiscal YMD" />
      <dimension shared="true" name="Created Date.Fiscal YQMD" />
      <dimension shared="true" name="Expected Date.Date" />
      <dimension shared="true" name="Expected Date.Day of Month" />
      <dimension shared="true" name="Expected Date.Month" />
      <dimension shared="true" name="Expected Date.Month Short" />
      <dimension shared="true" name="Expected Date.Quarter" />
      <dimension shared="true" name="Expected Date.Weekday" />
      <dimension shared="true" name="Expected Date.Weekday Short" />
      <dimension shared="true" name="Expected Date.Weeknumber" />
      <dimension shared="true" name="Expected Date.Year" />
      <dimension shared="true" name="Expected Date.YQMD" />
      <dimension shared="true" name="Expected Date.YWD" />
      <dimension shared="true" name="Expected Date.YMD" />
      <dimension shared="true" name="Expected Date.Fiscal YMD" />
      <dimension shared="true" name="Expected Date.Fiscal YQMD" />
      <dimension shared="true" name="Salesperson Manager Hierarchy" />
      <dimension shared="true" name="Salesperson Age Hierarchy" />
      <dimension shared="true" name="Longitude" />
      <dimension shared="true" name="Latitude" />
      <measure name="Pipeline Amount" visible="true" lastmodified="2020-03-09T11:53:11.9115205Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">amount</measure>
      <measure name="No of Opportunities" visible="true" lastmodified="2020-03-09T11:54:04.806522Z" format="#,#" aggregate="count" measuredatatype="float" datatype="float" datasize="0">row number</measure>
      <measure name="Weighted Amount" visible="true" lastmodified="2020-03-09T11:54:15.1863308Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">weighted amount</measure>
      <measure name="Leadtime" visible="true" lastmodified="2020-03-09T11:53:48.770495Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">leadtime</measure>
      <calculation name="Average Leadtime" visible="true" lastmodified="2020-03-09T12:39:58.3134823Z" format="#,##0">iif([No of Opportunities]=0,null,([Leadtime]/[No of Opportunities]))</calculation>
    </cube>
    <cube name="Finance" fact="fGLEntry" lastmodified="2025-06-27T11:02:02.1341796Z" visible="true">
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Finance Transaction Type" />
      <dimension shared="true" name="Account Name" />
      <dimension shared="true" name="Account Group" />
      <dimension shared="true" name="Account Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <dimension shared="true" name="Department" />
      <measure name="Amount" visible="true" lastmodified="2020-03-10T07:12:52.7128522Z" format="#,##0" aggregate="sum" datatype="float" datasize="0">Amount</measure>
      <measure name="Debit Amount" visible="true" lastmodified="2020-03-10T07:13:05.4539991Z" format="#,##0" aggregate="sum" datatype="float" datasize="0">DebitAmount</measure>
      <measure name="Credit Amount" visible="true" lastmodified="2020-03-10T07:12:58.8197347Z" format="#,##0" aggregate="sum" datatype="float" datasize="0">CreditAmount</measure>
      <measure name="Budget Amount" visible="true" lastmodified="2020-03-10T07:12:55.7129812Z" format="#,##0" aggregate="sum" datatype="float" datasize="0">Budget</measure>
      <calculation name="Budget Variance" visible="true" lastmodified="2021-10-25T11:16:03.8494908Z" format="#,##0">IIF(ISNULL([Amount]),0,[Amount])-IIF(ISNULL([Budget Amount]),0,[Budget Amount])</calculation>
      <calculation name="Budget Variance %" visible="true" lastmodified="2020-03-10T07:26:04.3384382Z" format="#,#0.00">iif([Amount]&lt;0.01 and [Amount]&gt;-0.01,null,([Budget Variance]/[Amount])*100)</calculation>
    </cube>
    <cube name="Production" fact="fProduction" lastmodified="2021-10-25T11:19:16.7578575Z" visible="true">
      <dimension shared="true" name="Item Name" />
      <dimension shared="true" name="Item Google Search URL" />
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Item Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <measure name="Yieldtheoretically" visible="true" lastmodified="2020-03-10T08:31:37.823771Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">yieldtheoretically</measure>
      <measure name="Yieldestimated" visible="true" lastmodified="2020-03-10T08:31:35.8057364Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">yieldestimated</measure>
      <measure name="Yieldactual" visible="true" lastmodified="2020-03-10T08:31:34.050218Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">yieldactual</measure>
      <measure name="Rejects" visible="true" lastmodified="2020-03-10T08:31:26.1066267Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">rejects</measure>
      <measure name="Prodquantity" visible="true" lastmodified="2020-03-10T08:31:19.109751Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">prodquantity</measure>
      <measure name="Prodcost" visible="true" lastmodified="2020-03-10T08:31:16.7461361Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">prodcost</measure>
      <measure name="Prodretailquantity" visible="true" lastmodified="2020-03-10T08:31:21.5241802Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">prodretailquantity</measure>
      <measure name="Prodretailvalue" visible="true" lastmodified="2020-03-10T08:31:23.6849893Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">prodretailvalue</measure>
      <measure name="Soldquantity" visible="true" lastmodified="2020-03-10T08:31:32.1446709Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">soldquantity</measure>
      <measure name="Soldamount" visible="true" lastmodified="2020-03-10T08:31:28.2107074Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">soldamount</measure>
      <measure name="Soldcost" visible="true" lastmodified="2020-03-10T08:31:30.3186661Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">soldcost</measure>
      <calculation name="Quality Index" visible="true" lastmodified="2020-03-10T08:27:51.137879Z" format="#,##0">iif([Prodquantity]=0,null,[Prodretailquantity]/[Prodquantity]*100)</calculation>
      <calculation name="Yield Exploitation" visible="true" lastmodified="2020-03-10T08:28:27.5439105Z" format="#,##0">iif([Yieldtheoretically]=0,null,[Yieldactual]/[Yieldtheoretically]*100)</calculation>
      <calculation name="Yield Index" visible="true" lastmodified="2020-03-10T08:29:04.517765Z" format="#,##0">iif([Yieldestimated]=0,null,[Yieldactual]/[Yieldestimated]*100)</calculation>
      <calculation name="Yield Variance" visible="true" lastmodified="2021-10-25T11:19:16.7474562Z" format="#,##0">IIF(ISNULL([Yieldtheoretically]),0,[Yieldtheoretically])-IIF(ISNULL([Yieldestimated]),0,[Yieldestimated])</calculation>
      <calculation name="Profit Margin" visible="true" lastmodified="2020-03-10T08:30:25.2869816Z" format="#,##0">iif([Soldamount]=0,null,[Profit]/[Soldamount])</calculation>
      <calculation name="Profit" visible="true" lastmodified="2021-10-25T11:17:48.2631296Z" format="#,##0">IIF(ISNULL([Soldamount]),0,[Soldamount])-IIF(ISNULL([Soldcost]),0,[Soldcost])</calculation>
    </cube>
    <cube name="Inventory Ledger Entry" fact="fItemLedgerEntry" lastmodified="2021-10-08T12:37:16.8736221Z" visible="false">
      <dimension shared="true" name="Item Name" />
      <dimension shared="true" name="Item Google Search URL" />
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Item Status" />
      <dimension shared="true" name="Stock Location" />
      <dimension shared="true" name="Item Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <measure name="Quantity" visible="true" lastmodified="2020-03-10T08:59:40.0741852Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Quantity</measure>
      <measure name="Increase" visible="true" lastmodified="2020-03-10T08:59:38.2112547Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Increase</measure>
      <measure name="Decrease" visible="true" lastmodified="2020-03-10T08:59:36.12715Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Decrease</measure>
    </cube>
    <cube name="Inventory Sales Line" factcatalog="" factschema="" fact="fSalesInvoiceLine" lastmodified="2021-10-25T11:21:26.6970711Z" visible="false">
      <dimension shared="true" name="Item Name" />
      <dimension shared="true" name="Item Google Search URL" />
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Company" />
      <dimension shared="true" name="Return Reason" />
      <dimension shared="true" name="Item Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <measure name="InvoiceQuantity" visible="false" lastmodified="2020-03-10T08:59:53.784253Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Quantity</measure>
      <measure name="Inv Discount Amount" visible="false" lastmodified="2020-03-10T08:59:51.8764265Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">InvDiscountAmount</measure>
      <measure name="InvoiceAmount" visible="false" lastmodified="2020-03-10T08:59:45.6608938Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Amount</measure>
      <measure name="InvoiceCost" visible="false" lastmodified="2020-03-10T08:59:57.1768873Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">UnitCost</measure>
      <measure name="CreditMemoQuantity" visible="false" lastmodified="2020-03-10T08:59:55.4680343Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">QuantityCM</measure>
      <measure name="CreditMemoAmount" visible="false" lastmodified="2020-03-10T08:59:47.9394952Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">AmountCM</measure>
      <measure name="CreditMemoCost" visible="false" lastmodified="2020-03-10T08:59:59.2795609Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">UnitCostCM</measure>
      <measure name="Budget Amount" visible="false" lastmodified="2020-03-10T08:59:49.8460066Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">BudgetAmount</measure>
      <measure name="SalesCount" visible="false" lastmodified="2020-03-11T13:20:28.6469692Z" format="#,0" aggregate="sum" datatype="integer" datasize="0">SalesCount</measure>
      <measure name="CreditMemoCount" visible="false" lastmodified="2020-03-11T13:20:32.8502194Z" format="#,0" aggregate="sum" datatype="integer" datasize="0">CreditMemoCount</measure>
      <calculation name="Invoice Amount" visible="true" lastmodified="2020-03-10T09:07:07.8843286Z" format="#,##0">IIF([InvoiceAmount]=0,null,[InvoiceAmount])</calculation>
      <calculation name="Invoice Cost" visible="true" lastmodified="2020-03-10T09:07:09.6093373Z" format="#,##0">IIF([InvoiceCost]=0,null,[InvoiceCost])</calculation>
      <calculation name="Credit Memo Quantity" visible="true" lastmodified="2020-03-10T09:07:05.0789629Z" format="#,##0">IIF([CreditMemoQuantity]=0,null,[CreditMemoQuantity])</calculation>
      <calculation name="Credit Memo Amount" visible="true" lastmodified="2020-03-10T09:07:01.3484266Z" format="#,##0">IIF([CreditMemoAmount]=0,null,[CreditMemoAmount])</calculation>
      <calculation name="Credit Memo Cost" visible="true" lastmodified="2020-03-10T09:07:02.9829441Z" format="#,##0">IIF([CreditMemoCost]=0,null,[CreditMemoCost])</calculation>
      <calculation name="Revenue" visible="true" lastmodified="2020-03-11T13:16:46.5419474Z" format="#,##0">IIF([InvoiceAmount]=0 and [CreditMemoAmount]=0,null,[InvoiceAmount]-[CreditMemoAmount])</calculation>
      <calculation name="Cost" visible="true" lastmodified="2020-03-11T13:18:23.7760941Z" format="#,##0">IIF([InvoiceCost]=0 and [CreditMemoCost]=0,null,[InvoiceCost]-[CreditMemoCost])</calculation>
      <calculation name="Units Sold" visible="true">IIF(([InvoiceQuantity]&lt;&gt;0) or ([CreditMemoQuantity]&lt;&gt;0),[InvoiceQuantity]-[CreditMemoQuantity],null)</calculation>
      <calculation name="Unit Cost" visible="true" lastmodified="2020-03-10T09:05:00.8532344Z">IIF([Units Sold]=0,null,[Cost]/[Units Sold])</calculation>
      <calculation name="Profit" visible="true" lastmodified="2020-03-11T13:18:51.6047378Z" format="#,##0">[Revenue]-[Cost]</calculation>
      <calculation name="Profit Margin" visible="true" lastmodified="2020-03-10T09:07:38.1199128Z" format="#,#0.0">IIF([Revenue]=0,null,[Profit]/[Revenue]*100)</calculation>
      <calculation name="No of Sales" visible="true" lastmodified="2021-10-25T11:21:26.6874756Z">IIF(ISNULL([SalesCount]),0,[SalesCount])+IIF(ISNULL([CreditMemoCount]),0,[CreditMemoCount])</calculation>
    </cube>
    <cube name="HR Absence" factcatalog="" factschema="" fact="fAbsence" lastmodified="2021-10-08T12:47:16.6203528Z" visible="false">
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="Salesperson Age" />
      <dimension shared="true" name="Salesperson Agegroup" />
      <dimension shared="true" name="Salesperson Department" />
      <dimension shared="true" name="Salesperson Gender" />
      <dimension shared="true" name="Salesperson Job Satisfaction" />
      <dimension shared="true" name="Salesperson Paylevel" />
      <dimension shared="true" name="Salesperson Name" />
      <dimension shared="true" name="Salesperson Seniority" />
      <dimension shared="true" name="Absence Reason" />
      <dimension shared="true" name="Absence Reason Group" />
      <dimension shared="true" name="Salesperson Age Hierarchy" />
      <dimension shared="true" name="Salesperson Manager Hierarchy" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <measure name="Planned hours" visible="true" lastmodified="2020-03-10T09:21:02.7018359Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Planned</measure>
      <measure name="Absence Hours" visible="true" lastmodified="2020-03-10T09:21:23.9469128Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Absence</measure>
      <measure name="Absent Day" visible="true" lastmodified="2020-03-10T09:21:16.4206007Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Absent day</measure>
      <measure name="Planned Day" visible="true" lastmodified="2020-03-10T09:21:08.8735743Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Planned day</measure>
      <calculation name="Absence hour Percent" visible="true" lastmodified="2020-03-13T13:57:02.3853839Z" format="#,#0.00">iif ([Planned hours]=0,null,([Absence hours]/[Planned hours])*100)</calculation>
      <calculation name="Absence day Percent" visible="true" lastmodified="2020-03-11T08:00:00.5563661Z" format="#,#0.00">iif ([Planned day]=0,null,([Absent day]/[Planned day])*100)</calculation>
    </cube>
    <cube name="HR Salesperson" factcatalog="" factschema="" fact="dSalesperson" lastmodified="2021-10-08T12:47:16.6222787Z" visible="false">
      <dimension shared="true" name="Salesperson Age" />
      <dimension shared="true" name="Salesperson Agegroup" />
      <dimension shared="true" name="Salesperson Department" />
      <dimension shared="true" name="Salesperson Gender" />
      <dimension shared="true" name="Salesperson Job Satisfaction" />
      <dimension shared="true" name="Salesperson Paylevel" />
      <dimension shared="true" name="Salesperson Name" />
      <dimension shared="true" name="Salesperson Seniority" />
      <dimension shared="true" name="Salesperson Manager Hierarchy" />
      <dimension shared="true" name="Salesperson Age Hierarchy" />
      <measure name="No of Employees" visible="true" lastmodified="2020-03-10T09:25:16.0287495Z" format="#,#" aggregate="count" measuredatatype="integer" datatype="integer" datasize="0">ID</measure>
      <measure name="Age" visible="true" lastmodified="2020-03-10T09:25:17.838244Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Age</measure>
      <measure name="Seniority" visible="true" lastmodified="2020-03-10T09:25:24.5150698Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Seniority</measure>
      <measure name="Job Satisfaction" visible="true" lastmodified="2020-03-10T09:25:20.8271917Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Job Satisfaction</measure>
      <measure name="Paylevel" visible="true" lastmodified="2020-03-10T09:25:22.729572Z" format="#,##0" aggregate="sum" measuredatatype="integer" datatype="integer" datasize="0">Paylevel</measure>
    </cube>
    <cube name="HR Staff Turnover" factcatalog="" factschema="" fact="Staff_Turnover" lastmodified="2021-10-08T11:40:13.3031757Z" visible="false">
      <dimension shared="true" name="Date" />
      <dimension shared="true" name="Day of Month" />
      <dimension shared="true" name="Month" />
      <dimension shared="true" name="Month Short" />
      <dimension shared="true" name="Quarter" />
      <dimension shared="true" name="Weekday" />
      <dimension shared="true" name="Weekday Short" />
      <dimension shared="true" name="Weeknumber" />
      <dimension shared="true" name="Year" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YWD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YMD" />
      <dimension shared="true" name="Fiscal YQMD" />
      <dimension shared="true" name="YQMD" />
      <dimension shared="true" name="YMD" />
      <measure name="Staff Turnover Rate" visible="true" lastmodified="2020-03-10T09:26:55.8607635Z" format="#,##0" aggregate="sum" measuredatatype="float" datatype="float" datasize="0">Staff Turnover Rate</measure>
    </cube>
    <cube virtual="true" name="Sales" lastmodified="2025-05-12T07:45:24.9055132Z">
      <cube name="Sales Invoice Line" ignoreunrelatedcriteria="true">
        <calculation name="Invoice Quantity" />
        <calculation name="Invoice Amount" />
        <calculation name="Invoice Cost" />
        <calculation name="Credit Memo Quantity" />
        <calculation name="Credit Memo Amount" />
        <calculation name="Credit Memo Cost" />
        <calculation name="Revenue" />
        <calculation name="Units Sold" />
        <calculation name="Costs" />
        <calculation name="Profit" />
        <calculation name="Profit Margin" />
        <calculation name="Budget Variance" />
        <calculation name="Budget Variance %" />
        <calculation name="No of Sales" />
        <measure name="InvoiceQuantity" />
        <measure name="InvoiceAmount" />
        <measure name="InvoiceCost" />
        <measure name="CreditMemoQuantity" />
        <measure name="CreditMemoAmount" />
        <measure name="CreditMemoCost" />
        <measure name="Budget Amount" />
        <measure name="SalesCount" />
        <measure name="CreditMemoCount" />
      </cube>
      <cube name="Sales Pipeline" ignoreunrelatedcriteria="true">
        <calculation name="Average Leadtime" />
        <measure name="Pipeline Amount" />
        <measure name="No of Opportunities" />
        <measure name="Weighted Amount" />
        <measure name="Leadtime" />
      </cube>
      <dimension name="Item Name" />
      <dimension name="Item Google Search URL" />
      <dimension name="Date" />
      <dimension name="Day of Month" />
      <dimension name="Month" />
      <dimension name="Month Short" />
      <dimension name="Quarter" />
      <dimension name="Weekday" />
      <dimension name="Weekday Short" />
      <dimension name="Weeknumber" />
      <dimension name="Year" />
      <dimension name="Fiscal YQMD" />
      <dimension name="YWD" />
      <dimension name="Fiscal YMD" />
      <dimension name="Company" />
      <dimension name="Customer Country" />
      <dimension name="Customer Name" />
      <dimension name="Customer Region" />
      <dimension name="Customer Territory" />
      <dimension name="Customer Hierarchy" />
      <dimension name="Salesperson Age" />
      <dimension name="Salesperson Agegroup" />
      <dimension name="Salesperson Department" />
      <dimension name="Salesperson Gender" />
      <dimension name="Salesperson Job Satisfaction" />
      <dimension name="Salesperson Paylevel" />
      <dimension name="Salesperson Name" />
      <dimension name="Salesperson Seniority" />
      <dimension name="Invoice No" />
      <dimension name="Expected Date.Date" />
      <dimension name="Expected Date.Day of Month" />
      <dimension name="Expected Date.Month" />
      <dimension name="Expected Date.Month Short" />
      <dimension name="Expected Date.Quarter" />
      <dimension name="Expected Date.Weekday" />
      <dimension name="Expected Date.Weekday Short" />
      <dimension name="Expected Date.Weeknumber" />
      <dimension name="Expected Date.Year" />
      <dimension name="Expected Date.YQMD" />
      <dimension name="Expected Date.YWD" />
      <dimension name="Expected Date.YMD" />
      <dimension name="Expected Date.Fiscal YMD" />
      <dimension name="Expected Date.Fiscal YQMD" />
      <dimension name="Salesperson Manager Hierarchy" />
      <dimension name="Salesperson Age Hierarchy" />
      <dimension name="Item Hierarchy" />
      <dimension name="YQMD" />
      <dimension name="YMD" />
      <dimension name="Longitude" />
      <dimension name="Latitude" />
      <dimension name="Salesperson Email" />
      <dimension name="Country Manager Email" />
      <dimension name="Opportunity Number" />
      <dimension name="Opportunity Probability" />
      <dimension name="Created Date.Date" />
      <dimension name="Created Date.Day of Month" />
      <dimension name="Created Date.Month" />
      <dimension name="Created Date.Month Short" />
      <dimension name="Created Date.Quarter" />
      <dimension name="Created Date.Weekday" />
      <dimension name="Created Date.Weekday Short" />
      <dimension name="Created Date.Weeknumber" />
      <dimension name="Created Date.Year" />
      <dimension name="Created Date.YQMD" />
      <dimension name="Created Date.YWD" />
      <dimension name="Created Date.YMD" />
      <dimension name="Created Date.Fiscal YMD" />
      <dimension name="Created Date.Fiscal YQMD" />
    </cube>
    <cube virtual="true" name="Inventory" lastmodified="2025-06-27T11:02:02.1343478Z">
      <cube name="Inventory Ledger Entry" ignoreunrelatedcriteria="true">
        <measure name="Quantity" />
        <measure name="Increase" />
        <measure name="Decrease" />
      </cube>
      <cube name="Inventory Sales Line" ignoreunrelatedcriteria="true">
        <calculation name="Invoice Amount" />
        <calculation name="Invoice Cost" />
        <calculation name="Credit Memo Quantity" />
        <calculation name="Credit Memo Amount" />
        <calculation name="Credit Memo Cost" />
        <calculation name="Revenue" />
        <calculation name="Cost" />
        <calculation name="Units Sold" />
        <calculation name="Unit Cost" />
        <calculation name="Profit" />
        <calculation name="Profit Margin" />
        <calculation name="No of Sales" />
        <measure name="InvoiceQuantity" />
        <measure name="Inv Discount Amount" />
        <measure name="InvoiceAmount" />
        <measure name="InvoiceCost" />
        <measure name="CreditMemoQuantity" />
        <measure name="CreditMemoAmount" />
        <measure name="CreditMemoCost" />
        <measure name="Budget Amount" />
        <measure name="SalesCount" />
        <measure name="CreditMemoCount" />
      </cube>
      <dimension name="Item Name" />
      <dimension name="Item Google Search URL" />
      <dimension name="Date" />
      <dimension name="Day of Month" />
      <dimension name="Month" />
      <dimension name="Month Short" />
      <dimension name="Quarter" />
      <dimension name="Weekday" />
      <dimension name="Weekday Short" />
      <dimension name="Weeknumber" />
      <dimension name="Year" />
      <dimension name="Fiscal YQMD" />
      <dimension name="YWD" />
      <dimension name="Fiscal YMD" />
      <dimension name="Company" />
      <dimension name="Item Hierarchy" />
      <dimension name="YQMD" />
      <dimension name="YMD" />
      <dimension name="Item Status" />
      <dimension name="Stock Location" />
      <dimension name="Return Reason" />
    </cube>
    <cube virtual="true" name="HR" lastmodified="2021-10-08T12:47:16.6241978Z">
      <cube name="HR Absence" ignoreunrelatedcriteria="true">
        <calculation name="Absence hour Percent" />
        <calculation name="Absence day Percent" />
        <measure name="Planned hours" />
        <measure name="Absence Hours" />
        <measure name="Absent Day" />
        <measure name="Planned Day" />
      </cube>
      <cube name="HR Salesperson" ignoreunrelatedcriteria="true">
        <measure name="No of Employees" />
        <measure name="Age" />
        <measure name="Seniority" />
        <measure name="Job Satisfaction" />
        <measure name="Paylevel" />
      </cube>
      <cube name="HR Staff Turnover" ignoreunrelatedcriteria="true">
        <measure name="Staff Turnover Rate" />
      </cube>
      <dimension name="Date" />
      <dimension name="Day of Month" />
      <dimension name="Month" />
      <dimension name="Month Short" />
      <dimension name="Quarter" />
      <dimension name="Weekday" />
      <dimension name="Weekday Short" />
      <dimension name="Weeknumber" />
      <dimension name="Year" />
      <dimension name="Fiscal YQMD" />
      <dimension name="YWD" />
      <dimension name="Fiscal YMD" />
      <dimension name="Salesperson Age" />
      <dimension name="Salesperson Agegroup" />
      <dimension name="Salesperson Department" />
      <dimension name="Salesperson Gender" />
      <dimension name="Salesperson Job Satisfaction" />
      <dimension name="Salesperson Paylevel" />
      <dimension name="Salesperson Name" />
      <dimension name="Salesperson Seniority" />
      <dimension name="Salesperson Manager Hierarchy" />
      <dimension name="Salesperson Age Hierarchy" />
      <dimension name="YQMD" />
      <dimension name="YMD" />
      <dimension name="Absence Reason" />
      <dimension name="Absence Reason Group" />
    </cube>
  </cubes>
</analysisDatabase>