[Mondrian] duplicate dimensions error

lists at dankeeley.co.uk lists at dankeeley.co.uk
Wed May 2 10:36:30 EDT 2007


Hi,

The mondrian schema for Software Quality Reports is partly posted below.

It has multiple shared dimensions with the same table name.  This throws
an error saying that the table name cannot be duplicated.

The forums seem to imply that the table name should be able to be duplicated.

Is that right? whats the workaround?

Thanks,
an


<?xml version="1.0"?>
<Schema name="Issues">

  <Dimension name="Time Changed" type="TimeDimension">
    <Hierarchy hasAll="true" allMemberName="All Time"
primaryKey="DIM_TIME_ID">
      <Table name="dim_time"/>
      <Level name="Year" column="YEAR_NUM" uniqueMembers="true"
levelType="TimeYears" type="Numeric"/>
      <Level name="Month" column="MONTH_NUM" nameColumn="MONTH_NAME"
uniqueMembers="false" levelType="TimeMonths"/>
      <Level name="Day" column="DAY_DAY_OF_MONTH" uniqueMembers="false"
levelType="TimeDays" type="Numeric" formatString="##"/>
    </Hierarchy>
  </Dimension>

  <Dimension name="Time Created" type="TimeDimension">
    <Hierarchy hasAll="true" allMemberName="All Time"
primaryKey="DIM_TIME_ID">
      <Level name="Year" column="YEAR_NUM" uniqueMembers="true"
levelType="TimeYears" type="Numeric"/>
      <Level name="Month" column="MONTH_NUM" nameColumn="MONTH_NAME"
uniqueMembers="false" levelType="TimeMonths"/>
      <Level name="Day" column="DAY_DAY_OF_MONTH" uniqueMembers="false"
levelType="TimeDays" type="Numeric" formatString="##"/>
    </Hierarchy>
  </Dimension>

  <Dimension name="Time Released" type="TimeDimension">
    <Hierarchy hasAll="true" allMemberName="All Time"
primaryKey="DIM_TIME_ID">
      <Level name="Year" column="YEAR_NUM" uniqueMembers="true"
levelType="TimeYears" type="Numeric"/>
      <Level name="Month" column="MONTH_NUM" nameColumn="MONTH_NAME"
uniqueMembers="false" levelType="TimeMonths"/>
      <Level name="Day" column="DAY_DAY_OF_MONTH" uniqueMembers="false"
levelType="TimeDays" type="Numeric" formatString="##"/>
    </Hierarchy>
  </Dimension>



More information about the Mondrian mailing list