[Mondrian] Problems when updating mondrian
miguel
mvillagomez at sayab.com.mx
Tue Aug 7 21:38:03 EDT 2007
Thanks for the help.
El mar, 07-08-2007 a las 11:41 -0700, Julian Hyde escribió:
> You can use the same table more than once in a schema, but you need to
> manually assign them different aliases. By default the alias is the table
> name, so in your example you will have two table usages whose alias is
> 'questions' (or in Spanish I guess 'preguntas').
>
> The reason aliases need to be distinct is that we use them as the alias when
> we generate a SQL statement (e.g. 'select ... from fact, questions as
> preguntas1, questions as preguntas2 where fact.k1 = preguntas1.id_questions
> and fact.k2 = preguntas2.id_questions group by ...')
>
> So, just add the 'aliases' attribute:
>
> > <Table name="questions" alias="preguntas1"/>
> ...
> > <Table name="questions" alias="preguntas2"/>
>
> By the way, this only half-worked in 2.2 and 2.3. For 2.4 we made the schema
> validation rules stricter so that we would generate correct SQL in all
> cases.
>
> Julian
>
> > -----Original Message-----
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org] On Behalf Of miguel
> > Sent: Tuesday, August 07, 2007 11:26 AM
> > To: mondrian at pentaho.org
> > Subject: [Mondrian] Problems when updating mondrian
> >
> > What so.
> >
> > I have mondrian 2,2 working with several cubes to my data base
> > PostgreSQL.
> > Now that I want to update it with mondrian 2,4, profit to pass
> > everything of correct form, with the only exception of which
> > so it seems
> > this new version
> > does not allow me to have two or more dimensions bound to the
> > same table
> > in the data base.
> > This scheme works well in mondrian 2.2:
> >
> > <Dimension name="Have Product 1"
> > caption="%{CubeA_Products.dimension.7}">
> > <Hierarchy hasAll="true" allMemberName="All Products 1"
> > primaryKey="id_question">
> > <Table name="questions"/>
> > <Level name="P1" column="id_question" nameColumn="answer"
> > ordinalColumn="answer" type="String" hideMemberIf="IfBlankName"
> > uniqueMembers="true"/>
> > </Hierarchy>
> > </Dimension>
> >
> > <Dimension name="Have Product 2A"
> > caption="%{CubeA_Products.dimension.8}">
> > <Hierarchy hasAll="true" allMemberName="All Products 2A"
> > primaryKey="id_question">
> > <Table name="questions"/>
> > <Level name="P2A" column="id_question" nameColumn="answer"
> > ordinalColumn="answer" type="String" hideMemberIf="IfBlankName"
> > uniqueMembers="true"/>
> > </Hierarchy>
> > </Dimension>
> >
> > This is the table in postgres:
> >
> > cCubeA_Products=# SELECT * FROM questions;
> > id_questions | answer
> > --------------+----------
> > 313 | ----
> > 314 | YES
> > 315 | NO
> > (3 rows)
> >
> > My problem is that in the new version (2,4 mondrian), this is not
> > accepted and it leaves the error to me:
> >
> > javax.servlet.ServletException: javax.servlet.jsp.JspException:
> > org.apache.jasper.JasperException:
> > javax.servlet.ServletException: javax.servlet.jsp.JspException:
> > mondrian.olap.MondrianException:
> > Mondrian Error:Duplicate table alias 'preguntas' in cube
> > 'CubeA_Products'
> >
> > I do not want to use tables in-line, due to these reasons:
> >
> > - I do not want to slow down the cube
> > - I have at least other 15 cubes in the same situation
> > - I have to Kettle (ETTL), formed for the obtaining of each
> > one of the
> > bases of these cubes
> > - To avoid the time that would take me to modify each cube in they
> > mondrian and each process in Kettle, being one more a "elegant"
> > solution.
> >
> > They can help me?
> >
> > NOTE. - I put as much this in the forum as in the list of
> > post office so
> > that announcement was in this last one where the liberation.
> >
> > _______________________________________________
> > 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
More information about the Mondrian
mailing list