[Mondrian] Mondrian Digest, Vol 111, Issue 11

[Ravi Prakash]

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/0b8af54a/attachment.html