[Mondrian] duplicate dimensions error

[miguel]

I put an example to you of which I do in those cases. All the dimensions
come from the same table.

 <Dimension name="1_Conoce e-learning?">
  <Hierarchy hasAll="true" allMemberName="1_Todos" primaryKey="id_sp">
   <Table name="pregunta_simple_texto"/>
   <Level name="elearning" column="id_sp" nameColumn="simtext"
type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

 <Dimension name="2_Aprendizaje por internet?">
  <Hierarchy hasAll="true" allMemberName="2_Todos" primaryKey="id_sp">
   <Table name="pregunta_simple_texto"/>
   <Level name="aprendizaje" column="id_sp" nameColumn="simtext"
type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

 <Dimension name="6_Tiene PC/Laptop?">
  <Hierarchy hasAll="true" allMemberName="6_Todos" primaryKey="id_sp">
   <Table name="pregunta_simple_texto"/>
   <Level name="tienepc" column="id_sp" nameColumn="simtext"
type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
  </Hierarchy>
 </Dimension>

It observes as I relate them within the cube. Single the one column
id_sp of my dimensions with a different column within the cube.

 <Cube name="Encuesta_1">
  <Table name="encuesta_1"/>
   <DimensionUsage name="1_Conoce e-learning?" source="1_Conoce
e-learning?" foreignKey="id_1_1"/>
   <DimensionUsage name="2_Aprendizaje por internet?"
source="2_Aprendizaje por internet?" foreignKey="id_1_2"/>
   <DimensionUsage name="6_Tiene PC/Laptop?" source="6_Tiene PC/Laptop?"
foreignKey="id_2_6"/>
  <Measure name="id" column="id" aggregator="count" datatype="Integer"
visible="false"/>
 </Cube>


El mié, 02-05-2007 a las 15:39 +0100, lists at dankeeley.co.uk escribió:
> 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
> >
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian