<?xml version="1.0" encoding="UTF-8"?>
<project name="com.jedox.demo.integratorsamples~sampleDenormalization" version="25.2" modified="1673596627405" modifiedBy="admin" olapId="p7" uiVersion="0.1">
  <headers>
    <header name="comment" modified="1673596627405" modifiedBy="admin">
      <comment>ETL Demo Project.
Shows how to de-normalize data with transform Denormalize: Input rows with individual row for each measure are transformed to rows with measure values in separate columns.</comment>
    </header>
  </headers>
  <variables />
  <connections>
    <connection name="olapdemo" type="JedoxOlap" modified="1673596627405" modifiedBy="admin">
      <comment><![CDATA[Olap database from which the data is extracted]]></comment>
      <global nameref="localhost" />
      <database>Demo</database>
    </connection>
  </connections>
  <extracts>
    <extract name="Sales_Extract" type="Cube" modified="1673596627405" modifiedBy="admin">
      <connection nameref="olapdemo" valuename="Value" />
      <query>
        <cube name="Sales" valuename="Value" />
        <dimensions>
          <dimension name="Versions">
            <condition operator="equal" mode="onlyBases" type="accept"><![CDATA[Actual]]></condition>
          </dimension>
          <dimension name="Products">
            <condition operator="equal" mode="onlyBases" type="accept"><![CDATA[Desktop L]]></condition>
          </dimension>
        </dimensions>
      </query>
    </extract>
    <extract modified="1673596627405" name="Measures_Extract" type="Dimension" modifiedBy="admin">
      <connection nameref="olapdemo" />
      <query>
        <dimension name="Measures">
          <condition mode="onlyBases" operator="like" type="accept"><![CDATA[.]]></condition>
        </dimension>
      </query>
    </extract>
  </extracts>
  <transforms>
    <transform name="Sales_Denormalize" type="TableDenormalization" modified="1673596627405" modifiedBy="admin">
      <sources>
        <source nameref="Sales_Extract" />
      </sources>
      <target>
        <coordinates>
          <coordinate>
            <input nameref="Years" />
          </coordinate>
          <coordinate>
            <input nameref="Months" />
          </coordinate>
          <coordinate>
            <input nameref="Regions" />
          </coordinate>
        </coordinates>
        <measures denormalize="Measures">
          <measure name="Units" aggregate="none">
            <input nameref="Value" />
          </measure>
          <measure name="Cost of Sales" aggregate="none">
            <input nameref="Value" />
          </measure>
          <measure name="Turnover" aggregate="none">
            <input nameref="Value" />
          </measure>
        </measures>
      </target>
    </transform>
    <transform name="Denormalize_AllKeys" type="TableDenormalization" modified="1673596627405" modifiedBy="admin">
      <sources>
        <source nameref="Sales_Extract" />
      </sources>
      <target>
        <coordinates include="." keepSourceOrder="true" />
        <measures denormalize="Measures">
          <measure aggregate="none" name="Units">
            <input nameref="Value" />
          </measure>
          <measure aggregate="none" name="Cost of Sales">
            <input nameref="Value" />
          </measure>
          <measure aggregate="none" name="Turnover">
            <input nameref="Value" />
          </measure>
        </measures>
      </target>
    </transform>
    <transform modified="1673596627405" name="Denormalize_DynamicMeasures" type="TableDenormalization" modifiedBy="admin">
      <sources>
        <source nameref="Sales_Extract" />
      </sources>
      <target>
        <coordinates>
          <coordinate>
            <input nameref="Years" />
          </coordinate>
        </coordinates>
        <measures aggregate="none" denormalize="Measures" source="Measures_Extract" valuename="Value" />
      </target>
    </transform>
    <transform name="Denormalize_with_Aggregation" type="TableDenormalization" modified="1673596627405" modifiedBy="admin">
      <sources>
        <source nameref="Sales_Extract" />
      </sources>
      <target>
        <coordinates>
          <coordinate>
            <input nameref="Years" />
          </coordinate>
          <coordinate>
            <input nameref="Months" />
          </coordinate>
          <coordinate>
            <input nameref="Regions" />
          </coordinate>
        </coordinates>
        <measures denormalize="Measures">
          <measure name="Units" aggregate="sum">
            <input nameref="Value" />
          </measure>
          <measure name="Cost of Sales" aggregate="sum">
            <input nameref="Value" />
          </measure>
          <measure name="Turnover" aggregate="sum">
            <input nameref="Value" />
          </measure>
        </measures>
      </target>
    </transform>
  </transforms>
  <loads />
  <jobs />
</project>
