[Mondrian] duplicate dimensions error

lists at dankeeley.co.uk lists at dankeeley.co.uk
Wed May 2 10:39:43 EDT 2007


Sorry pasted the wrong bit of xml.  See here, notice dim_priority appears
twice.

  <Dimension name="Priority">
    <Hierarchy hasAll="true" allMemberName="All Priorities"
primaryKey="DIM_PRIORITY_ID">
      <Table name="dim_priority"/>
      <Level name="Priority" column="PRIORITY_NAME" uniqueMembers="true">
	<Property name="Description" column="PRIORITY_DESCRIPTION"/>
      </Level>
    </Hierarchy>
  </Dimension>

  <Dimension name="Previous Priority">
    <Hierarchy hasAll="true" allMemberName="All Priorities"
primaryKey="DIM_PRIORITY_ID">
      <Table name="dim_priority"/>
      <Level name="Priority" column="PRIORITY_NAME" uniqueMembers="true">
	<Property name="Description" column="PRIORITY_DESCRIPTION"/>
      </Level>
    </Hierarchy>
  </Dimension>

> 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>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>




More information about the Mondrian mailing list