[Mondrian] Few questions about "lost" dimensions aggregate tables

Robin Tharappel rtharappel at gmail.com
Wed May 27 10:26:28 EDT 2009


Mondrian would use your aggregate table below to resolve a MDX query
that only had Location and/or Product dimension (at any level) and the
measure specified. 7.1  In general, Mondrian chooses the aggregate
table with the fewest rows, which is typically the aggregate table
with the fewest extra dimensions. Below is a link describing the
process in which aggregate tables are selected to resolve an MDX:

http://mondrian.pentaho.org/documentation/aggregate_tables.php#Choosing_between_aggregate_tables






On Tue, May 26, 2009 at 9:01 PM, kCheng <xwcheng at gmail.com> wrote:
> Hi All,
>        Suppose there is a fact table has below definition :
>
> Fact Table :
> time_id,
> location_id,
> product_id,
> measure
>
> so one possible aggregate table would be(lost time dimension) :
>
> location_id,
> product_id,
> measure
>
>
> I have two questions
> 1: When there is query only takes with  one dimension attribute(for example
> : location_id, measure), does mondrian would use this aggregate table or
> not?
> 2: The location and product dimensions has more than one levels(just the
> same as foodmart sample data), does mondrian would always using this
> aggregate table
> for every MDX query contains levels from location and product dimension.
>
>
> thanks,
> kcheng
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>




More information about the Mondrian mailing list