<div dir="ltr">Sure thing. Put anything you can share in a Jira case and let me know the #.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 5, 2013 at 11:24 AM, Tom Barber(Alabs) <span dir="ltr">&lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div text="#000000" bgcolor="#FFFFFF">
    <div>Okay I don&#39;t have a foodmart repro path
      Luc but I do know whats causing it.<br>
      <br>
      My client has written a schema which has a User dimension,<br>
      <br>
      within that dimension it has a bunch of attributes that reference
      more than one table one of them is:<br>
      <br>
      &lt;Attribute name=&quot;Path ID&quot; keyColumn=&quot;PATH_ID&quot; table=&quot;LKP_PATH&quot;
      hasHierarchy=&#39;false&#39;/&gt;<br>
            &lt;Attribute name=&quot;Path Configuration&quot;
      keyColumn=&quot;CONFIGURATION&quot; table=&quot;LKP_PATH&quot;
      hasHierarchy=&#39;false&#39;/&gt;<br>
      <br>
      and then they include those attributes in a Hierarchy:<br>
      <br>
      &lt;Hierarchy name=&#39;Path&#39; allMemberName=&#39;All Path&#39;&gt;<br>
                  &lt;Level attribute=&#39;Path ID&#39; /&gt;<br>
                  &lt;Level attribute=&#39;Path Configuration&#39;/&gt;<br>
              &lt;/Hierarchy&gt; <br>
      <br>
      This is all parsed fine by Mondrian and the schema loads.<br>
      <br>
      <br>
      But as soon as you enable that Hierarchy and then use the Path ID
      field elsewhere in the schema, in their case they also have a
      dimension called Path which also uses the LKP_PATH table, thats
      when the SQL gets aliased incorrectly.<br>
      <br>
      Luc I can send you their schema and SQL table structure offline if
      that would help.<span class="HOEnZb"><font color="#888888"><br>
      <br>
      Tom</font></span><div class="im"><br>
      <br>
      <br>
      On 05/06/13 15:46, Luc Boudreau wrote:<br>
    </div></div><div><div class="h5">
    <blockquote type="cite">
      <div dir="ltr">Can you reproduce this on FoodMart? I&#39;d like to
        create an item in Jira so we address this ASAP.<br>
      </div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Wed, Jun 5, 2013 at 10:03 AM, Tom
          Barber(Alabs) <span dir="ltr">&lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF">
              <div>Hi Luc, the SQL itself I&#39;d stripped out, <br>
                <br>
                All I&#39;m doing it putting a Level.Member  on Rows and a
                Measure on the columns.<br>
                <br>
                And I get: <br>
                Caused by: mondrian.olap.MondrianException: Mondrian
                Error:Failed to load segment form SQL<br>
                        at
mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643)<br>
                        at
                mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)<br>
                        ... 8 more<br>
                Caused by: mondrian.olap.MondrianException: Mondrian
                Error:Internal error: Error while loading segment;
                sql=[select `LKP_PATH`.`PATH_ID` as `c0`,
                count(`FCT_RESUMEUPLOAD`.`FACT_RESUMEUPLOAD_KEY`) as
                `m0` from `LKP_PATH` as `LKP_PATH_1`, `FCT_RESUMEUPLOAD`
                as `FCT_RESUMEUPLOAD` where
                `FCT_RESUMEUPLOAD`.`PATH_KEY` = `LKP_PATH`.`PATH_KEY`
                and `LKP_PATH`.`PATH_ID` = &#39;hello&#39; group by
                `LKP_PATH`.`PATH_ID`]<br>
                <br>
                Thats the real SQL generated. I&#39;m using the latest
                Mondrian 4 + Saiku build from our CI, its tagged
                4.0.0-SNAPSHOT so I don&#39;t know what exact Mondrian 4
                build it used but it was built 11 hours ago.<br>
                <br>
                mysql  Ver 14.14 Distrib 5.5.31, for Linux (x86_64)
                using readline 5.1<br>
                <br>
                I was actually trying to debug another issue for a
                client, but I can&#39;t even run this query.<br>
                <br>
                Cheers<span><font color="#888888"><br>
                    <br>
                    Tom</font></span>
                <div>
                  <div><br>
                    <br>
                    <br>
                    On 05/06/13 14:46, Luc Boudreau wrote:<br>
                  </div>
                </div>
              </div>
              <div>
                <div>
                  <blockquote type="cite">
                    <div dir="ltr">
                      <div>Where is that SQL generated? Is this a tuple
                        query? This looks like a bug; not a dialect
                        issue.<br>
                        <br>
                      </div>
                      Luc<br>
                    </div>
                    <div class="gmail_extra"><br>
                      <br>
                      <div class="gmail_quote">On Wed, Jun 5, 2013 at
                        9:09 AM, Tom Barber(Alabs) <span dir="ltr">&lt;<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt;</span>
                        wrote:<br>
                        <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello Mondrian fans,<br>
                          <br>
                          I&#39;m trying to get a schema running under
                          Mondrian 4 and Mysql and when a<br>
                          query is run its generating SQL like this:<br>
                          <br>
                          select `LKP_PATH`.`PATH_ID` as `c0` from
                          `LKP_PATH` as `LKP_PATH_1`;<br>
                          <br>
                          which MySQL is getting upset over because the
                          table name at the start of<br>
                          the select isn&#39;t the aliased table name but
                          the original:<br>
                          <br>
                            select `LKP_PATH_1`.`PATH_ID` as `c0` from
                          `LKP_PATH` as `LKP_PATH_1`;<br>
                          <br>
                          The above is a valid query.<br>
                          <br>
                          Any property I can set to get this working?<br>
                          <br>
                          Thanks<br>
                          <br>
                          Tom<br>
_______________________________________________<br>
                          Mondrian mailing list<br>
                          <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
                          <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
                        </blockquote>
                      </div>
                      <br>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                    <pre>_______________________________________________
Mondrian mailing list
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a>
</pre>
                  </blockquote>
                  <br>
                </div>
              </div>
            </div>
            <br>
            _______________________________________________<br>
            Mondrian mailing list<br>
            <a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
            <a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset></fieldset>
      <br>
      <pre>_______________________________________________
Mondrian mailing list
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a>
</pre>
    </blockquote>
    <br>
  </div></div></div>

<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>