<p dir="ltr">1. Enabling cache is not an option because we using saiku to connect to real time database which gets updated every 10 minutes.</p>
<p dir="ltr">2. It's stalling in between, before it can fire the final query which will return the actual report.</p>
<p dir="ltr">3. I don't think it's just Metadata lookup, it's trying to calculate all the Measures for each dimension in the cube, so if I have 15 dimensions it's firing 15 queries, and other queries on the dimension table which might be the Metadata lookup.</p>
<p dir="ltr">4. I want to disable those 15 queries which doesn't make sense to me because those numbers cannot be displayed on the final report.</p>
<div class="gmail_quote">On 21 Mar 2016 1:48 am, "Tom Barber" <<a href="mailto:tom@analytical-labs.com">tom@analytical-labs.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">1) If your cache is enabled, it should only fire the discovery stuff once until the cache is cleared, i would have thought, but I've never looked too hard.<div><br></div><div>2) If its executing the queries, and stalling later, why are you asking to turn off metadata lookup?</div><div><br></div><div>3) Great.<br><div><br></div><div><br></div></div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr">--------------<div><br></div><div><div style="font-size:small"><font color="#999999">Director Meteorite.bi - Saiku Analytics Founder</font></div><div style="font-size:small"><font color="#999999">Tel: +44(0)5603641316 </font></div><div style="font-size:small"><font color="#999999"><br></font></div><div style="font-size:small"><font color="#999999">(Thanks to the Saiku community we reached our <a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" target="_blank">Kickstart</a> goal, but you can always help by <a href="http://www.meteorite.bi/products/saiku/sponsorship" target="_blank">sponsoring the project</a>)</font></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 20 March 2016 at 18:18, Ravi Prakash <span dir="ltr"><<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Tom, Thanks a lot for the Response.<div><br></div><div>1. I have disabled caching, should it still fire the queries used for caching?</div><div><br></div><div>2. I don't think it's the database problem, </div><div> i. All the queries fired by saiku gets executed.</div><div> ii. but still saiku is not displaying the report, at this moment no query is running on the database and the CPU usage of SAIKU machine is high, so saiku is trying is do some internal processing and the UI keeps on spinning and no result for long time.</div><div>Note: This happens when the result set is quite huge, I have also tried upgrading the saiku machine, but no help.</div><div><br></div><div>2. I will try the to look into the code.<br><br>Thanks</div><div>Ravi Prakash<br><div class="gmail_quote"><div dir="ltr">On Sun, 20 Mar 2016 at 23:25 <<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Mondrian mailing list submissions to<br>
<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mondrian-request@pentaho.org" target="_blank">mondrian-request@pentaho.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:mondrian-owner@pentaho.org" target="_blank">mondrian-owner@pentaho.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Mondrian digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Saiku Multiple Queries (Justin Swanhart)<br>
2. Re: Saiku Multiple Queries (Tom Barber)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sun, 20 Mar 2016 10:50:24 -0700<br>
From: Justin Swanhart <<a href="mailto:greenlion@gmail.com" target="_blank">greenlion@gmail.com</a>><br>
Subject: Re: [Mondrian] Saiku Multiple Queries<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
Message-ID: <<a href="mailto:4F3C8283-ABE4-4984-AC29-4F7320B9BB3A@gmail.com" target="_blank">4F3C8283-ABE4-4984-AC29-4F7320B9BB3A@gmail.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Perhaps try the saiku mailing list.<br>
<br>
Sent from my iPhone<br>
<br>
> On Mar 20, 2016, at 8:01 AM, Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>> wrote:<br>
><br>
> Hi Guys please help me on this.<br>
><br>
>> On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>> wrote:<br>
>> Hi Guys,<br>
>><br>
>> I am facing slowness problem on Saiku, after digging a bit into it, i found out<br>
>><br>
>> 1. Saiku fires one query for each dimension in the mondrian cube, it tries to calculate all the measures against each dimension.<br>
>> 2. These results cannot be used in the final report which gets displayed, so I don't know why Saiku is doing it.<br>
>> 3. To get the final report it does fire a single query with all the dimensions and measure.<br>
>><br>
>><br>
>> - How do I stop saiku to fire intermediatte queries and have it fire only the final required query?<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" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/74b68078/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/74b68078/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sun, 20 Mar 2016 17:54:50 +0000<br>
From: Tom Barber <<a href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>><br>
Subject: Re: [Mondrian] Saiku Multiple Queries<br>
To: Mondrian developer mailing list <<a href="mailto:mondrian@pentaho.org" target="_blank">mondrian@pentaho.org</a>><br>
Message-ID:<br>
<CAEM=DjPjqNiMaY+MjCwDgX-4C0O522AHU_BXnM=-<a href="mailto:U5XettK_7w@mail.gmail.com" target="_blank">U5XettK_7w@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Its alright, i'm here :)<br>
<br>
Mondrian, when it connects will run some bits and pieces to collect<br>
metadata, we also run a few queries to collect filter lists, but basically,<br>
its cache warming, or should be. Either way, I suspect the answer is,<br>
tough, and if its slow, optimise your database :)<br>
<br>
Of course both Mondrian and Saiku are freely available on Github so if you<br>
want to change/improve it, go wild!<br>
<br>
Tom<br>
<br>
<br>
<br>
--------------<br>
<br>
Director Meteorite.bi - Saiku Analytics Founder<br>
Tel: <a href="tel:%2B44%280%295603641316" value="+445603641316" target="_blank">+44(0)5603641316</a><br>
<br>
(Thanks to the Saiku community we reached our Kickstart<br>
<<a href="http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/" rel="noreferrer" target="_blank">http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/</a>><br>
goal, but you can always help by sponsoring the project<br>
<<a href="http://www.meteorite.bi/products/saiku/sponsorship" rel="noreferrer" target="_blank">http://www.meteorite.bi/products/saiku/sponsorship</a>>)<br>
<br>
On 20 March 2016 at 17:50, Justin Swanhart <<a href="mailto:greenlion@gmail.com" target="_blank">greenlion@gmail.com</a>> wrote:<br>
<br>
> Perhaps try the saiku mailing list.<br>
><br>
> Sent from my iPhone<br>
><br>
> On Mar 20, 2016, at 8:01 AM, Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>><br>
> wrote:<br>
><br>
> Hi Guys please help me on this.<br>
><br>
> On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <<a href="mailto:ravi.prakash.shahi@gmail.com" target="_blank">ravi.prakash.shahi@gmail.com</a>><br>
> wrote:<br>
><br>
>> Hi Guys,<br>
>><br>
>> I am facing slowness problem on Saiku, after digging a bit into it, i<br>
>> found out<br>
>><br>
>> 1. Saiku fires one query for each dimension in the mondrian cube, it<br>
>> tries to calculate all the measures against each dimension.<br>
>> 2. These results cannot be used in the final report which gets displayed,<br>
>> so I don't know why Saiku is doing it.<br>
>> 3. To get the final report it does fire a single query with all the<br>
>> dimensions and measure.<br>
>><br>
>><br>
>> - How do I stop saiku to fire intermediatte queries and have it fire only<br>
>> the final required query?<br>
>><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" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><br>
><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" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/66599d6e/attachment.html" rel="noreferrer" target="_blank">http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/66599d6e/attachment.html</a><br>
<br>
------------------------------<br>
<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" rel="noreferrer" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br>
<br>
End of Mondrian Digest, Vol 111, Issue 11<br>
*****************************************<br>
</blockquote></div></div></div>
</blockquote></div><br></div>
</blockquote></div>