[Mondrian] Mondrian Digest, Vol 111, Issue 11

Sun Mar 20 16:32:37 EDT 2016

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/932b3120/attachment-0001.html 