[Mondrian] Making Pre-aggregated Tables Work
amits.84 at gmail.com
Sat Apr 2 06:10:22 EDT 2016
Any inputs here? I'm sure having pre-aggregated tables must be a pretty
I'm kind of blocked with this not working.
On Fri, Apr 1, 2016 at 5:34 PM, Tom Barber <tom at analytical-labs.com> wrote:
> I'll extend this post slightly to add:
> We've enabled aggregates in mondrian.properties, and we added a Aggregate
> only measure and using that one forced the use of the aggregate table, so
> the aggregates are being parsed.
> Director Meteorite.bi - Saiku Analytics Founder
> Tel: +44(0)5603641316
> (Thanks to the Saiku community we reached our Kickstart
> goal, but you can always help by sponsoring the project
> On 1 April 2016 at 12:59, Amit Shah <amits.84 at gmail.com> wrote:
>> I have been using Mondrian 4 with Saiku as an OLAP engine. Mondrian is
>> integrated with apache phoenix (version 4.6) as the data source that used
>> apache hbase as the data store. In order to speed up the queries I am
>> trying to make pre-aggregated tables work but for some reason the actual
>> fact table is getting queried. Here's how the mondrian schema definition
>> looks like - http://pastebin.com/xquutKYX.
>> The database schema for the dimension, facts and the pre-aggregated table
>> is shared here - http://pastebin.com/EWhyNLTJ
>> Selecting the total sales measure and the agent id as a row in the saiku
>> builds up a query and tries to execute it on the facts table instead of the
>> pre-aggregated table. The query from the sql logs is
>> DEBUG [mondrian.sql] 850: Segment.load: executing sql [select
>> "AGENTS"."A_ID" as "c0", sum("TRANSACTIONS"."TOTAL_SALES") as "m0" from
>> "TRANSACTIONS" as "TRANSACTIONS", "AGENTS" as "AGENTS" where
>> "TRANSACTIONS"."AGENT_ID" = "AGENTS"."A_ID" group by "AGENTS"."A_ID"]
>> What could be missing in order to make the OLAP engine to use the
>> AG_TER_PRO (pre-aggregated table)?
>> Mondrian mailing list
>> Mondrian at pentaho.org
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian