[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mondrian
Subject:    Re: [Mondrian] Mondrian Digest, Vol 111, Issue 11
From:       Ravi Prakash <ravi.prakash.shahi () gmail ! com>
Date:       2016-03-20 20:59:26
Message-ID: CAJQWdUCDueQu2Xe1x0Pzi3mjqWF6=Ev1Mmv+HhRo0bc8y2CjOQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Thanks Tom, Let me start the debug logs and check what point saiku is
stalling, It's quite late in India, so I let you know my findings tomorrow.
Thanks!!!
On 21 Mar 2016 2:12 am, "Tom Barber" <tom@analytical-labs.com> wrote:

> 1) Fair enough
>
> 2) If its not executing a query though, stopping the queries won't help
> you, I also suspect you can't do a great deal about it. That said, everyone
> else copes, so I would advise you do a kill -3 on a linux box, or if using
> windows find out where mondrian is hanging because if its not the database
> query speed then its doing something else.
>
> 3) its not just metadata it also gathers stats and stuff to formulate the
> SQL that needs to be generated.
>
> 4) See 2.
>
> --------------
>
> Director Meteorite.bi - Saiku Analytics Founder
> Tel: +44(0)5603641316
>
> (Thanks to the Saiku community we reached our Kickstart
> <http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/>
> goal, but you can always help by sponsoring the project
> <http://www.meteorite.bi/products/saiku/sponsorship>)
>
> On 20 March 2016 at 20:32, Ravi Prakash <ravi.prakash.shahi@gmail.com>
> wrote:
>
>> 1. Enabling cache is not an option because we using saiku to connect to
>> real time database which gets updated every 10 minutes.
>>
>> 2. It's stalling in between, before it can fire the final query which
>> will return the actual report.
>>
>> 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.
>>
>> 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.
>> On 21 Mar 2016 1:48 am, "Tom Barber" <tom@analytical-labs.com> wrote:
>>
>>> 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.
>>>
>>> 2) If its executing the queries, and stalling later, why are you asking
>>> to turn off metadata lookup?
>>>
>>> 3) Great.
>>>
>>>
>>>
>>> --------------
>>>
>>> Director Meteorite.bi - Saiku Analytics Founder
>>> Tel: +44(0)5603641316
>>>
>>> (Thanks to the Saiku community we reached our Kickstart
>>> <http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/>
>>> goal, but you can always help by sponsoring the project
>>> <http://www.meteorite.bi/products/saiku/sponsorship>)
>>>
>>> On 20 March 2016 at 18:18, Ravi Prakash <ravi.prakash.shahi@gmail.com>
>>> wrote:
>>>
>>>> Hi Tom, Thanks a lot for the Response.
>>>>
>>>> 1. I have disabled caching, should it still fire the queries used for
>>>> caching?
>>>>
>>>> 2. I don't think it's the database problem,
>>>>   i. All the queries fired by saiku gets executed.
>>>>   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.
>>>> Note: This happens when the result set is quite huge, I have also tried
>>>> upgrading the saiku machine, but no help.
>>>>
>>>> 2. I will try the to look into the code.
>>>>
>>>> Thanks
>>>> Ravi Prakash
>>>> On Sun, 20 Mar 2016 at 23:25 <mondrian-request@pentaho.org> wrote:
>>>>
>>>>> Send Mondrian mailing list submissions to
>>>>>         mondrian@pentaho.org
>>>>>
>>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>>>         http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> or, via email, send a message with subject or body 'help' to
>>>>>         mondrian-request@pentaho.org
>>>>>
>>>>> You can reach the person managing the list at
>>>>>         mondrian-owner@pentaho.org
>>>>>
>>>>> When replying, please edit your Subject line so it is more specific
>>>>> than "Re: Contents of Mondrian digest..."
>>>>>
>>>>>
>>>>> Today's Topics:
>>>>>
>>>>>    1. Re: Saiku Multiple Queries (Justin Swanhart)
>>>>>    2. Re: Saiku Multiple Queries (Tom Barber)
>>>>>
>>>>>
>>>>> ----------------------------------------------------------------------
>>>>>
>>>>> Message: 1
>>>>> Date: Sun, 20 Mar 2016 10:50:24 -0700
>>>>> From: Justin Swanhart <greenlion@gmail.com>
>>>>> Subject: Re: [Mondrian] Saiku Multiple Queries
>>>>> To: Mondrian developer mailing list <mondrian@pentaho.org>
>>>>> Message-ID: <4F3C8283-ABE4-4984-AC29-4F7320B9BB3A@gmail.com>
>>>>> Content-Type: text/plain; charset="us-ascii"
>>>>>
>>>>> Perhaps try the saiku mailing list.
>>>>>
>>>>> Sent from my iPhone
>>>>>
>>>>> > On Mar 20, 2016, at 8:01 AM, Ravi Prakash <
>>>>> ravi.prakash.shahi@gmail.com> wrote:
>>>>> >
>>>>> > Hi Guys please help me on this.
>>>>> >
>>>>> >> On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <
>>>>> ravi.prakash.shahi@gmail.com> wrote:
>>>>> >> Hi Guys,
>>>>> >>
>>>>> >> I am facing slowness problem on Saiku, after digging a bit into it,
>>>>> i found out
>>>>> >>
>>>>> >> 1. Saiku fires one query for each dimension in the mondrian cube,
>>>>> it tries to calculate all the measures against each dimension.
>>>>> >> 2. These results cannot be used in the final report which gets
>>>>> displayed, so I don't know why Saiku is doing it.
>>>>> >> 3. To get the final report it does fire a single query with all the
>>>>> dimensions and measure.
>>>>> >>
>>>>> >>
>>>>> >> - How do I stop saiku to fire intermediatte queries and have it
>>>>> fire only the final required query?
>>>>> > _______________________________________________
>>>>> > Mondrian mailing list
>>>>> > Mondrian@pentaho.org
>>>>> > http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> -------------- next part --------------
>>>>> An HTML attachment was scrubbed...
>>>>> URL:
>>>>> http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/74b68078/attachment-0001.html
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> Message: 2
>>>>> Date: Sun, 20 Mar 2016 17:54:50 +0000
>>>>> From: Tom Barber <tom@analytical-labs.com>
>>>>> Subject: Re: [Mondrian] Saiku Multiple Queries
>>>>> To: Mondrian developer mailing list <mondrian@pentaho.org>
>>>>> Message-ID:
>>>>>         <CAEM=DjPjqNiMaY+MjCwDgX-4C0O522AHU_BXnM=-
>>>>> U5XettK_7w@mail.gmail.com>
>>>>> Content-Type: text/plain; charset="utf-8"
>>>>>
>>>>> Its alright, i'm here :)
>>>>>
>>>>> Mondrian, when it connects will run some bits and pieces to collect
>>>>> metadata, we also run a few queries to collect filter lists, but
>>>>> basically,
>>>>> its cache warming, or should be. Either way, I suspect the answer is,
>>>>> tough, and if its slow, optimise your database :)
>>>>>
>>>>> Of course both Mondrian and Saiku are freely available on Github so if
>>>>> you
>>>>> want to change/improve it, go wild!
>>>>>
>>>>> Tom
>>>>>
>>>>>
>>>>>
>>>>> --------------
>>>>>
>>>>> Director Meteorite.bi - Saiku Analytics Founder
>>>>> Tel: +44(0)5603641316
>>>>>
>>>>> (Thanks to the Saiku community we reached our Kickstart
>>>>> <
>>>>> http://kickstarter.com/projects/2117053714/saiku-reporting-interactive-report-designer/
>>>>> >
>>>>> goal, but you can always help by sponsoring the project
>>>>> <http://www.meteorite.bi/products/saiku/sponsorship>)
>>>>>
>>>>> On 20 March 2016 at 17:50, Justin Swanhart <greenlion@gmail.com>
>>>>> wrote:
>>>>>
>>>>> > Perhaps try the saiku mailing list.
>>>>> >
>>>>> > Sent from my iPhone
>>>>> >
>>>>> > On Mar 20, 2016, at 8:01 AM, Ravi Prakash <
>>>>> ravi.prakash.shahi@gmail.com>
>>>>> > wrote:
>>>>> >
>>>>> > Hi Guys please help me on this.
>>>>> >
>>>>> > On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <
>>>>> ravi.prakash.shahi@gmail.com>
>>>>> > wrote:
>>>>> >
>>>>> >> Hi Guys,
>>>>> >>
>>>>> >> I am facing slowness problem on Saiku, after digging a bit into it,
>>>>> i
>>>>> >> found out
>>>>> >>
>>>>> >> 1. Saiku fires one query for each dimension in the mondrian cube, it
>>>>> >> tries to calculate all the measures against each dimension.
>>>>> >> 2. These results cannot be used in the final report which gets
>>>>> displayed,
>>>>> >> so I don't know why Saiku is doing it.
>>>>> >> 3. To get the final report it does fire a single query with all the
>>>>> >> dimensions and measure.
>>>>> >>
>>>>> >>
>>>>> >> - How do I stop saiku to fire intermediatte queries and have it
>>>>> fire only
>>>>> >> the final required query?
>>>>> >>
>>>>> > _______________________________________________
>>>>> > Mondrian mailing list
>>>>> > Mondrian@pentaho.org
>>>>> > http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> >
>>>>> >
>>>>> > _______________________________________________
>>>>> > Mondrian mailing list
>>>>> > Mondrian@pentaho.org
>>>>> > http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> >
>>>>> >
>>>>> -------------- next part --------------
>>>>> An HTML attachment was scrubbed...
>>>>> URL:
>>>>> http://lists.pentaho.org/pipermail/mondrian/attachments/20160320/66599d6e/attachment.html
>>>>>
>>>>> ------------------------------
>>>>>
>>>>> _______________________________________________
>>>>> Mondrian mailing list
>>>>> Mondrian@pentaho.org
>>>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>>
>>>>>
>>>>> End of Mondrian Digest, Vol 111, Issue 11
>>>>> *****************************************
>>>>>
>>>>
>>>
>

[Attachment #5 (text/html)]

<p dir="ltr">Thanks Tom, Let me start the debug logs and check what point saiku is \
stalling, It&#39;s quite late in India, so I let you know my findings tomorrow. \
Thanks!!!</p> <div class="gmail_quote">On 21 Mar 2016 2:12 am, &quot;Tom Barber&quot; \
&lt;<a href="mailto:tom@analytical-labs.com">tom@analytical-labs.com</a>&gt; \
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) Fair enough  \
<div><br></div><div>2) If its not executing a query though, stopping the queries \
won&#39;t help you, I also suspect you can&#39;t do a great deal about it. That said, \
everyone else copes, so I would advise you do a kill -3 on a linux box, or if using \
windows find out where mondrian is hanging because if its not the database query \
speed then its doing something else.</div><div><br></div><div>3) its not just \
metadata it also gathers stats and stuff to formulate the SQL that needs to be \
generated.</div><div><br></div><div>4) See 2.</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 20:32, Ravi Prakash <span dir="ltr">&lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><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&#39;s stalling in between, before it can fire the final query \
which will return the actual report.</p> <p dir="ltr">3. I don&#39;t think it&#39;s \
just Metadata lookup, it&#39;s trying to calculate all the Measures for each \
dimension in the cube, so if I have 15 dimensions it&#39;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&#39;t make sense to me \
because those numbers cannot be displayed on the final report.</p><div><div> <div \
class="gmail_quote">On 21 Mar 2016 1:48 am, &quot;Tom Barber&quot; &lt;<a \
href="mailto:tom@analytical-labs.com" target="_blank">tom@analytical-labs.com</a>&gt; \
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&#39;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: <a \
href="tel:%2B44%280%295603641316" value="+445603641316" \
target="_blank">+44(0)5603641316</a>   </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">&lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.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 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&#39;t think it&#39;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 &lt;<a \
href="mailto:mondrian-request@pentaho.org" \
target="_blank">mondrian-request@pentaho.org</a>&gt; 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 &#39;help&#39; 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 &quot;Re: Contents of Mondrian digest...&quot;<br>
<br>
<br>
Today&#39;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 &lt;<a href="mailto:greenlion@gmail.com" \
                target="_blank">greenlion@gmail.com</a>&gt;<br>
