[Mondrian] duplicate dimensions error

[lists at dankeeley.co.uk]

Interesting, AFAIKT that looks the same!

Here's my DimensionUsage:

    <DimensionUsage name="Priority" source="Priority"
foreignKey="DIM_PRIORITY_ID"/>
    <DimensionUsage name="Previous Priority" source="Previous Priority"
foreignKey="DIM_PRIORITY_PREV_ID"/>

What version of mondrian are you using?

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