[Mondrian] Mondrian Digest, Vol 111, Issue 11

Tom Barber tom at analytical-labs.com
Sun Mar 20 16:18:12 EDT 2016


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/20160320/77acb1e7/attachment-0001.html 


More information about the Mondrian mailing list