Subject: Re: [Mondrian] Saiku Multiple Queries<br>
To: Mondrian developer mailing list &lt;<a href="mailto:mondrian@pentaho.org" \
                target="_blank">mondrian@pentaho.org</a>&gt;<br>
Message-ID: &lt;<a href="mailto:4F3C8283-ABE4-4984-AC29-4F7320B9BB3A@gmail.com" \
                target="_blank">4F3C8283-ABE4-4984-AC29-4F7320B9BB3A@gmail.com</a>&gt;<br>
                
Content-Type: text/plain; charset=&quot;us-ascii&quot;<br>
<br>
Perhaps try the saiku mailing list.<br>
<br>
Sent from my iPhone<br>
<br>
&gt; On Mar 20, 2016, at 8:01 AM, Ravi Prakash &lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.com</a>&gt; wrote:<br> &gt;<br>
&gt; Hi Guys please help me on this.<br>
&gt;<br>
&gt;&gt; On Fri, 18 Mar 2016 at 15:41 Ravi Prakash &lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.com</a>&gt; wrote:<br> &gt;&gt; Hi Guys,<br>
&gt;&gt;<br>
&gt;&gt; I am facing slowness problem on Saiku, after digging a bit into it, i found \
out<br> &gt;&gt;<br>
&gt;&gt; 1. Saiku fires one query for each dimension in the mondrian cube, it tries \
to calculate all the measures against each dimension.<br> &gt;&gt; 2. These results \
cannot be used in the final report which gets displayed, so I don&#39;t know why \
Saiku is doing it.<br> &gt;&gt; 3. To get the final report it does fire a single \
query with all the dimensions and measure.<br> &gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; - How do I stop saiku to fire intermediatte queries and have it fire only \
the final required query?<br> &gt; \
_______________________________________________<br> &gt; Mondrian mailing list<br>
&gt; <a href="mailto:Mondrian@pentaho.org" \
target="_blank">Mondrian@pentaho.org</a><br> &gt; <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 &lt;<a href="mailto:tom@analytical-labs.com" \
                target="_blank">tom@analytical-labs.com</a>&gt;<br>
