[Mondrian] Saiku Multiple Queries

Luc Boudreau lucboudreau at gmail.com
Sun Mar 20 11:05:08 EDT 2016


Reading this should help you get an answer.

http://www.catb.org/esr/faqs/smart-questions.html
On Mar 20, 2016 11: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/7d897e81/attachment.html 


More information about the Mondrian mailing list