<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Perhaps try the saiku mailing list.<br><br>Sent from my iPhone</div><div><br>On Mar 20, 2016, at 8:01 AM, Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com">ravi.prakash.shahi@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">Hi Guys please help me on this.</div><br><div class="gmail_quote"><div dir="ltr">On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com">ravi.prakash.shahi@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Guys, <div><br></div><div>I am facing slowness problem on Saiku, after digging a bit into it, i found out</div><div><br></div><div>1. Saiku fires one query for each dimension in the mondrian cube, it tries to calculate all the measures against each dimension.</div><div>2. These results cannot be used in the final report which gets displayed, so I don't know why Saiku is doing it.</div><div>3. To get the final report it does fire a single query with all the dimensions and measure.</div><div><br></div><div> </div><div>- How do I stop saiku to fire intermediatte queries and have it fire only the final required query?</div></div></blockquote></div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Mondrian mailing list</span><br><span><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a></span><br><span><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a></span><br></div></blockquote></body></html>