Subject: Re: [Mondrian] Saiku Multiple Queries<br>
To: Mondrian developer mailing list &lt;<a href="mailto:mondrian@pentaho.org" \
target="_blank">mondrian@pentaho.org</a>&gt;<br> Message-ID:<br>
            &lt;CAEM=DjPjqNiMaY+MjCwDgX-4C0O522AHU_BXnM=-<a \
href="mailto:U5XettK_7w@mail.gmail.com" \
                target="_blank">U5XettK_7w@mail.gmail.com</a>&gt;<br>
Content-Type: text/plain; charset=&quot;utf-8&quot;<br>
<br>
Its alright, i&#39;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>
&lt;<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>&gt;<br>
 goal, but you can always help by sponsoring the project<br>
&lt;<a href="http://www.meteorite.bi/products/saiku/sponsorship" rel="noreferrer" \
target="_blank">http://www.meteorite.bi/products/saiku/sponsorship</a>&gt;)<br> <br>
On 20 March 2016 at 17:50, Justin Swanhart &lt;<a href="mailto:greenlion@gmail.com" \
target="_blank">greenlion@gmail.com</a>&gt; wrote:<br> <br>
&gt; Perhaps try the saiku mailing list.<br>
&gt;<br>
&gt; Sent from my iPhone<br>
&gt;<br>
&gt; On Mar 20, 2016, at 8:01 AM, Ravi Prakash &lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.com</a>&gt;<br> &gt; wrote:<br>
&gt;<br>
&gt; Hi Guys please help me on this.<br>
&gt;<br>
&gt; On Fri, 18 Mar 2016 at 15:41 Ravi Prakash &lt;<a \
href="mailto:ravi.prakash.shahi@gmail.com" \
target="_blank">ravi.prakash.shahi@gmail.com</a>&gt;<br> &gt; wrote:<br>
&gt;<br>
&gt;&gt; Hi Guys,<br>
&gt;&gt;<br>
&gt;&gt; I am facing slowness problem on Saiku, after digging a bit into it, i<br>
&gt;&gt; found out<br>
&gt;&gt;<br>
&gt;&gt; 1. Saiku fires one query for each dimension in the mondrian cube, it<br>
&gt;&gt; tries to calculate all the measures against each dimension.<br>
&gt;&gt; 2. These results cannot be used in the final report which gets \
displayed,<br> &gt;&gt; so I don&#39;t know why Saiku is doing it.<br>
&gt;&gt; 3. To get the final report it does fire a single query with all the<br>
&gt;&gt; dimensions and measure.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; - How do I stop saiku to fire intermediatte queries and have it fire \
only<br> &gt;&gt; the final required query?<br>
&gt;&gt;<br>
&gt; _______________________________________________<br>
&gt; Mondrian mailing list<br>
&gt; <a href="mailto:Mondrian@pentaho.org" \
target="_blank">Mondrian@pentaho.org</a><br> &gt; <a \
href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> &gt;<br>
&gt;<br>
&gt; _______________________________________________<br>
&gt; Mondrian mailing list<br>
&gt; <a href="mailto:Mondrian@pentaho.org" \
target="_blank">Mondrian@pentaho.org</a><br> &gt; <a \
href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" \
target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br> &gt;<br>
&gt;<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>
</div></div></blockquote></div><br></div>
</blockquote></div>



_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic