<Schema name="OpenHealth">

<Cube name="data_ou4">
	<Table name="aggregateddatavalue" />
	<Dimension  name="Location" foreignKey="organisationunitid">
   	    <Hierarchy hasAll="false" primaryKey="ou4id">
	       	<Table name="view_ou4" />
		<Level name="OrgUnit1" column="ou1geo" captionColumn="ou1short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit2" column="ou2geo" captionColumn="ou2short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit3" column="ou3geo" captionColumn="ou3short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit4" column="ou4short" type="String" uniqueMembers="true" />
	    </Hierarchy>
	</Dimension>
		
	<Dimension name="Dataelement" foreignKey="dataelementid" >
		<Hierarchy hasAll="false" primaryKey="dataelementid">
			<Table name="view_dataelement" />
				<Level name="Dataelement" column="shortname" type="String" uniqueMembers="true" />
		</Hierarchy>
	</Dimension>
		
	<Dimension name="Period" foreignKey="periodid">
		<Hierarchy hasAll="true" primaryKey="periodid">
			<Table name="view_period_data"/>
			<Level name="Year" column="year" type="Integer" uniqueMembers="true"/>
			<Level name="Month" column="monthname" type="String" uniqueMembers="false"/>
		</Hierarchy>
	</Dimension>

	<Measure name="Datavalue" column="value" aggregator="sum" datatype="Numeric" />
</Cube>

<Cube name="ind_ou3">
	<Table name="aggregatedindicatorvalue" />
	<Dimension  name="Location" foreignKey="organisationunitid">
   	    <Hierarchy hasAll="false" primaryKey="ou3id">
	       	<Table name="view_ou3" />
		<Level name="OrgUnit1" column="ou1geo" captionColumn="ou1short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit2" column="ou2geo" captionColumn="ou2short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit3" column="ou3geo" captionColumn="ou3short" type="String" uniqueMembers="true" />
	    </Hierarchy>
	</Dimension>
		
	<Dimension name="Indicator" foreignKey="indicatorid" >
		<Hierarchy hasAll="false" primaryKey="indicatorid">
			<Table name="view_indicator" />
				<Level name="Indicator" column="shortname" type="String" uniqueMembers="true" />
		</Hierarchy>
	</Dimension>
		
	<Dimension name="Period" foreignKey="periodid">
		<Hierarchy hasAll="true" primaryKey="periodid">
			<Table name="view_period_ind"/>
			<Level name="Year" column="year" type="Integer" uniqueMembers="true"/>
			<Level name="Month" column="monthname" type="String" uniqueMembers="false"/>
		</Hierarchy>
	</Dimension>

	<Measure name="IndValue" column="value" aggregator="avg" datatype="Numeric" />
</Cube>

<Cube name="ind_ou2">
	<Table name="aggregatedindicatorvalue" />
	<Dimension  name="Location" foreignKey="organisationunitid">
   	    <Hierarchy hasAll="false" primaryKey="ou2id">
	       	<Table name="view_ou2" />
		<Level name="OrgUnit1" column="ou1geo" captionColumn="ou1short" type="String" uniqueMembers="true" />
		<Level name="OrgUnit2" column="ou2geo" captionColumn="ou2short" type="String" uniqueMembers="true" />
	    </Hierarchy>
	</Dimension>
		
	<Dimension name="Indicator" foreignKey="indicatorid" >
		<Hierarchy hasAll="false" primaryKey="indicatorid">
			<Table name="view_indicator" />
				<Level name="Indicator" column="shortname" type="String" uniqueMembers="true" />
		</Hierarchy>
	</Dimension>
		
	<Dimension name="Period" foreignKey="periodid">
		<Hierarchy hasAll="true" primaryKey="periodid">
			<Table name="view_period_ind"/>
			<Level name="Year" column="year" type="Integer" uniqueMembers="true"/>
			<Level name="Month" column="monthname" type="String" uniqueMembers="false"/>
		</Hierarchy>
	</Dimension>

	<Measure name="IndValue" column="value" aggregator="avg" datatype="Numeric" />
</Cube>


</Schema>