<Schema name="SchemaTP1">
  <Cube name="StarCube1" visible="true" cache="true" enabled="true">
    <Table name="pops">
    </Table>
    <Dimension type="StandardDimension" visible="true" foreignKey="FK_SEXAGE" highCardinality="false" name="Sexe">
      <Hierarchy name="hierarchieSexe" visible="true" hasAll="true" primaryKey="SEXAGE">
        <Table name="sexage">
        </Table>
        <Level name="levelSexe" visible="true" column="SEXE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" foreignKey="FK_SEXAGE" highCardinality="false" name="Age">
      <Hierarchy name="hierarchieAge" visible="true" hasAll="true" primaryKey="SEXAGE">
        <Table name="sexage">
        </Table>
        <Level name="levelAge" visible="true" column="AGE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" foreignKey="FK_ZIPCODE" highCardinality="false" name="Classification">
      <Hierarchy name="hierarchieClassification" visible="true" hasAll="true" primaryKey="ZIPCODE">
        <Table name="areaclas">
        </Table>
        <Level name="levelArea" visible="true" column="ZIPCODE" nameColumn="LABEL" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
        <Level name="levelCluster" visible="true" column="CLUSTERCOD" nameColumn="CLUSTERNAM" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
        <Level name="levelGroup" visible="true" column="GROUPCODE" nameColumn="GROUPNAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
        <Level name="levelFamily" visible="true" column="FAMILYCODE" nameColumn="FAMILYNAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" highCardinality="false" name="Annee">
      <Hierarchy name="hierarchieAnnee" visible="true" hasAll="true">
        <Level name="levelAnnee" visible="true" column="YEAR" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
    <Dimension type="StandardDimension" visible="true" highCardinality="false" name="Geographie" foreignKey="FK_ZIPCODE">
	<Hierarchy hasAll="true" name="hierarchieGeographie" visible="true" primaryKey="ZIPCODE">
	<Join leftKey="FK_COUNTY" rightAlias="COUNTY" rightKey="COUNTY">
	<Table name="areaclas"/>
	<Join leftKey="FK_CODEREGION" rightAlias="CODEREGION"  rightKey="CODEREGION">
		<Table name="county"/>
		<Table name="region"/>
		</Join>
	</Join>
	<Level name="levelArea" visible="true" column="ZIPCODE" nameColumn="LABEL" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
    </Level>
    <Level name="levelCounty" visible="true" column="COUNTY" nameColumn="NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
	</Level>
	<Level name="levelRegion" visible="true" column="CODEREGION" nameColumn="LABELREGION" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
	</Level>
    </Dimension>
    <Measure name="number" column="NB" aggregator="sum" visible="true">
    </Measure>
  </Cube>
</Schema>