Unique visitors cube

unique_visitors.mondrian.xml

<Schema name="UNIQUE_VISITORS">

  <Cube name="UNIQUE_VISITORS" cache="true" enabled="true">
    <Table name="SAMPLE_UNIQUE_VISITORS">
    </Table>
    <Dimension foreignKey="day" name="Date">
      <Hierarchy hasAll="true" primaryKey="day_date">
        <Table name="DIM_DATE">
        </Table>
        <Level name="Year" column="year_number" type="Numeric" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never">
        </Level>
        <Level name="Month" column="month_number" nameColumn="month_name" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
        </Level>
        <Level name="Day" column="day_of_month_number" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
  
    <Dimension name="Website">
      <Hierarchy hasAll="true">
        <Level name="Website" column="publisher_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
      </Hierarchy>
    </Dimension>
      
    <Measure name="Unique users sample" column="user_md5" datatype="Integer" formatString="#,###" aggregator="distinct-count" visible="false">
    </Measure>

  <CalculatedMember name="Unique users" dimension="Measures">
    <Formula>[Measures].[Unique users sample] * 256</Formula>
    <CalculatedMemberProperty name="FORMAT_STRING" value="#,###"/>
  </CalculatedMember>
  
  </Cube>