[Mondrian] Mondrian Digest, Vol 111, Issue 11

Ravi Prakash ravi.prakash.shahi at gmail.com
Sun Mar 20 16:47:26 EDT 2016


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 at 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 at 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 at 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 at 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 at pentaho.org> wrote:
>>>>
>>>>> Send Mondrian mailing list submissions to
>>>>>         mondrian at 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 at pentaho.org
>>>>>
>>>>> You can reach the person managing the list at
>>>>>         mondrian-owner at 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 at gmail.com>
>>>>> Subject: Re: [Mondrian] Saiku Multiple Queries
>>>>> To: Mondrian developer mailing list <mondrian at pentaho.org>
>>>>> Message-ID: <4F3C8283-ABE4-4984-AC29-4F7320B9BB3A at 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 at gmail.com> wrote:
>>>>> >
>>>>> > Hi Guys please help me on this.
>>>>> >
>>>>> >> On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <
>>>>> ravi.prakash.shahi at 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 at 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 at analytical-labs.com>
>>>>> Subject: Re: [Mondrian] Saiku Multiple Queries
>>>>> To: Mondrian developer mailing list <mondrian at pentaho.org>
>>>>> Message-ID:
>>>>>         <CAEM=DjPjqNiMaY+MjCwDgX-4C0O522AHU_BXnM=-
>>>>> U5XettK_7w at 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 at 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 at gmail.com>
>>>>> > wrote:
>>>>> >
>>>>> > Hi Guys please help me on this.
>>>>> >
>>>>> > On Fri, 18 Mar 2016 at 15:41 Ravi Prakash <
>>>>> ravi.prakash.shahi at 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 at pentaho.org
>>>>> > http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>> >
>>>>> >
>>>>> > _______________________________________________
>>>>> > Mondrian mailing list
>>>>> > Mondrian at 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 at pentaho.org
>>>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>>>
>>>>>
>>>>> End of Mondrian Digest, Vol 111, Issue 11
>>>>> *****************************************
>>>>>
>>>>
>>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20160321/e3cfd37d/attachment-0001.html 


More information about the Mondrian mailing list