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

kCheng xwcheng at gmail.com
Tue May 26 22:01:31 EDT 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090527/85b5a546/attachment.html 


More information about the Mondrian mailing list